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 8181

What is the use of Control File ?

3 6444

What is a Data Dictionary ?

5 8158

What is an Integrity Constrains ?

3 7104

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

2 7627

Describe the different type of Integrity Constraints supported by ORACLE ?

2 8070

What is difference between UNIQUE constraint and PRIMARY KEY constraint ?

3 7220

Describe Referential Integrity ?

1 5252

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

1 5539

What is self-referential integrity constraint ?

SunGard,

2 14454

What are the Limitations of a CHECK Constraint ?

5 19118

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

3 8956

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

MBT,

36 59300

what are the disadvantages of hierarchial database over RDBMS?

TCS,

1 12912

Can we create more than one constraint to column ?

6 10918

Un-Answered Questions { Oracle }

Explain the use of grant option in imp command.

973

What is the most common database language that a db administrator needs to know?

531

IS it possible to built the oracle database without setting the kernal parameters?

2294

What are the different types of database users?

533

What is a lookup table in oracle?

946

How you find which is the latest record in SCD type2 transformation?

556

Teradata: How can we know the indexed column in a table?

1858

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2190

What is the difference between translate and replace in oracle?

1129

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

2160

How to create a testing table in oracle?

957

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

1978

Explain the characteristics of oracle dba?

1080

What are the Types of Scd's?

552

How to use null as conditions in oracle?

1025

For More Un-Answered { Oracle } Questions Click Here