Home > DATABASE > PLACEMENT PAPERS > Frequently Asked Questions - Database Concepts

Frequently Asked Questions - Database Concepts

07:54 ,
Frequently Asked Questions - Database  Concepts
  • 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 ?

Powered by Blogger.