Home » Sample Papers » Sample Paper Information Practice 11 » Sample Paper of Information Practice 2014 for class 11, CBSE. Paper No.2

Sample Paper of Information Practice 2014 for class 11, CBSE. Paper No.2

Sample Paper – 2014
Class – XI
Subject – INFORMATION PRACTICES

Time Allowed: 3 hours                                                                                          Maximum Marks: 70

 

Note:

  • This question paper is divided into 3 sections.

  • Section A consists of 30 marks.

  • Section B and Section C are of 20 marks each.

  • Answer the questions after carefully reading the text.

  • Give example wherever required.

 SECTION – A

 

   

 

1. Answer the following questions:
  (a) What are the characteristics of Java? Explain any two. 2
  (b) Explain the following:

i)             JVM

ii)           MICR

2
  (c) Briefly explain the type of Computers and its purpose. 2
  (d) Explain the two categories of printers? Write working process of dot-matrix printer. 2
  (e) What is the function of Memory? What are its measuring units? 2
 
2. Answer the following questions:
  (a) What is variable? Write down the rules for naming any variable in Java. 2
  (b) Distinguish between a unary operator and a ternary operator. Give example of each. 2
  (c) Write short note:-

i. Digital Certificate      ii.  Computer Viruses       iii.  Firewall & Cookies

2
  (d) Differentiate between Call by Value and Call by Reference. 2
  (e) Discuss any two properties of Frame component. 2

 

3. Answer the following questions:
  (a) What is primary key and foreign key? 2
  (b) What are advantages of MySQL?(any four points) 2
  (c) What is the difference between DDL and DML? 2
  (d) Define the following term

(i)           Degree

(ii)          Tuple

2
  (e) Differentiate between char and varchar data types in MySQL? 2

 

 

   

SECTION – B

 

4. (a) Read the following case study and answer the questions that follow.

Develop an application that performs the operations like addition and subtraction of two values. The sample screen shot is being shown below:

Object Type Object Name Description
Text Field Value1TextField To enter Numeric Value
Value2TextField To enter Numeric Value
Button AddButton To Provide corresponding action
SubtractButton
ClearButton
Label ResultLabel To display the result

 

 
  1. Write the code segment to add two values for the click on ADD button
  2. Write the code segment to add two values for the click on SUBTRACT button
  3. Write the code segment to clear off the values entered by the user and result generated for the click on CLEAR button.

 

1

 

  (b) Read the following case study and answer the questions that follow.
  Develop an application to prepare students grade on the basis of obtained marks of five entered. The criteria have given below for grade evaluation. A sample screen shot is being shown below.

 

Per Grade
>=90 A
>=75 and <90 B
>=60 and <75 C
>=45 and <60 D
<45 E

Criteria

 

6

 

 

 

 

 

 

 

 

 

 

 

 
 
  • Decide what controls are required, on your own
  • Decide about the number of variables required and their types  on your own.

 

5 Answer the following questions:
  (a) Find the error from the following code segment and rewrite the corrected code underlining the correction made.

int x,y;

x=-20

y=2.9;

z=x+y;

system.out.println(“”+z);

2
  (b) Find the output of the following code segment:

int i,j;

j=0;

for(i=1;i<=5;i++)

{

System.out.println(j+” “);

j+=2;

}

2
  (c) Convert the following code segment into switch case construct

int Choice;

Choice=Integer.parseInt(ChoiceTextField.getText());

If(Choice = = 1)

{

System.out.println(“You Have Opted Arts”);

}

else

{

If(Choice = = 2)

{

System.out.println(“You Have Opted Commerce”);

}

else

{

 if(Choice = = 3)

{

System.out.println(“You Have Opted Science”);

}

else

{

System.out.println(“Invalid Entry”);

}

}

}

2
  (d) Change the following code using do while loop without affecting the output.

int i;

for(i=10;i>=1;i- -)

{

System.out.println(i);

}       

2
  (e) If the value of X is 42 , find the output in Y for the following statement

  1. Y=++X;
  2. Y=X++;
1
  (f) What output will the following code fragment produce

  1. if the input is 2000
  2. if the input is 1000

int val, res, n=1000;

res=n+val>1750?400:200;

System.out.println(res);

 

1
   

SECTION – C

 

6 Consider the following tables EMPLOYEE and write the SQL query for the following requirements.

 

10
 
Eid Name Deptid Qualification Sex Points Basic DA HRA Bonus
1 Deepali 101 MCA F 20 6000 2000 2300 200
2 Rajat 101 BCA M 15 2000 300 300 30
3 Hari 102 B.A M 15 1000 300 300 40
4 Harry 102 M.A M 40 1500 390 490 30
5 Sumit 103 B.Tech M 32 8000 900 900 80
6 Jyoti 101 M.Tech F 12 10000 300 490 89
   

1.    Command for create the above table.

2.    Insert any dummy record.

3.    Display the Names begin with alphabet “H”

4.    Display the records who are females.

5.    Display the name and qualification who are “B. Tech.”

6.   Add one more field for the employee table -DOJ (date of joining)

7.   Do not display the records of “Jyoti”, “Harry”.

8.   Display Name, Deptid and Point, NewScore. The NewScore is a product of Point and 12

9.   Display the Name, deptid, Basic whose date of joining is after 23/09/2000.

10.               Display the records in order according to their Names.

 

7 (a) Write down the output produced by following queries after execution.        (1×5)

 

5
 
  1. SELECT CONCAT(‘PRIYA’,’JAIN’) FROM DUAL;
  2. SELECT SUBSTR(‘INFORMATICS PRACTICES’,3,4) FROM DUAL;
  3. SELECT INSTR(‘INDOOR OUTDOOR’,’OR’) FROM DUAL;
  4. SELECT LENGTH(‘INFORMATICS PRACTICES’) FROM DUAL;
  5. SELECT MOD(11,3) FROM DUAL;
  (b) Write the Short notes on following
 
  1. E-Governance
  2. E-Business
  3. E-Learning
2

2

1

About

The main objective of this website is to provide quality study material to all students (from 1st to 12th class of any board) irrespective of their background as our motto is “Education for Everyone”. It is also a very good platform for teachers who want to share their valuable knowledge.

Leave a Reply

Your email address will not be published. Required fields are marked *