DBMS
1.What is the difference between DBMS and R DBMS?2.What is referential integrity and how is it achieved?
3.What is Weak Entity set?
4.What is a view? How it is related to data independence?
5. How does Tuple-oriented relational calculus differ from domain-oriented relational calculus
6. What is normalization?
7. What is Functional Dependency?
8.What is Multi valued dependency?
9. What is Loss less join property?
10.What is Fully Functional dependency?
11.State 1NF,2NF and 3NF?
12.Examine the need for three schema architecture ?
13.What are data models?
14. What is Data Independence?
15.What are the different types of join ?
16.Define data integrity.Explain various integrity constraints
17.Differentiate between DELETE and TRUNCATE command.
18.What is the basic difference between clustered and non clustered index
19. Differentiate between relation and relationship.
20.Why should relations be normalized?
21.What is the difference between conceptual model and logical model of a database.
22.What are the ideal features of a database system.
23. Differentiate between primary key, candidate key & super key.
24. What is the difference between the strong entity set and weak entityset ?
25. What do you mean by mapping cardinalities ? Explain various type of cardinalities.
26. What is difference between total and partial participation ?
27. Differentiate between Two phase locking and Rigorous two-phase locking.
28. What is Hashing ?
29.What is data dictionary? What are the information stored in the data dictionary?
30.What are Armstrong’s axioms?
31.What are aggregate functions.?
32.Explain the ACID properties of transaction.
33.Define view serializability and conflict serializability.
34.Distinguish between shared and exclusive locks.
0 comments:
Post a Comment