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 ?