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 8279

What is the use of Control File ?

3 6558

What is a Data Dictionary ?

5 8298

What is an Integrity Constrains ?

3 7206

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

2 7743

Describe the different type of Integrity Constraints supported by ORACLE ?

2 8146

What is difference between UNIQUE constraint and PRIMARY KEY constraint ?

3 7347

Describe Referential Integrity ?

1 5318

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

1 5602

What is self-referential integrity constraint ?

SunGard,

2 14524

What are the Limitations of a CHECK Constraint ?

5 19295

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

3 9089

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

MBT,

36 60110

what are the disadvantages of hierarchial database over RDBMS?

TCS,

1 12995

Can we create more than one constraint to column ?

6 11090

Un-Answered Questions { Oracle }

What is dba training?

558

What are the limitations oracle database 10g xe?

1042

What happens if a tablespace clause is left off of a primary key constraint clause?

579

What is the difference between translate and replace in oracle?

1161

ABOUT IDENTITY?

2051

What is an Oracle database Partial Backup?

1153

What is primefaces used for?

1045

Why does oracle 9i treat an empty string as null?

1047

Mention how can you determine what protocol is being used for interconnect traffic?

What are functions of dba?

548

What is the difference between BPA AND Contract What are documents and test cases u followed

2376

How to export several tables together?

1047

What is a junior dba?

611

Explain an extent?

1095

How will you run ms_batch file in forms?

For More Un-Answered { Oracle } Questions Click Here