CBSE Class 11 Informatics Practices Sample Paper Set 23

SECTION- A

1. Answer the following questions :

1.a. Define each of the following:

   (a) Nibble (b) Byte (c) Kilo Byte (d) Giga Byte

b. State the basic units of the computer. Name the subunits that make up the CPU, and give the function of each of the units.

c. Differentiate between the compiler and interpreter. 

d What is a computer virus? How can it affect your computer? 

e Expand the following terms :

a) PDAs b) MICR c) DVD d) TFT

2. a. Which Graphical controls of JAVA can used to display multiple choices out of which more than one can be selected? 

b. Suppose you want to scan your storage devices attached with your computer for virus infection . Suggest the type and  name of the software.

c. What is Write Once Run Anywhere characteristics of Java? 

d. How can you declare the variable in JAVA for the following:- 

   (i) If you want to store the employee no. of an employee.

   (ii) If you want to store the name of an employee.

e. What is meant by E-learning. Suggest any two websites which can be used for E-learning. 

f. What benefits (mention at least 2) does an e-business offer to an organization? 

3. a. Define the following terms in respect of Relational database management System: 

(i) Primary Key.

(ii) Foreign Key.

b. Differentiate between DEFAULT and CHECK constraint of table with example. 

c. What will be the output of following code? 

    (i) SELECT LOWER(CONCAT('Informatics', 'Practices'));

     (ii) SELECT INSTR('INFORMATICS PRACTICES','OR');

d. Difference between DDL and DML commands of SQL with example. 

e. Rahul wants to create a table STUDENT which can store Roll number, name, address and percentage in SQL. Write thecommand to create the table STUDENT (Decide the type and size of column on your own).

Please refer to attached file for CBSE Class 11 Informatics Practices Sample Paper Set W