Database Management and Design – May 2011

Part – A

    1. What is disadvantage of DBMS?
    2. Explain SDLC?
    3. Explain generalization.
    4. What is the difference between super key and foreign key?
    5. What is client / server architecture?
    6. What is SQL?
    7. What is COM?
    8. Define embedded SQL.
    9. List implementation issues involved in embedded SQL.
    10. What is modeling?

Part – B

Unit -I

  1. Explain traditional file processing system.
  2. Explain development and SDLC.

Unit -II

  1. Explain integrity constraints with an example.
  2. What is normalization? Explain 2NF and 3NF.

Unit -III

  1. Explain three-tire architecture in detail.
  2. Explain middle wave security issues.

Unit -IV

  1. Explain database servers and data replication.
  2. Explain embedded SQL and active x controls.

Unit -V

  1. Explain DBMS selection and implementation.
  2. Explain DBMS functions and capabilities.

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.