Database Management and Design – May 2010

Part – A

    1. What is IS development?
    2. What is Relationship?
    3. What is Cardinality?
    4. List out any two database applications.
    5. List out any two database approaches.
    6. What is Generalization?
    7. What is disjointness?
    8. What is super type?
    9. List any two business rules.
    10. What is 2NF?
    11. What is view?
    12. What is TCL?
    13. What is Null Value?
    14. What is Natural Join?
    15. What is Dynamic SQL?
    16. Give one QBE example.
    17. What is Distributed database?
    18. What is commit protocol?
    19. What is client application?
    20. What is database server?
    21. What is a repository?
    22. What is evaluation modes?
    23. What is DBA?
    24. What is DBMS feature requirements?
    25. Write Insert Command Syntax.

Part – B

Unit -I

  1. Define the following terms:
    1. Entity
    2. Entity set
    3. Attributes
    4. Domain
  2. Explain three schema Architecture.

Unit -II

  1. Define a Normal form. List the various Normal forms.
  2. Explain Integrity Constraints in detail.

Unit -III

  1. List and explain the fundamental operations of the Relational — algebra.
  2. Explain briefly about triggers in active databases.

Unit -IV

  1. Define VBA. Explain Active X Controls.
  2. Explain concurrency and commit protocol.

Unit -V

  1. What is role of data and explain database Administrator ?
  2. Explain the database feature availability and performance.

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.