OSWAAL BOOKS“Oswaal House” 1/11, Sahitya Kunj, M.G. Road, AGRA-282002Ph.: 0562-2857671, 2527781, Fax : 0562-2854582, 2527784

email : contact@oswaalbooks.com, website : www.oswaalbooks.com

Published by :

with Complete SolutionsQUESTION BANK

Includes CBSE Solved Paper with Marking Scheme -2016

CLASS 12

Informatics PracticesStrictly Based on the Latest Syllabus issued by CBSE Board

For

MARCH2017Exam

© Publisher

Oswaal Books

20

05

OUR DISTRIBUTORS

CONTENTS

l Syllabus v - viii

l Solved Paper 2016 (Delhi & Outside Delhi Set

with CBSE Marking Scheme)* 9 – 31

q Unit - 1

Networking and open standards 1 - 20

q Unit - 2

Programming 21 - 53

q Unit - 3

Database & MySql 54 - 87

q Unit - 4

Internet Applications 88 - 95

qq

Note : *Detailed answers of Solved Paper, 2016 are given within the book in their respective Chapters/Topics.

( iii )

CBSE always believes in Global Trends of Educational Transformation. The CBSE

curriculum gets its lead from National Curriculum Framework – 2005 and Right to Free and

Compulsory Education Act – 2009. The aim of CBSE Curriculum is not just to let learners

obtain basic knowledge but to make them life-long learners. CBSE always updates and

reviews the syllabus to make it more relevant with educational transformation and in last

few years the chapters and topics which CBSE has added are very interesting and increase

practical knowledge.

Oswaal Question banks are designed to nurture individuality and thus enhance

one's innate potentials which helps in increasing the self-study mode for students. This

book strengthens knowledge and attitude related to subject. It is designed in such a way

that students can set their own goals and can improve their problem solving and thinking

skills.

The Journey of this book is never ending as this book is reviewed every year and

new questions, previous year's examination questions, new HOTS or any change in

syllabus is updated time to time. Also regular review and reader's feedback increases the

efficiency of this book gradually.

Moreover every Question Bank strictly follows the latest syllabus and pattern, and

contains more than sufficient questions and brief description of chapters, which help

students in practicing and completing the syllabus. Higher Order Thinking Skills (HOTS)

questions, Value Based Question, Previous Year Questions and Important Questions from

NCERT makes this book complete and very efficient. Solutions are always checked twice

and tried to make precise as per marking scheme. Practically, this book provides students

everything they need to learn.

At last we would like to thank our authors, editors, reviewers and specially students

who regularly send us suggestions which helps in continuous improvement of this book

and makes this book stand in the category of “One of the Best”. Wish you all Happy

Learning.

–Publisher

PREFACE

(iv)

( v )

LATEST SYLLABUS For Academic Year - 2016-17

INFORMATICS PRACTICES – (Code No. 065) CLASS XII

Unit TopicPeriod

Total PeriodsTheory Practical

1 Networking and Open Standards 20 04 24

2 Programming 46 44 90

3 Relational Database Management System 50 40 90

4 IT Aplications 10 26 36

Total 126 114 240

UNIT 1 : Networking and Open Standards

Computer Networking :

Networking : a brief overview,

Communication Media : Wired Technologies – Co-Axial, Ethernet Cable, Optical Fiber; Wireless Technologies – Blue Tooth, Infrared, Microwave, Radio Link, Satellite Link;

Network Devices : Modem, Hub, Switch, Repeater, Gateway – and their functions

Types of network : LAN, MAN, WAN, PAN;

Network Topologies : Star, Bus, Tree

Network Protocols : HTTP, TCP/IP, PPP, Remote access software such as Team Viewer;

Identifying computers and users over a network : Basic concept of domain name, MAC (Media Access Control), and IP Address, domain name resolution

Network security threats : denial of service, intrusion problems, snooping, eavesdropping

Internet Applications : SMS, Voice Mail, Electronic Mail, Chat, Video Conferencing

Wireless/Mobile Communication : GSM, CDMA, WLL, 3G, 4G

Network Security Concepts : Cyber Law, Firewall, Cookies, Hackers and Crackers

Open Source Concepts :

Open Source Software (OSS), common FOSS/FLOSS examples (GNU/Linux, Firefox, OpenOffice, Java, Netbeans, MySQL), common open standards (HTML, XML, ODF, TCP, IP)

Indian Language Computing : character encoding, UNICODE, different types of fonts (open type vs true type, static vs dynamic), entering Indian Language Text – phonetic and key map based, Inscript.

( vi )

UNIT 2 : Programming

Review of Class XI; Programming Fundamentals

(Refer to Appendix A for Swing Control Methods & Properties, and Appendix B for sample guidelines of GUI Programming)

Basic concept of class, object, inheritance and polymorphism. Commonly used libraries : l String class and methods: toString(), concat(), length(), toLowerCase(), toUpperCase(), trim(),

substring() l Math class methods: pow(), round() Accessing MySQL database using JDBC to connect with database. Web application development: URL, Web server, Communicating with the web server, concept

of Client and Server Side HTML based web pages covering basic tags – HTML, TITLE, BODY, H1..H6, B, I, U, CENTER,

COMMENT, IMG, ANCHOR(A), Paragraph (P), Line Break (BR), Section Separator (HR), FONT, TABLE, LIST (UL, OL), FORM

Creating and accessing static pages using HTML and introduction to XML

UNIT 3 : Relational Database Management System

Review of RDBMS from Class XI Database Fundamentals Concept of Database transaction, Committing and revoking a transaction using COMMIT and

ROLLBACK and savepoint. Grouping Records : GROUP BY, Group functions - MAX(), MIN(), AVG(), SUM(), COUNT();

using COUNT(*), DISTINCT clause with COUNT; Group Functions and Null Values. Displaying Data From Multiple Tables : Cartesian product, Union, Intersection concept of

Foreign Key, Equi-Join Creating a Table with PRIMARY KEY and NOT NULL constraints,Viewing Constraints, Viewing

the Columns Associated with Constraints using DESC command. ALTER TABLE for l deleting column(s), modifying data type(s) of column(s), l adding a constraint, enabling constraints, dropping constraints. DROP Table for deleting a table

UNIT 4 : IT Applications

Front-end Interface: Introduction; content and features; identifying and using appropriate component (Text Box, Radio Button, CheckBox, List etc. as learnt in Unit 2 (Programming)) for data entry, validation and display.

Back-end Database: Introduction and its purpose, exploring the requirement of tables and its essential attributes.

Front-End and Database Connectivity: Introduction, requirement and benefits Demonstration and development of appropriate Front-end interface and Back-end Database for

e-Governance, e-Business and e-Learning applications Impact of ICT on society: Social, environmental and Economic benefits. In each of the above domains, identify at least two real-life problems, list the expected outputs and

the input(s) required for the output, and describe the problem solving approach and develop relevant front-end interface and back-end database.

( vii )

COURSE DESIGNCLASS XII (PRACTICAL) (2016-17)

S. No. Description Marks

1 Problem solving using Java 10

2 SQL Queries 5

3 Practical Record :

Identify Network configuration and OSS used in school

Simple problems using IDE Java and database connectivity

SQL Queries

Webpage design

1

2

1

2

6

4 Project Work : IT Applications 5

5 Viva Voce 4

Total 30

Evaluation of Practical Examination

1. Problem solving using Java

Student is required to solve programming problems based on all concepts covered in theory throughout the year and maintain a record of these in the practical file.

Student will be given a problem to be solved using Java during final practical examination to be conducted at the end of the academic session.

2. SQL Queries

Students will be practicing SQL queries in MySQL throughout the year alongwith course coverage in theory.

Student will be asked to write four queries based on one or two tables during final practical examination to be conducted at the end of the academic session

3. Practical Record File

A practical record file is required to be created during the entire academic session. It should be duly signed by the concerned teacher on regular basis and is to be produced at the time of Final Practical Examination for evaluation. It should include the following :

At least 12 solutions of simple problems using IDE based Java (refer to Appendices ‘A‘ & ‘B‘) and Solution of at least 2 simple problems incorporating Java Application & Database connectivity

Network Configuration and open source software used in your school.

At least 24 SQL queries based on one and/or two tables

At least two web pages using HTML

4. Project File

Students in group of 2-3 are required to work collaboratively to develop a project using Programming and Database skills learnt during the course. The project should be an application in any one of the domains – e-Governance, e-Business and e-Learning - with GUI front-end and corresponding database at the back-end.

5. Viva Voce

Students will be asked oral questions during practical examination to be conducted at the end of the course. The questions will be from the entire course covered in the academic session.

( viii )

Question Paper DesignClass - XII (2016-17)

S. No.Typology ofQuestions

VeryShort

Answer(VSA)

(1 mark)

ShortAnswer-I

(SA-I)(2 marks)

ShortAnswer-II

(SA-II)(4 marks)

LongAnswer

(L.A)(6 marks)

TotalMarks

%Weightage

1 Knowledge Based 4 3 2 — 18 25.7

2 Conceptual

Understanding

4 5 1 — 18 25.7

3 Reasoning Based 4 — 2 1 18 25.7

4 Skill based — 1 2 1 16 22.9

Total Marks 12 9 7 2 70(30) 100

1. No chapter wise weightage. Care to be taken to cover all the chapters. 2. The above template is only a sample. Suitable internal variations may be made for generating

similar templates keeping the overall weightage to different form of questions and topology of questions same.

3. Questions may be case based requiring problem solving skills. 4. LA Questions may be case-based requiring problem–finding and problem –solving skills.

qq

SOLVEDPAPERWith CBSE

Marking Scheme

C.B.S.E.2016

Class–XIIDelhi & Outside Delhi Set

Informatics Practices

Time allowed : 3 Hours Max. Marks : 70

General Instructions : (i) All question are compulsory.

(i) Answer the questions after carefully reading the text.

SECTION A

Delhi Set Code No. 90/1

1. (a) Two doctors have connected their mobile phones to transfer a picture file of a person suffering from a skin disease. What type of network is formed ? Which communication media out of Coaxial cable, Optical fiber, Bluetooth, Satellite link should be used to transfer the file ? 2

(b) State reason why Star topology requires more cable length then Bus topology. 2 (c) "Open Source Software developers work for the good of community." Is this statement true ? Give reason. 2 (d) What happens during 'Domain Name Resolution' ? 2 (e) How is 'Denial of Service' Attack, a threat to Network Security ? 2 2. (a) Identify the odd one out of the following statements. State reason for your choice. 1 (i) Switch (ii) do while (iii) While (iv) for (b) What is the difference between set Visible() and set Enabled() methods ? 1 (c) What is the difference between the following statements (i) and (ii). 1 (i) a=5; (ii) if(a = = 5) x=3;

(d) Write the output in jTextField 1 if depcode is 3. 1 switch (depcode)

{

case 1 :

allowance=4000;

break;

case 2 :

allowance=3200;

break;

default :

allowance=1000;

}

jTextFieldl.setText(" " +allowance);

(e) Sandhya is creating a webpage, She is entering HTML code on her computer. In between , she keeps pressing 'Refresh' / 'Reload' button on her browser. What is the purpose ? 2

(f) What does 'XML' stand for ? How is the purpose of HTML different from XML ? 2 (g) Write Java code (statements) to declare Y as integer variable. Then, assign the value 30 to a variable Y. Increase

the value of Y by 5 and store the increased value in Z. 2

continue

PRODUCT NOT FOUND!

Product not found!

School BooksOswaal BooksClass 9th BooksClass 10th BooksClass 11th BooksClass 12th Books

Engineering BooksRGPV Books & NotesVT U Books & NotesFree Engineering BooksInformation T echnology BooksElectrical Engineering Books

Competitive ExamsBank PO Exam

Login | Register 0

Search by Title / Author / ISBN / Description

Gate BooksT eaching Exams BooksAIEEE-NIT -JEE MAINS BooksUPSC Books

Professional CoursesICSI Books & Study MaterialsChartered Accountant BooksCompany Secretary BooksICSI 7 days T rialLatest Scanners

About KopyKitab.com

Kopykitab is India's 1st digital & multiple publishers platform. Kopykitab has largest collection of e-textbooks &branded digital content in Higher & School education. We have strong foundation of leading publishers &tutorials as content partners.

We offer e-textbook, Test Preparation, Notes & LMS for various curriculam to Students, Professionals &Institutes. These are same textbooks, way smarter. Our goal is to make education affordable & accessible.A user can access the content in all electronic devices e.g. Mobile, PC & Tabs

Informat ion

About Us

FAQ

Privacy Policy

T erms & Conditions

Payment Information

Links

ICSI eLibrary

KopyKitab eBook Reader

Contact Us

Site Map

My Account

Refer & Earn

My Account

Order History

Wish List

Newsletter

My Library

Office 365 Email Login

Google Login

Verified By

©2016 DigiBook Technologies (P) Ltd, All Rights Reserved. An ISO 9001:2008 Certified Company