Important Questions Class XII  Multimedia Technology (2009)

Q. 1. Study the following data and answer the questions given below:

Table: Book

Table: Issue

On basis of above table a question is formed for 4 marks, maximum possibilities may be:

1. Identify the data type of fields of both table.
2. Identify the primary key in both table
3. Identify the field which can act as foreign key
4. Identify the type of relationship exist among tables
5. Find the cardinality of both table
6. Find the degree of both table

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?