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

Oracle General (1803)
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 8419

What is the use of Control File ?

3 6737

What is a Data Dictionary ?

5 8520

What is an Integrity Constrains ?

3 7356

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

2 7935

Describe the different type of Integrity Constraints supported by ORACLE ?

2 8249

What is difference between UNIQUE constraint and PRIMARY KEY constraint ?

3 7512

Describe Referential Integrity ?

1 5424

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

1 5678

What is self-referential integrity constraint ?

SunGard,

2 14660

What are the Limitations of a CHECK Constraint ?

5 19499

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

3 9237

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

MBT,

36 61298

what are the disadvantages of hierarchial database over RDBMS?

TCS,

1 13101

Can we create more than one constraint to column ?

6 11321

Un-Answered Questions { Oracle }

Why use resource manager in Oracle?

1175

What is varray?

1202

HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

2569

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1976

What is the dynamic sql in oracle?

1139

What is oracle in java?

1020

Explain the use of compress option in exp command.

1073

How do u print the data horizantally by using XML report? EX:Suppose there is one table names as SAMPLE in that we have only two columns say empno,ename.I want the output like this,At run time user may enter 3 colums(i.e to data print horizantally). empno ename empno ename empno ename 100 aaa 101 bbb 102 ccc 103 ddd 104 eee 105 fff

2301

Explain the use of owner option in exp command.

1104

What are the data types in oracle?

1103

What is SQL Tuning Advisor in Oracle?

1259

Difference between lexical and bind varible.

When you used JKM ?

651

What happens to the current transaction if a ddl statement is executed?

1065

Can we insert data in view oracle?

1122

For More Un-Answered { Oracle } Questions Click Here