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.
What do you understand by data independence?
What do you understand by ‘atomicity’ and ‘aggregation’?
Enlist the advantages of dbms.
What are the advantages and disadvantages of views in the database?
What do you understand by functional dependency?