Compare non-clustered and clustered index
What are the various kinds of interactions catered by dbms?
Define database.
What restrictions can you apply when you are creating views?
Define "correlated subqueries".
What do database languages do?
Enlist the cursor types.
What do you mean by query evaluation engine?
How does index hunting help in improving query performance?
Define fragmentation.
Enlist the various transaction phases.
Define normalization.
Define union all operator and union.
Define ddl and dml.
Define join and enlist its types.