| Database FAQ |
 |
Difference between "ORACLE" and "MICROSOFT ACCESS" databases. |
|
How to create a database link ? |
|
What are the different types of joins? |
|
Explain Normalization and Denormalization with examples. |
|
What cursor type do you use to retrieve multiple recordsets? |
|
Difference between a "where" clause and a "having" clause |
|
Difference between "VARCHAR" and "VARCHAR2" datatypes. |
|
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? |
|
Give some examples of Analytical functions. |
|
What is the difference between "translate" and "replace"? |
|
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 the difference between "NULL in C" and "NULL in Oracle?" |
|
What is Pro*C? What is OCI? |
|
Difference - Primary Key and Aggregate Key |
|
What is a "transaction"? Why are they necessary? |
|
When do you get constraint violation? What are the types of constraints? |
|
How to convert RAW datatype into TEXT? |
|
How functional dependency is related to database table design? |
|
What is a "trigger"? |
|
What is the difference among "dropping a table", "truncating a table" and "deleting all records" from a table. |
|
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 supported by Oracle? |
|
What is SQL*Loader? |
| |
Top |