Define entity set.
What are the 5 major parts of a database system?
How are exceptions handled in pl/sql? Give some of the internal exceptions name?
What are the steps in creating a database?
Explain the terms specialization and generalization.
What are the partitions types available in Oracle10g. How it will do? Simple example?
What do you mean by fill factor concept with respect to indexes?
Define and explain about progress?
What is a deadlock and mention how it can be resolved?
What is dbms used for?
What is database optimization?
Explain what is a deadlock and mention how it can be resolved?
What are the key constraints in dbms?