Database Interview Questions - 2

1. What is the use of ANALYZing the tables?
2. How to run SQL script from a Unix Shell?
3. What is a "transaction"? Why are they necessary?
4. Explain Normalizationa dn Denormalization with examples.
5. When do you get contraint violtaion? What are the types of constraints?
6. How to convert RAW datatype into TEXT?
7. Difference - Primary Key and Aggregate Key
8. How functional dependency is related to database table design?
9. What is a "trigger"?
10. Why can a "group by" or "order by" clause be expensive to process?
11. What are "HINTS"? What is "index covering" of a query?
12. What is a VIEW? How to get script for a view?
13. What are the Large object types suported by Oracle?
14. What is SQL*Loader?
15. Difference between "VARCHAR" and "VARCHAR2" datatypes.
16. What is the difference among "dropping a table", "truncating a table" and "deleting all records" from a table.
17. Difference between "ORACLE" and "MICROSOFT ACCESS" databases.
18. How to create a database link ?