CBSE CLASS XII
Q. 1. Study the following data and answer the questions given below:
On basis of above table a question is formed for 4 marks, maximum possibilities may be:
Remaining possibilities for 6 marks are 2 question of 2 -2 marks or 1-1 marks can be formed, important question are as follows:
Q. 2. Define data redundancy?
Q. 3. Define data inconsistency?
Q. 4. Write full form of DBMS?
Q. 5. Write advantages and disadvantages of DBMS?
Q. 6. What is database?
Q. 7. Define following terms: Data, Record, Field
Q. 8. What is Cardinality?
Q. 9. What is Degree?
Q. 10. Define following keys: Primary key, Alternate key, Candidate key, Composite key, Foreign key?
Q. 11. Name the view in which a table can be viewed?
Q. 12. What is relationship. Name two relationship?
Q. 13. What is One to One Relationship?
Q. 14. What is One to Many Relationship?
Q. 15. What is Many to Many Relationship?
Q. 16. What is the default data type for a field?
Q. 17. What is the default size of text field?
Q. 18. What is Memo?
Q. 19. Difference between various data types available in MS – Access?
Q. 20. Define data validation, how can to set data validation rules in MS-Access?
Q. 21. What is the extension of MS-Access database file?
Paper By Mr. Devendra Singh Chouhan