Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

What does a Control file Contain ?

2 8292

What is the use of Control File ?

3 6570

What is a Data Dictionary ?

5 8313

What is an Integrity Constrains ?

3 7213

Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ?

2 7760

Describe the different type of Integrity Constraints supported by ORACLE ?

2 8156

What is difference between UNIQUE constraint and PRIMARY KEY constraint ?

3 7362

Describe Referential Integrity ?

1 5326

What are the Referential actions supported by FOREIGN KEY integrity constraint ?

1 5607

What is self-referential integrity constraint ?

SunGard,

2 14533

What are the Limitations of a CHECK Constraint ?

5 19315

What is the maximum number of CHECK constraints that can be defined on a column ?

3 9104

In Oracle 9i what does "i" Stands for?

MBT,

36 60185

what are the disadvantages of hierarchial database over RDBMS?

TCS,

1 13001

Can we create more than one constraint to column ?

6 11113

Un-Answered Questions { Oracle }

How to name query output columns in oracle?

1187

what is difference between sql plus and sql*plus? (not sql and sql plus).

3898

What are the steps involved in instance recovery in oracle?

550

What are the differences between lov and list item?

1065

What privilege is needed for a user to insert rows to tables in another schema?

1015

What is oracle join syntax?

1003

Does dba need to know programming?

568

What is Sequences?

630

What is explain plan and how is it used?

607

What is oracle host variable?

1061

what are steps for interface? where is exchange rate defined in which table?

2158

In topology manager where the data are stored?

677

What is the difference between cold backup and hot backup?

583

How to write text literals in oracle?

1068

What are the variable types?

613

For More Un-Answered { Oracle } Questions Click Here