Database Managment System Question Bank

1) What are the Pros and Cons of DBMS with respect to conventional file system?

2) Design a generalization - specification hierarchy for a MOTOR-VEHICAL sales company. A company sales motorcycle, cars, vans, buses. Justify your placements of attributes at each level.

3) Construct an E-R diagram for a Hospital with a set of patients & a set of Medical Doctors. Associate with each patient a log of various tests and examinations conducted.

4) Give differences between following…

a. Physical & Logical independence

b. Schema & Sub Schema

c. Operational data & Transient data

d. Relation & Relation schema

e. Pipelining & Materialization Posted in: #Coffee Room

5) Explain extended relational Algebra operations in brief.

6) What are the fundamental & supporting sets of relational algebra? Explain in detail.

7) It is possible in general to have two primary indices on a same relation for different search keys? Explains your answer.

8) What are the factors effects the physical organization of data?

9) Explain indexes with their all types?

10) Define 1NF, 2NF, 3NF, 4NF, BCNF & state why 4NF is more desirable than BCNF?

11) Define functional dependency and discuss about various inference axioms for functional dependency.

12) Why are certain functional dependencies called, trivial functional dependencies?

13) Explain different types of constraints, and write a query to implement foreign key constraints on table

14) Discuss the test for conflict serializablity & Explain lock based protocol.

15) Explain Time stamp based protocol.

16) What are the variations of the two-phase locking protocol? Why it strict or rigorous two-phase locking often preferred?

17) What benefits & disadvantages do have two-phase locking protocol provides?

18) Draw the Life cycle diagram & explain its main concepts.

19) List the ACID properties of transaction, and explain then in brief.

20) Explain recovery process along with different phases of recovery phases.

21) Under what condition it is less expensive to avoid deadlock than to allow deadlock to occur and then detect them?

22) Describe the system architecture of DBMS with different levels of abstraction.

23) Why buffers are used in data transfer from secondary storage devices? Explain the function of buffer management in DBMS.

24) What aggregation feature is missing from the EER model? How can the EER model be further enhanced to support it?

25) How does the B-Tree differ from B+ Trees? Why B+ Trees are usually prefers as an access structure to a data file?

26) How can hashing can be used to construct an index? What is the different between Logical index and Physical index?

27) Discuss the reasons for converting SQL queries into relational algebra queries before optimization is done?

28) What is a query execution plan? What do you mean by cost-based-query optimization?

29) What is meant by semantic query optimization? How does it differ from other query optimization techniques?

30) Explain N-Tier architecture? & Write down their applications.

31) Discuss the different types of failures, & discuss the different measure of transaction equivalent.

32) Draw the state diagram & discuss the states that a transaction goes through during execution.

Please add more questions to this question bank. We can compile a PDF of those and keep it for download.