strictly based on latest syllabus issued by cbse...bellary om pustak mandirpragati book stall, p....

Strictly Based on Latest Syllabus Issued by CBSEfor 2016 Examination

SAMPLEQUESTION

PAPERSINFORMATICS PRACTICES

OSWAAL CBSE

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

email : [email protected], website : www.oswaalbooks.com

Published by :

CLASS

11

OSWAAL BOOKS

© Publisher

10

10

ANDAMAN & NICOBARPORT BLAIR Mitali Enterprises, P. (03192) 230749 Kumar General Store, P. 9932082455

ANDHRA PRADESHGUNTOOR Y. Renuka Devi, P. (0863) 2252308 HYDERABAD Himalaya Book World, P. (040) 24732057, 66822350 Unique Book World, P. (040) 40061423 Shri Balaji Book Depot, P. (040) 27613300 UBS Publisher & Dist., P. 9951078309VIJAYWADA Sri Kanka Durga Book Stall, P. 09849144007VISHAKHAPATNAM JBD Educational, P. (0891) 6666062, 6666068 Sri Rajeshwari Book Link, P. (891) 6661718

ASSAMGUWAHATI Book Emporium, P. 9864057226 UBS Publisher, P. 9401154448 UBS Publisher & Dist., P. 9401154448

BIHARBHAGALPUR Sanjay Book Store, P. (0641) 3202714, 2424830PATNA Gyan Ganga, P. (0612) 2268394, 2263011 Nova Publisher & Distributors, P. (0612) 2666404 UBS Publisher, P. 9835210136 Shri Durga Pustak Mandir, P. (0612) 2301704 Vikas Book Depot, P. (0612) 2304753 Sharda Pustak Bhandar, P. (0612) 2300600 Bokaro Student Friends, P. 09334259293MUNGER New Aman Book & Stationers, P. (06344) 220757MUZAFFARPUR Pustak Bhandar, P. 9097046555 CHATTISGARHDURG Bhagwati Bhawani Book Depot, P. (0788) 2327620RAIPUR Shri Ramdev Traders, P. (0771) 2533465

DELHIDELHI Mittal Books, P. (011) 23288887 UBS Publisher, P. (011) 23273601 R.D.Chawla & Sons, P. (011) 23282360, 23282361

GOAGOA Golden Heart Emporium, P. (0832) 2725208, 3257383

GUJRATAHMEDABAD Tushar Book, P. (079)26578741, 26587103 Agrasen Book & Stationery, P. (079) 27486239 Uppal Brothers, P. (079) 30421199Ballabh Vidya Nagar Ajay Book Store, P. (02692) 238237Navsari College Store, P. (02637) 258642VAPI Vinay General Store, P. 9925817463 SURAT Shopping Point, P. (0261) 2230097

HARYANAGURGAON Adlakha Stationery, P. (0124) 2306991

JHARKHANDRANCHI Gyan Ganga Ltd., P. (0651) 2563570 Bokaro Student Friends, P. (0651) 221244DHANBAD Bokaro Student Friends, P. (0362) 2302493BOKARO Bokaro Student Friends, P. (06542) 234706

KARNATAKABANGALORE Balaji Book Centre (Mahaveer Jain) P. (080) 23331259 Vasanta Book House, P. (080)22216342 Madhu Book House, P. 9845568922 Maruti Book Centre, P. (080) 40124558 Sri Sai Ram Book House, P. (080) 22111243 Sri Balaji Books & Stationers, P. (080) 22117659 Sapna Book House – (Gandhinagar, P. (080)

40114455), (Sadashivnagar, P.(080)41236271), (Jayanagar, P.(080)49066700) (Koramangala, P. (080) 40839999), (Residency Road, P. (080) 49166999), (Indiranagar, P. (080) 40455999), (Bannerghatta Road, P. (080) 42566299), (Nagavara, P. (080) 67294151)

UBS Publisher & Dist., P.. 9341621469BELLARY Pragati Book Stall, P. (08392) 272727 Chaitanya Agency and Books, P. 8277477778 DAVANGERE Laxmi Agencies, P. (08192) 231271 HUBLI Radhika Book Depot, P. (0836) 4257624 Sapna Book House, P. (0836) 4249999MANGALORE School Book Co., P. (0824) 2496938, 4281777 Sapna Book House, P. (0824) 4232800MYSORE Sapna Book House, P. (0821) 4004499

KERALACALICUT Aman Book Stall, P. (0495) 3048187, 2721282ERNAKULAM H & C Store, P. (0484) 2377235 Orient Book House, P. (0484) 2370431 Academic Book House, P. (0484) 2376613 Surya Book House, P. (0484) 2363721 UBS Publisher & Dist., P. (0484) 2353901KOTTAYAM H &C Store, P. (0481) 2304351 BOOK Centre, P. (0481) 2566992KOZHIKODE T.B.S. Publishers, P. (0495) 2721025, 2720085THRISSUR Giftalia Book Bhawan, P. (0487) 2442290TRIVANDRUM Acedemic Book House, P. (0471) 2333349

MADHYA PRADESHGWALIOR Krishna Sons, P. (0751) 2320431INDORE Arun Prakashan, P. (0731) 2454372, 2459448, 3244544 Akruti Publishing House, P. (0731) 2456024, 25 Student Book Depot. P. (0731) 2535892 S.P.& Sons. P. (0731) 2452680BHOPAL UBS Publisher & Dist., P. 97547535412JABALPUR Sangam General Store, P. (0761) 2313592, 6538467 Akash Book Distributor, P. (0761) 4063099KATNI Agrasen Stationers, P. (07622) 403377REWA Siddharth Enterprises, P. (07662) 404019 UJJAIN Sri Nath Book Depot, P. (0734) 2556903, 2556902

MAHARASHTRAAHMEDNAGAR Heera Stationers, P. (0241) 2418774AKOLA Book Emporium, P. (022) 2436460 Rathi Paper Traders, P. (0724) 2452679, 2452979AURANGABAD Maya Book Centre, P. (0240) 2360150 BHUSAWAL Anil Book Depot, P. (02582) 225412CHANDRAPUR Novelty Book Depot, P. (07172) 277418 JALGAON Sharma Book Depot, P. (0257) 6958794 Vidyadhan Book House, P. (0257) 2225548KOLHAPUR Jai Book Co., P. (0231) 2651008 MUMBAI Shivam Book & Stationer, P. (022) 28381014, 28236000 Reshma Agency, P. (022) 23070853NAVI MUMBAI Krishna Book Store, P. (022) 27744962, 32980838NAGPUR Novelty Book Depot, P. (0712) 2534884 Vijay Book Depot, P. (0712) 2534217, 2520496 Shree Balaji Agency, P. (0712) 2452361 UBS Publisher & Dist., P. (0712) 6437909, 2736010NANDED India Book Agencies, P. 9890489460 Vijay Book Centre, P. 9872994436PUNE Sai Shubham, P. (020) 69498635, 9975687687 UBS Publisher & Dist., P. 9860288838SOLAPUR Mahavir General Store, P. (0217) 2723405WARDHA Unique Traders, P. (07152) 243617, 9960644752YAVATMAL Dilip Book Agencies, P. (07232) 245450

ODISHABHUBANESWAR Sagar Book Store, P. (0674) 2516040, 2506040 Pragnya Book Store, P. (0674) 2405757 UBS Publishers & Dist., P. (0674) 2314446

PUNJABBARNALA Bhaian Di Hatti, P. (01679) 2321717BHATINDA Janta Book Depot, P. (0164) 2253993 Krishna Book Depot, P. (0614) 2237611LUDHIANA Chhabra Book Depot, P. (0161) 2405427 Amit Book Depot, P. (0161) 2727038 Bhatia Book Centre, P. (0161) 2747713

RAJASTHANBHARATPUR Sunil Book Centre, P. (05644) 233777, 220650 BHILWARA Nakode Book Depot, P. (01482) 239653JAIPUR Goyal Book Distributors, P. (0141) 2571673

SIKKIMGANGTOK Kwality Store, P. (03592) 202992

TAMIL NADUCOIMBATORE UBS Publisher & Dist., P. (0422) 2499914 Sapna Book House, P. (0422) 4629999CHENNAI Indian Book House, P. (044) 24327784 Ruby Books, P. (044) 26425958 UBS Publisher & Dist., P. (044) 2374622TRICHY Rasi Publication, P. (0431) 2703692

TRIPURAAGARTALA Book Corner, P. (0381) 2301945

UTTAR PRADESHAGRA Om Pustak Mandir, P. (0562) 2464014, 3059218 Manav Book Depot, P. (0562) 6545883 Govind Book Store, P. (0562) 2526134ALIGARH Shaligram & Sons, P. (0571) 2421887 ALLAHABAD Mehrotra Book Depot, P. (0532) 2400129, 2266128AZAMGARH Sasta Sahitya Sadan, P. (05462) 224421 BILASPUR Raj Agencies, P. 9412150750BALIA Saraswati Shishu, P. (05498) 221042 Vidya Kendra, P. 9415281234LUCKNOW VBS Publication, P. (0522)4025144MEERUT Mahi Book Palace, P. (0121) 2541791, 2649644 Ideal Book Depot, P. (0121) 2660648NOIDA UBS Publisher & Dist., P. (0120) 4205516VARANASI Bokaro Student Friends, P. (0542) 2401250

WEST BENGALKOLKATA Oriental Publishers, P. (033) 22191591, 22198367 Saha Book House, P. (033) 22193671 Eureka Book Emporium, P. (033) 25934001 Katha–O–Kahani Pvt. Ltd., P. 22419071, 22196313SILIGURI Agarwal Book House, P. (0353) 2535274

CONTENTS

Syllabus 5 - 8

Sample Question Papers (Solved)

Sample Question Paper - 1 9 - 12





Sample Question Papers for Self Assessment






Solutions






* SOLUTIONS for Sample Question Paper 6 to 10 can be downloaded from

www.OswaalBooks.com

( iii )

SYLLABUS COURSE DESIGN - 2015-16

INFORMATICS PRACTICES – (Code No. 065)CLASS XI

Learning Outcomes : Sound knowledge of computer system. Ability to develop application using simple IDEs. Ability to use, develop & debug programs independently. Ability to store and retrieve data using an RDBMS.

Unit TopicPeriods

MarksTheory Practical Total

1 Introduction to Computer systems 20 08 28 10

2 Introduction to Programming 45 42 87 25

3 Relational Database Management System 50 45 95 30

4 IT Applications 10 20 30 05

Total 125 115 240 70

UNIT 1 : Introduction to Computer Systems

Hardware Concepts : Computer organization (basic concepts) : CPU, Memory (RAM and ROM), I/O devices,

communication bus, ports (serial, parallel), device specific ports; Input devices : Keyboard, Mouse, Light pen, Touch Screen, Graphics Tablet, Joystick, Microphone,

OCR, Scanner, Smart Card reader, Barcode reader, Biometric sensor, web camera; Output Devices : Monitor/Visual Display Unit (VDU), LCD screen, Television, Printer (Dot Matrix

printer, Desk jet/ Inkjet/ Bubble jet printer, Laser printer), Plotter, Speaker; Secondary Storage Devices : Floppy Disk, Hard Disk, Compact Disk, Magnetic Tape, Digital

Versatile Disk (DVD),Flash Drive, Memory cards. Comparative properties of storage media; Memory Units : bit, Byte (Kilobyte, Megabyte, Gigabyte, Terabyte, Petabyte) Encoding scheme : ASCII,ISCII & UNICODE e-waste disposal. Security of computer system : Sources of attack and possible damages, malware – virus, worms,

spyware and cookies as security threat, malware detection using a tool. Computer security, digital certificate, digital signature, firewall, password, file access permissions

Types of Software : (a) System Software : (i) Operating systems : Need or operating system, major functions of Operating System;

Examples of OS for mainframe, PC/Server, and mobile devices. (ii) Language Processors : Assembler, Interpreter, and Compiler

6 | OSWAAL CBSE Sample Question Paper Informatics Practices, Class – 11

(b) Utility Software : Compression tools, disk defragmenter, anti-virus (c) Application Software : (i) General Purpose Application Software : Word Processor, Presentation Tool, Spreadsheet

Package, Database Management System, Integrated Development Environment (IDE) (ii) Specific Purpose Application Software : Inventory Management System, Purchasing

System, Human Resource Management System, Payroll System, Financial Accounting, Hotel Management and Reservation System etc.

UNIT 2 : Introduction to Programming

Getting started with Programming using IDE Introduction, Rapid Application Development using IDE (Integrated Development Environment

such as Netbeans; Familiarization of IDE using basic Interface components- Label, Text Field, Text Area, Button, Check box, Radio Button. (As per appendix A)

Developing General Application (As per the guidelines at appendix B) - Getting Familiar with Java Swing User Interface components-Frame, Dialog, Option Pane, Panel, Scroll Pane, Label, Text Field, Password Field, Text Area, Button, Check Box, RadioButton, ComboBox, List

Basic component handling methods and properties : set Text (), get Text (), is Selected (), set Selected ()

Programming Fundamentals Data Types : Concept of data types; Built-in data types - byte, short, int, long, float, double, char,

string, boolean Variables : Need to use variable, declaring variables, variable naming convention, assigning

value to variables; Integer object method: parselnt Double object method: parseDouble, parseFloat Control Structures: Decision Structure – if, if-else, switch; Looping Structure- while, do . . while, for; Programming Guidelines : General Concepts; Modular approach; Stylistic Guidelines: Clarity and simplicity of expressions and names; Comments, Indentation; Running and debugging programs, Syntax Errors, Run-Time Errors, Logical Errors; Problem Solving Methodology: Understanding of the problem, Identifying minimum number of

inputs required for output, breaking down problem into simple logical steps.

UNIT 3 : Relational Database Management System

Database Management System Introduction to database concepts : Database, Relational database, Relation/Table, Attribute/

Field, Tuple / Row; Data Types : Text (CHAR, VARCHAR), Number (DECIMAL, INT/INTEGER), Date and Time Keys : Candidate key, Primary key, Alternate key, Foreign key; Examples of common Database Management System : MySQL, Ingres, Postgres, Oracle, DB2,

MS SQL, Sybase etc.; Common Database management tools for mobile devices. Introduction to MySQL (ANSI SQL 99 standard commands) Classification of SQL Commands : DML - SELECT, INSERT, UPDATE, DELETE DDL - CREATE, DROP, ALTER Creating and using a database : SQL CREATE command to create a database, USE command to

select a database.

Syllabus | 7

Creating a table : CREATE command to create a table, DESC command to display a table structure, INSERT command for inserting new rows, inserting new rows with null values and values of all the studied data types.

Displaying table data : SELECT command for selecting all the columns, selecting specific column(s) using arithmetic operators, operator precedence

Defining and using column alias Eliminating duplicate values from display using DISTINCT keyword Limiting rows during selection (using WHERE clause) Using Comparison operators - =, <, >, <=, >=, <>, BETWEEN, IN, LIKE(%,_); Logical Operators –AND, OR, NOT and corresponding operator precedence; Working with NULL values. ORDER BY clause : Sorting in Ascending/Descending order, sorting by column alias name,

sorting on multiple columns; Manipulating Data of a Table/Relation : Update command to change existing data of a table,

Delete command for removing row(s) from a table. Restructuring a table : ALTER TABLE for adding new column(s) and deleting column (s); Functions in MySQL : String Functions : ASCII(), CHAR(), CONCAT(), INSTR(), LCASE(), UCASE(), LEFT(), LOWER(),

LENGTH(), LTRIM(), MID(), RIGHT(), RTRIM(), SUBSTR(), TRIM(), UPPER(), ASCII() Mathematical Functions : - POWER(), ROUND(), TRUNCATE(). Date and Time Functions : CURDATE(), DATE(), MONTH(), YEAR(), DAYNAME(),

DAYOFMONTH(), DAYOFWEEK(), DAYOFYEAR(), NOW(), SYSDATE().

UNIT 4 : IT Applications

e-Governance : Definition, benefits to citizens, e-Governance websites and their salient features and societal impacts; e-Governance challenges.

e-Business : Definition, benefits to customers and business, e-Business websites and their salient features and societal impacts; netbanking, mobile banking e-Business challenges.

e-Learning : – Definition, benefits to students (learners), teachers (trainers) and school (Institution) management; MooCs (Massive Open Online Courses) ; e-Learning websites and their salient features and societal impacts; e-Learning Challenges.

In each of the above domains, identify at least two real-life problems, list the input(s) required for the expected output(s), and describe the problem solving approach.

Impact of ICT on society – social environmental and economic benefits infomania.

CLASS XI (PRACTICAL) (2015-16)S. No. Description Marks

1 Problem solving using Java 12

2 SQL queries 4

3

Practical Records :

Application of Productivity Tools (WP, Spread sheets,Presentation)

Simple problems using Java

SQL Queries

IT Applications

2

3

2

3

10

4 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 trying out SQL queries in MySQL throughout the year along with course coverage

in theory. Student will be asked to write 4 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 2 applications using at least two productivity tools in each. At least 10 solutions of simple problems using IDE based Java (refer to Appendices ‘A’ & ‘B’). At least 3 IT applications – problem-solving framework. At least 20 SQL queries on any database. 4. 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. Out of 6 marks, 2 marks are allotted to test student’s understanding of basic computer hardware and their functions.

Question Paper DesignClass - XI (2015-16)

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.

qqq

INFO

RM

ATIC

S PR

ACT

ICES

Osw

aal C

BSE

Clas

s -1

1, Ex

amin

atio

n Sa

mpl

e Q

uest

ion

Pape

r

SAMPLE QUESTION PAPER - 1Solved___________________________________________

Time : 3 Hours Maximum Marks : 70

General Instructions :(i) All questions are compulsory(ii) Answer the questions after carefully reading the text.

1. (a) Give the full form of : 1 (i) ASCII (ii) ISCII (b) Convert the following 1 (i) 4 Gigabyte=_____________Megabyte (ii) 3 Petabyte=_____________Terabyte (c) What is the difference between a compiler and an interpreter? 2 (d) What is digital signature? 1 (e) Why antivirus is essential for computer? 1 (f) How high level language is different from low level language? Also give one example of

each type. 2 (g) Write short note on the following: 2 (i) Utility software (ii) Device driver 2. (a) Differentiate between runtime errors and logical errors. 2 (b) Explain Write Once Run Anywhere characteristics of Java. 2 (c) Write the syntax to declare the variable with following specifications: 2 (i) If you want to store the employee no. of an employee. (ii) If you want to store the name of an employee (d) What is IDE and how it is useful in application development? 1 (e) How are keywords different from variable names? 1 (f) What is meant by case sensitive? Is Java case sensitive? 1 (g) The expression 8%3 evaluates to _______. 1 3. (a) Write any four rules and conventions for naming variables in Java. 2 (b) Rewrite the following while loop with for loop: 2 int s=0;

while(s<=17)

{


if(s%2==2)

{

System.out.println(“hi”);

}

else

{

System.out.println(“Hello”);

}

System.out.println(“welcome”);

s=s+1;

}

(c) Write the output of the following code: 2 int i=0,x=0; do{

if(i%5==0)

{

x++;

System.out.println(x + “\n”);

}

++i;

}while(i<20);

System.out.println(x);

(d) Underline the errors rewrite the correct code 2 private Void jButton1ActionPerformed(java.awt.event.ActionEvent evt)

{

// Code to print natural numbers :

int LastNumber=Integer.ParseInt(jTextField1.getText())

for (int I=1;I<=LastNumber;I++) jTextArea1.SetText(jTextArea1.getText()+ " "+Integer.toString(I));

}

4. Ms. Sunita wants to open a showroom for garments for which she need a GUI billing system so that it can help her at billing counter.

She has given the following rough idea of that GUI interface:

(i) Write the code for clear button. 1 (ii) Write a code for exit button so that the application will close after displaying a message “Visit

Again” in a dialogue box . 1

Sample Question Paper | 11

(iii) Write a code for calculate button to: Ø To ensure that the user provide the billing amount as positive integer if it is negative number

then it will prompt a message which ask the user to re-enter the valid amount 2 Ø To calculate the discount on the billing amount as per the criteria 2

Mode of payment Discount

Cash 8%

Cheque 7%

Credit card Nil

(iv) Calculate the Net amount as 1 Net amount = Bill amount – Discount And display it in respective text box 5. (a) What is DBMS? Discuss its advantages. 2 (b) Write an SQL query to create table “Bank” with the following specifications: 2

Field Type Constraint

Account No Integer Primary Key

Customer Name Varchar (20) Not Null

Address Varchar (30)

Phone No Varchar (10) Not Null

Balance Decimal >=1000

(c) Write the difference between DDL and DML commands of SQL with example. 2 (d) What will be the output of following code? 2 (i) SELECT LOWER(CONCAT('Informatics', 'Practices')); (ii) SELECT INSTR('INFORMATICS PRACTICES','OR'); (e) Explain "Where" and "Like" in SQL. 2 (f) Consider the following table :

Hospital

No. Name Age Department DatoFadm Charges Sex

1 Arpit 62 Surgery 21/01/98 300 M

2 Zareena 22 ENT 12/12/97 250 F

3 Kareem 32 Orthopedic 19/02/98 200 M

4 Arun 12 Surgery 11/01/98 300 M

5 Zubin 30 ENT 12/01/98 250 M

6 Ketaki 16 ENT 24/02/98 250 F

7 Ankita 29 Cardiology 20/02/98 800 F

8 Zareen 45 Gynecology 22/02/98 300 F

9 Kush 19 Cardiology 13/01/98 800 M

10 Shilpa 23 Nuclear Medicine 21/02/98 400 F

Write the SQL commands for: (i) To list the names all the patients admitted after 15/01/98. 1 (ii) To list the names of female patients who are in ENT department. 1 (iii) To list names of all patients with their date of admission in ascending order. 2 (iv) To display Patient's Name, Charges, Age for only female patients. 2


(v) To display the name of all patients whose name starts with "z" and third letter is “t”. 1 (vi) Write a query to display all those patient whose charges is null 1 (vii) Find out the output of following SQL Commands : (A) Select DISTINCT charges from HOSPITAL; 1 (B) Select Age from HOSPITAL where Sex="F"; 1 6. (a) What is the difference between DELETE and DROP command in SQL? 1 (b) Answer the following based on the given table:

Student

Column Name Data Type Size Constraint

Roll_No NUMBER 4 PRIMARY KEY

Name VARCHAR 20 Not Null

Stipend NUMBER 7 Stipend is greater than 0

Stream VARCHAR 15 Not Null

Grade VARCHAR 1

(i) Create the database school and use the same database. 2 (ii) Display all the records of the table Student. 1 (iii) Delete the student whose Roll no is 100. 1 (iv) Change the stream of student to 'Computer' whose Roll no. is 536. 1 (v) Add one column email of data type VARCHAR and size 30 to the table Student. 1 (vi) View structure of the table created by you. 1 (vii) Drop the table student. 1 (viii) Write a query to display the name of all students whose stipend range between 2000 and

5000 both limits included. 1 7. (a) How e-learning benefited the students? 2 (b) What is ICT? What are social impact of ICT? 2 (c) What do you mean by front end and back end? 1

qqq

INFO

RM

ATIC

S PR

ACT

ICES

Osw

aal C

BSE

Clas

s -1

1, Ex

amin

atio

n Sa

mpl

e Q

uest

ion

Pape

r




1. (a) Give the full form of 1 (i) OCR (ii) OMR (b) What is an assembler? 1 (c) What is difference between multi processing operating system and multi programming

operating system? 2 (d) Write two characteristics of RAM? 2 (e) Why firewall is essential for computer? 1 (f) What is difference between data bus and control bus? 1 (g) Write short note on the following: 2 (i) e-waste disposable mechanism (ii) Arithmetical and logical unit 2. (a) Differentiate between implicit casting and explicit casting. 2 (b) Explain the use of different operators with the help of an example (any four). 2 (c) Write the syntax to declare the variable with following specifications: 2 (i) Check whether the value retrieved from the text field (jtextfield1 ) is greater than or

equal to 75 or not. The if statement is used to check the condition and if the condition evaluates to true then the message is displayed in the text area using the setText() method. The '\n' is used to explicitly insert a line break.

(ii) Display "Monday" in the text field if the first radio button is selected (d) What is inspector window? 1 (e) How are text field and text area components are different from one another? 1 (f) What is the purpose of default clause in a switch statement? 1 (g) How many times, the following loop gets executed?Why? 1 i=0;

do

{

//Statements

}while (i> 20);


3. (a) What is difference between do-while and while loop? 2 (b) Rewrite the following switch case with if: 2 String str = jTextField1.getText(); Number = Integer.parseInt(str); Switch (Number) {

case 10:

jTextField1.setText("Ten Thousand");

break;

case 20:

jTextField1.setText ("Twenty Thousand");

case 30:

jTextField1.setText ("Thirty Thousand");

break;

case 40:

jTextField1.setText ("Forty Thousand");

break;

default:

jTextField1.setText ("Not enough!!!");

}

(c) Write the output of the following code: 2 (i) int First = 7; int Second = 73;

First++;

if (First+Second > 90)

jlabel1.setText("value is 90 ");

else

jlabel1.setText("value is not 90 ");

(ii) int Number1 = 7,Number2=8; int Second = 73;

if (Number1>0 || Number2>5)

if (Number1>7)

jTextField1.setText("Code Worked");

else

jTextField1.setText("Code MightWork");

else

jTextField1.setText("Code will not Work");

(d) Underline the errors rewrite the correct code 2 private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {

// Code to multiply Number1 and Number2:

Double Number1,Number2,Result;

Number1=Double.parseDouble(jTextField1.GetText());

double Number2=Double.parseDouble(jTextField2.getText());

Result=Number1*Number2;

jTextField3.setText(Double.ToString(Result));

}


4. Electronic shop has the following products with their price list. Electronic shop give 10% discount on every product, at the festival time shop give additional 7% percent discount.

Product Price

Washing Machine 12000

Color TV 17000

Refrigeratior 18000

CD player 14500

OTG 8000

Control Description

JComboBox Stores the product name

Jpanel Container For Festival and Non festival JRadioButton

JRadioButton1 Festival with buttonGroup1

JRadioButton2 Non Festival with buttonGroup1

txtLPrice List Price Textbox

txtDiscount Discount Textbox

txtNPrice Net Price textbox

cmdList List Price Button

cmdDisc Discount button

cmdNet Net price button

(i) Write the code to disable the text boxes when form is activated. 1 (ii) Write a code for cmdList. 2 (iii) Write a code for cmdDisc. 2 (iv) Write a code for cmdNet. 1 (v) Write a code for exit button 1 5. (a) What is the relationship between a database and a table? 2 (b) Write an SQL query to create the table books with following structure. 2 Field Type Constraints BookID Varchar (5) Primary Key BookName Varchar (20) Author Varchar (20) Price Decimal (5, 2) (c) Difference between CHAR and VARCHAR? 1 (d) What will be the output of following code? 3 (i) SELECT ROUND(6.88,1) ;


(ii) SELECT MID(‘Discovery Channel’,4,6) ; (iii) SELECT DAYOFMONTH (‘2011–03–30‘); (e) Which comparison operator is used for comparing? 2 (i) patterns (ii) character value (iii) null values (iv) ranges (f) Consider the following tables BOOKS. Write SQL commands for the statements (i) to (iv) and

give outputs for SQL queries (v) to (viii). Table : BOOKS

B_Id Book Name Author_Name Publisher Price Type Quantity

C01 Fast Cook Lata Kapoor EPB 355 Cookery 5

F01 The Tears William Hopkins First 650 Fiction 20

T01 My C++ Brain & Brooke FPB 350 Text 10

T02 C++ Brain A.W. Rossaine TDH 350 Text 15

F02 Thuderbolts Anna Roberts First 750 Fiction 50

Write the SQL commands for : (i) To list the names from books of text type. 1 (ii) To display the names and price from books in ascending order of their price. 2 (iii) To increase the price of all books of EPB publishers by 50. 2 (iv) To display the Book_Name, Quantity and Price for all C++ books. 1 Give the output of the following commands : (v) Select Author_name from books where Publishers like ”F%” ; 1 (vi) Select DISTINCT Publishers from books where Price >=400; 1 (vii) Select Book_Name, Author_Name from books where Publishers = ‘First’; 1 (viii) Select BookName,Price from books where type = ‘Text’; 1 6. (a) How would you calculate 5+10 in SQL? 1 (b) What command is used for- 2 (i) To change/open a database (ii) To view the table structure. (c) Consider the following table Games

Games

Student No. Class Name Game Grade 1 SUPW Grade 2

10 7 Sameer Cricket B Photography A

11 8 Sujit Tennis A Gardening C

12 7 Kamal Swimming B Photography B

13 7 Veena Tennis C Cooking A

(i) What is degree and cardinality 2 (ii) Display the names of the student who are getting a grade “C” in either games or SUPW. 2 (iii) Display the different games offered in the school. 2 (iv) Display the names of student whose names starts with “A” 1 7. (a) Define the following- 3 (i) e-Governance (ii) e-Business (iii) e-Learning (b) Give one example of input values, where radio button, check boxes, text field, combo box should

be used for efficiency in the application. 2

qqq

INFO

RM

ATIC

S PR

ACT

ICES

Osw

aal C

BSE

Clas

s -1

1, Ex

amin

atio

n Sa

mpl

e Q

uest

ion

Pape

r




1. (a) Give the full form of 1 (i) BIOS (ii) IDE (b) What is RJ 45 port? 1 (c) What is difference between serial port and parallel port? 2 (d) Explain two secondary storage devices. 2 (e) What is backup utility software? 2 (f) Write short note on the following: 2 (i) Hotel management system (ii) Reservation system 2. (a) What is an event? What is event handler? 2 (b) What is difference between parseInt() and parseDouble() methods? 2 (c) Write the syntax to declare the variable with following specifications: 4 (i) To change the display text of a component (label, text field or button) during run

time. (ii) To retrieve the display text of a component (label, text field or button) at run time. (iii) To concatenate (add) string2 at the end of the string1. (iv) To successfully terminate an application. (d) What is the purpose Button Group? 1 (e) What is difference between = and ==? 1 3. (a) What is difference between runtime and logical error? 2 (b) Rewrite the following switch case with if: 2 switch(jComboBox1.getSelectedIndex())

{

case 0: FinalAmount=BillAmount; //No Discount for new customer

break;

case 1: FinalAmount=0.90*BillAmount; //10% Discount for silver

break;


case 2: FinalAmount=0.80*BillAmount; //20% Discount for gold

break;

case 3: FinalAmount=0.70*BillAmount;//30% Discountfor platinum

break;

default: FinalAmount=BillAmount;

}

(c) What will be the corresponding outputs of the following code segment if the possible inputs in the jTextField1 are : 2

(i) 10 (ii) 20 (iii) 30 (iv) 50 String str = jTextField1.getText();

Number = Integer.parseInt(str);

switch (Number)

{

case 10:

jTextField1.setText("Ten Thousand");

break;

case 20:

jTextField1.setText ("Twenty Thousand");

case 30:

jTextField1.setText ("Thirty Thousand");

break;

case 40:

jTextField1.setText ("Forty Thousand");

default:

jTextField1.setText ("Not enough!!!");

}

(d) Underline the errors and rewrite the correct code 2

int Num = 1;

do

{

jTextArea1.setText(toString(++Num) + "\n");

Num +=1;

}while(Num<=10)

4. Design an application to print the reverse of a number.


(i) Write the code for reverse button 6

(ii) Write a code for exit button 1 5. (a) What is relational data model and network data model. 2 (b) Create a table emp with the following specification and apply at least one constraint in the above

specification and table: 2

Column Name ID First Name Last Name Dept ID

Data Type NUMBER VARCHAR VARCHAR NUMBER

Length 8 25 25 8

(c) What is difference between drop table and drop database ? 1 (d) What will be the output of following code? 3 (i) Select RTRIM('INFORMATICS '); (ii) Select LEFT(‘INFORMATICS PRACTICES’, 3); (iii) Select INSTR(‘Informatics’,’ mat’); (e) Define degree and cardinality? 2 (f) Consider the following tables Activity and answer the following:

A Code Activity Name Participants Num Prize Money Schedule Date

1001 Relay 100×4 16 10000 23-Jan-2004

1002 High Jump 10 12000 12-Dec-2003

1003 Shot Put 12 8000 14-Feb-2004

1005 Long Jump 12 9000 01-Jan-2004

1008 Discuss Throw 10 15000 19-Mar-2004

Write the SQL commands for : (i) To display the name of all activities with their Acodes in descending order. 1 (ii) To display PrizeMoney for each activity. 1 (iii) To display the content of the GAMES table whose ScheduleDate earlier than 01/01/2004 in

ascending order of ParticipantNum. 2 (iv) Display the name of activities whose name starts with 'R' 1 (v) Display the activity name from ACTIVITY table in ascending order of prize amount. 1 (vi) Display all those activities who have 12 participants. 1 Givew the output of the following commands : (vii) SELECT DISTINCT ParticipantsNum FROM ACTIVITY; 1 (viii) SELECT ParticipantsNumFROM ACTIVITY where ScheduleDate> ’15-Jan-2004’; 1 (ix) SELECT PrizeMoney FROM ACTIVITY WHERE ActivityName LIKE “relay”; 1 6. (a) What do you mean by referential integrity ? How is it enforced in databases ? 2 (b) Which command is used to display the system date. 1 (c) Given the following tables: Orders (Ordno, Ord_date, ProdNo, Qty) Product (Prodno,Descp,Price) Payment (OrdNo,Pment) Write query statements for following transaction (i) Increase all the price by 10% . 2 (ii) Modify the definition of column Qty. Increase its size to 2. 2 (iii) Write a command to delete column Qty from table order. 2 (iv) Write a command to add a new column address in Product table. 1

Oswaal CBSE Sample Question PapersFor Class 11 Informatics Practices (

March 2016 Examination )

Publisher : Oswaal Books ISBN : 9789351277347 Author : Panel Of Experts

Type the URL : http://www.kopykitab.com/product/5805

Get this eBook

51%OFF

http://www.kopykitab.com/Oswaal-CBSE-Sample-Question-Papers-For-Class-11-Informatics-Practices-March-2016-Examination-by-Panel-Of-Experts

strictly based on latest syllabus issued by cbse...bellary om pustak mandirpragati book stall, p....

Documents