Enlist the various relationships of database.
define aggregate functions.
Differentiate table scan from index scan.
What do you mean by index hunting?
Enlist ways to efficiently code transactions.
What are stand-alone procedures?
Describe the types of keys?
What is the difference between a shared lock and exclusive lock?
How many types of database languages are?
What do you mean by extension and intension?
When does checkpoint occur in dbms?
What do you mean by durability in dbms?
Explain the functionality of dml compiler.
What do you mean by transparent dbms?
Define a relation schema and a relation.