What is database transaction?
Define stored procedures.
Enlist some commands of dcl?
Define the relationship between ‘view’ and ‘data independence’.
Explain the terms ‘attribute’ and ‘relations’
What do you understand by e-r model?
What do you understand by ‘database’?
Enlist some commands of ddl, dml, and dcl.
How to improve query performance using index hunting?
Explain the importance of database partitioning.
Define weak entity set.
What do you understand by data independence? What are its two types?
What are the disadvantages of a query?
Explain primary key and composite key.
Differentiate between ‘delete’, ‘truncate’ and ‘drop’ commands.