CBSE Class 12 Informatics Practices Sample Paper 2011 Solved Set D

SECTION-A

Q1. Answer the following questions: -

   a) Why GNU is known as GNU not Unix? 

   b) What is an Inventory Control System? Name any two entities or tables that could be a part of this system? 

   c) Differentiate between ER Modeling and Object Modeling Techniques.

   d) Write down the characteristics of Data Ware house.

   e) Give the difference b/w Shareware and proprietary software.

Q2. Answer the following questions:-

   a) Differentiate between a form module and class module of Visual Basic. 

   b) Explain the methods for loading and unloading forms. 

   c) What is DSN? 

   d) When the GotFocus and LostFocus Events occurs. 

   e) Differentiate between 

   f) i) Date and Date$ function ii) Call ByVal and Call ByRef

Q.3) Answer the following questions:

   a) Normalize the table with the following specification: 

      Employee (empno, dept_no, dept_name, salary, DOJ, dept_no, dept_name).

   b) If a table is dropped what happens to views and indexes dependent upon this table. 

   c) How will you drop a constraint from a table?

   d) Find the join of the following two tables:

e) What is the advantage of an anchored data type?

Please refer to attached file for CBSE Class 12 Informatics Practices Sample Paper 2011 Solved Set D