CBSE Class 11 Informatics Practices Sample Paper Set 24

Q1. (a) Name the basic units of a computer system. 

(b) What is an Operating System. Name any two example. 

(c) Give one point of difference between OCR and OMR. 

(d) What is a port ? Name any two port types. 

(e) Write any one advantage of TFT display. 

(f) What do you understand by Computer Security ? Name any two threats to computer security.

(g) Why IDE are useful in application development. 

Q2. (a) What is the role of JVM in platform independence in Java. 

(b) Give the syntax and example of declaring variable. 

(c) Give any two properties of TextField control in java. 

(d) Differentiate between the following : 

(i) if and switch (ii) runtime errors and logical errors

(e) What will be the value of following expressions if j=5, 

(1) (5*++j)%6 (2) (5*j++)%6

(f) Why program maintenance is considered very important. 

Q3. (a) What is SQL ? What are the different categories of SQL commands. 

(b) Name all the integrity constraints used during table creation. 

(c) Describe the following commands with syntax and example:

(i) insert command 

(ii) update command 

(e) When a column value is skipped in an insert command , which value is inserted 

in the table.

(d) A table has 5 columns and 10 rows. What is its degree and cardinality. 

(e) Give one point of difference between the primary key and foreign key. 

Q4. (a) Write a program in java to calculate the sum of all the no. divisible by 5 in the range 1 to 50.

(b) Write the output of the following code:

int i=0,x=0;

do{

if(i%5==0){

x++;

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

}

++i;

}while(i<20);

System.out.println(x);

(c) Rewrite the following while loop into a for loop: 

int s=0;

while(s<=13){

if(s%2==2)

{ System.out.println(“Color is red”);

}

else

{System.out.println(“Color id blue”);

}

System.out.println(“New color”);

s=s+1;

}

(d) Rewrite the corrected program after removing errors, underline the corrections: 

Int I=5,J=10;

if (I<J)||(I=10))

System.out.println(“OK \n”);

System.out.println(”Not OK”);

Refer to the attached file for CBSE Class 11 Informatics Practices Sample Paper Set X