Dbms Question Bank

504 Words3 Pages
Question Bank DBMS 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 & Subschema c. Operational data & Transient data d. Relation & Relation schema e. Pipelining & Materialization 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 serializeablity & Explain lock based protocol. 15) Explain Timestamp 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

More about Dbms Question Bank

Open Document