Database Management and Design – November 2010

Part – A

    1. What is traditional file processing systems?
    2. List out database management system advantages.
    3. Explain specialization.
    4. What is the difference between primary key and candidate key?
    5. What are DML commands?
    6. What is trigger?
    7. Define active X control.
    8. What is Concurrency?
    9. What is database administrator?
    10. List evaluation models.

Part – B

Unit -I

  1. Explain E-R model with an example.
  2. Explain about database development process.

Unit -II

  1. Explain the transforming EER diagrams into relations
  2. What is normalization and explain 1NF and 2NF?

Unit -III

  1. Explain DDL commands with syntax’s and examples.
  2. Explain TCL and explain client / server architecture.

Unit -IV

  1. Explain concurrency and commit protocol.
  2. Explain COM and Active X controls.

Unit -V

  1. Explain controlling concurrent access.
  2. Explain managing data security.

Attention : This exam questions are converted from the real exam paper to a digital text format by using an OCR Software that may made some mistakes, I reviewed it many times to correct it, But may still there some errors that I missed or misspelled, So if you detect an error or mistake PLEASE report by adding a comment or contact me.