Database Management and Design – April 2013

Part – A

    1. List out the advantages of the DBMS.
    2. What is database analysis?
    3. Define super type and specialization.
    4. What are business rules?
    5. Define middle ware.
    6. Give syntax and example for a inserting.
    7. What is OLE?
    8. Define concurrency.
    9. How to do backup for databases?
    10. What is security?

Part – B

Unit -I

    1. Briefly discuss about E-R model.
    2. Explain the following terms:
      1. Entities
      2. Attributes
      3. Relationships
    1. Explain SDLC in detail.
    2. Explain architecture and three-tired architecture.

Unit -II

  1. What is normalization? Explain 3NF in detail.
  2. Explain integrity constraints? Define disjointness.

Unit -III

  1. Explain about the various relational algebra operators with example.
  2. Explain client / serves architectures. Define database in SQL?

Unit -IV

  1. Discuss on Active X controls and embedded SQL.
    1. Explain the following terms
      1. COM
      2. VBA
      3. Data replication

Unit -V

  1. Describe the role of a database administrator with functions.
  2. Explain about 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.