CBSE Class 11 Informatics Practices Sample Paper Set 26

SECTION A

Q1.

a) What does a bus mean? Why is data bus bi-directional? 

b)What is a port? Name some port types. 

c) define

   (i) phishing

   (ii)IDE

   (iii)Software

   (iv) firmware

d)What measures you would take to avoid 

   (i) Spyware

   (ii) PC Intrusion

e) Distinguish between RAM and ROM? 

Q2.

a) What benefits an e-business offers to a customer? What issues are till to be care of?

b)Define 

  (i) e-learning

  (ii) e-governance  

c)Name any two e-business sites.

d) Name event listeners for the following actions:- 

   (i) a component receives capability to receive input i.e focus

   (ii)key is pressed on the keyboard

e) Define 

    (i) Algorithm

    (ii) Robustness

f) Method call in which data in actual parameter remains intact is known as ________? 

Q3.

a) What is data redundancy? What are the problems associated with it? 

b) Differentiate between DDL and DML commands. 

c) How is round( ) function different from truncate( ) function? Explain giving  suitable example.

d) Write a query to create a string from the ASCII values 70,65,67,69. 

e) What is the following command doing? 

ALTER TABLE persons ADD CONSTRAINT chk_Person CHECK(P_ID>0 AND City=’Simla’);

f) Write command to display current date and time. 

g) Differentiate between CHAR and VARCHAR.

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