Database Basic Set 1

Pages: 0 1 Next>>

0. Explain normalization with examples.
1. What cursor type do you use to retrieve multiple recordsets?
2. Diffrence between a "where" clause and a "having" clause
3. What is the difference between "procedure" and "function"?
4. How will you copy the structure of a table without copying the data?
5. How to find out the database name from SQL*PLUS command prompt?
6. Tadeoffs with having indexes
7. Talk about "Exception Handling" in PL/SQL?
8. What is the diference between "NULL in C" and "NULL in Oracle?"
9. What is Pro*C? What is OCI?
10. Give some examples of Analytical functions.
11. What is the difference between "translate" and "replace"?
12. What is DYNAMIC SQL method 4?
13. How to remove duplicate records from a table?
14. What is the use of ANALYZing the tables?
15. How to run SQL script from a Unix Shell?
16. What is a "transaction"? Why are they necessary?
17. Explain Normalizationa dn Denormalization with examples.
18. When do you get contraint violtaion? What are the types of constraints?
19. How to convert RAW datatype into TEXT?

Pages: 0 1 Next>>

NEW!!!

TOOOO Many results in general search?!! Try this customized search engine for searching online books

Job Openings For Freshers