(Important Questions) Important Questions Class XII Multimedia Technology (2009)

Disclaimer: This website is NOT associated with CBSE, for official website of CBSE visit - www.cbse.gov.in

Important Questions Class XII  Multimedia Technology (2009)

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

Table: Book

Book_Title

Acc_no

Author

Price

ASP

1002

Russell

325.00

VBScript

1014

Simon

295.00

HTML

1001

Ray

350.00

Jscript

1020

Jaworski

375.00

Table: Issue

Member no

Issue Date

Return Date

Acc_No

1432

07/12/2003

07/22/2003

1001

2042

09/30/2003

10/10/2003

1020

1245

10/08/2003

10/18/2003

1002

1432

10/03/2003

10/13/2003

1014

1324

09/30/2003

10/03/2003

1001

1565

04/05/2003

04/26/2003

1020

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?