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,

993

What is background process in Oracle?

MCN Solutions,

1068

What is ASM (Automatic Storage Management) in Oracle?

MCN Solutions,

1152

How many types of table in Oracle?

MCN Solutions,

1083

What is Java Pool in Oracle?

MCN Solutions,

1112

How many types of synonyms in Oracle?

MCN Solutions,

1085

What is materialized view in Oracle?

MCN Solutions,

1048

What is Trigger in Oracle?

MCN Solutions,

1101

What is SQL access advisor in Oracle?

MCN Solutions,

1156

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

MCN Solutions,

1081

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

MCN Solutions,

1070

What is partitioned table in Oracle?

MCN Solutions,

1130

What is recovery manager in Oracle?

MCN Solutions,

1011

What is BBED in Oracle?

MCN Solutions,

1110

What is ADDM Advisor in Oracle?

MCN Solutions,

1133

Un-Answered Questions { Oracle }

What is ELT? Or What is the difference between ODI and other ETL Tools?

650

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

How to resolve name conflicts between variables and columns?

995

What do you understand by “performance tuning of db” & what are the different areas where we can perform tuning?

Which profile required to access ODI Console?

562

What are the various constraints used in oracle?

1006

Can i create more than one Master Repository in ODI?

566

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

1961

Is there a combination of "like" and "in" in sql?

1026

How to create a new oracle data file?

993

What are snapshots? What are materialized views & where do we use them? What is a materialized view?

How would you begin to troubleshoot an ORA-3113 error?

2046

What is a database instance?

553

What is the scd? and Types of SCD?

585

HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??

1427

For More Un-Answered { Oracle } Questions Click Here