| 1. Explain normalization with examples. |
| 2. What cursor type do you use to retrieve multiple recordsets? |
|
|
| 3. Diffrence between a "where" clause and a "having" clause |
| 4. What is the difference between "procedure" and "function"? |
| 5. How will you copy the structure of a table without copying the data? |
| 6. How to find out the database name from SQL*PLUS command prompt? |
| 7. Tadeoffs with having indexes |
|
|
| 8. Talk about "Exception Handling" in PL/SQL? |
| 9. What is the diference between "NULL in C" and "NULL in Oracle?" |
| 10. What is Pro*C? What is OCI? |
| 11. Give some examples of Analytical functions. |
| 12. What is the difference between "translate" and "replace"? |
|
|
| 13. What is DYNAMIC SQL method 4? |
| 14. How to remove duplicate records from a table? |
| 15. What is the use of ANALYZing the tables? |
| 16. How to run SQL script from a Unix Shell? |
| 17. What is a "transaction"? Why are they necessary? |
| 18. Explain Normalizationa dn Denormalization with examples. |
| 19. When do you get contraint violtaion? What are the types of constraints? |
| 20. How to convert RAW datatype into TEXT? |
| 21. Difference - Primary Key and Aggregate Key |
| 22. How functional dependency is related to database table design? |
| 23. What is a "trigger"? |
| 24. Why can a "group by" or "order by" clause be expensive to process? |
| 25. What are "HINTS"? What is "index covering" of a query? |
| 26. What is a VIEW? How to get script for a view? |
| 27. What are the Large object types suported by Oracle? |
| 28. What is SQL*Loader? |
| 29. Difference between "VARCHAR" and "VARCHAR2" datatypes. |
| 30. What is the difference among "dropping a table", "truncating a table" and "deleting all records" from a table. |
| 31. Difference between "ORACLE" and "MICROSOFT ACCESS" databases. |
| 32. How to create a database link ? |
