Frequently Asked Questions - Database

• What are the different types of joins?



• Explain normalization with examples.



• What cursor type do you use to retrieve multiple recordsets?



• Diffrence between a "where" clause and a "having" clause



• What is the difference between "procedure" and "function"?



• How will you copy the structure of a table without copying the data?



• How to find out the database name from SQL*PLUS command prompt?



• Tadeoffs with having indexes



• Talk about "Exception Handling" in PL/SQL?



• What is the diference between "NULL in C" and "NULL in Oracle?"



• What is Pro*C? What is OCI?



• Give some examples of Analytical functions.



• What is the difference between "translate" and "replace"?



• What is DYNAMIC SQL method 4?



• How to remove duplicate records from a table?



• What is the use of ANALYZing the tables?



• How to run SQL script from a Unix Shell?



• What is a "transaction"? Why are they necessary?



• Explain Normalizationa dn Denormalization with examples.



• When do you get contraint violtaion? What are the types of constraints?



• How to convert RAW datatype into TEXT?



• Difference - Primary Key and Aggregate Key



• How functional dependency is related to database table design?



• What is a "trigger"?



• Why can a "group by" or "order by" clause be expensive to process?



• What are "HINTS"? What is "index covering" of a query?



• What is a VIEW? How to get script for a view?



• What are the Large object types suported by Oracle?



• What is SQL*Loader?



• Difference between "VARCHAR" and "VARCHAR2" datatypes.



• What is the difference among "dropping a table", "truncating a table" and "deleting all records" from a table.



• Difference between "ORACLE" and "MICROSOFT ACCESS" databases.



• How to create a database link ?