Database Interview Questions (SQL, Oracle, Pro*C/C++)

SQL General Interview Questions ...

• 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"?
  

  -- Sponsored Links --

  Your Ad Here
  
  
• 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 ?

PL/SQL interview questions...

• Normalize many to many relationships
• Difference - Equijoin and union
  

  -- Sponsored Links --

  Your Ad Here
  
  
• What is TEMP table space in Oracle, what is rollback segment
• How do we find row chaining?
• Pattern matching operators
• Features in oracle 9i and 10g
• Why truncating table is faster than delete
• copy commit syntax
• Convert Zulu time zone to US Eastern time zone
• Difference - union and union all
• Difference - Group by, Order by clause
• Which Ranking functions are available?
• Difference - Decode, NVL, NVL2
• Tradeoffs of using partitioned tables
• How can we call stored procedure in SQL query
• What are the restrictions on calling PL/SQL from SQL
• Why EXISTS is preferable to distinct
• Give two examples of avoiding unnecessary parsing.