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

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

Atos Origin,

1030

What is background process in Oracle?

MCN Solutions,

1099

What is ASM (Automatic Storage Management) in Oracle?

MCN Solutions,

1188

How many types of table in Oracle?

MCN Solutions,

1116

What is Java Pool in Oracle?

MCN Solutions,

1162

How many types of synonyms in Oracle?

MCN Solutions,

1115

What is materialized view in Oracle?

MCN Solutions,

1069

What is Trigger in Oracle?

MCN Solutions,

1163

What is SQL access advisor in Oracle?

MCN Solutions,

1185

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

MCN Solutions,

1140

What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

MCN Solutions,

1100

What is partitioned table in Oracle?

MCN Solutions,

1183

What is recovery manager in Oracle?

MCN Solutions,

1050

What is BBED in Oracle?

MCN Solutions,

1149

What is ADDM Advisor in Oracle?

MCN Solutions,

1167

Un-Answered Questions { Oracle }

What is integrity and what is constraint??Explain with example

2279

what is difference between group above and group left report

3811

What is tns service name?

1122

What is a server parameter file in oracle?

1051

What are Oracle Schema Objects?

1108

In the oracle version 9.3.0.5.0, what does each number shows?

1291

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1861

What is the sql query to find the employee who has Nth maximum salary?

5317

How to load data from multiple files to single target?

561

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1066

What is a view and how is it different from a table?

1040

What is oracle rownum?

947

How to delete a column in an existing table?

1072

What do you understand by format trigger?

What operating systems are supported by oracle database 10g xe?

1032

For More Un-Answered { Oracle } Questions Click Here