What do you understand by cursor?
How to detect applications and users that hold transactions open too long?
Differentiate table scan from index scan.
What are dml and ddl statements?
What do you mean by entity type?
Why is the use of dbms recommended? Explain by listing some of its major advantages.
What are fact tables and dimension tables ? What is dimensional modeling and star schema design
How do you create a database?
What do you understand by unique key?
Mention the differences between trigger and stored procedures
What is the quickest sorting method to use?
What is different keys in dbms?
What are the ways to controlling cursor behavior?