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

Explain the use of show option in imp command.

1098

What suggestions do you have to reduce the network traffic?

961

Explain the use of grant option in imp command.

1030

Explain the dml?

982

Explain alias?

1151

Explain the use of constraints option in exp command.

1048

Explain index?

1259

How to create lov dynamically at runtime & attach to text field?

1197

Difference between hot backup vs. Cold backup?

991

How can we force the database to use the user specified rollback segment?

1148

What is a trace file and how is it created in oracle?

1058

What do you mean by redo log file mirroring?

1032

Explain the use of compress option in exp command.

1021

Explain the use of parfile option in exp command.

1069

Explain the use of log option in exp command.

1121

Un-Answered Questions { Oracle }

Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

2116

How would you differentiate between cluster and grid?

How to list all user accounts in oracle?

1027

What is new feature in oracle asm 12c?

Can objects of the same schema reside in different tablespace?

1062

What are the various types of snapshots ?

1029

If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?

590

Calculate difference between 2 date / times in oracle sql?

1040

Explain an exception?

995

How to connect to a local oracle 10g xe server?

992

As an oracle dba what are the entire unix file you should be familiar with?

579

How to synchronize 2 schema's objects?

2181

1. What is PO rate variance gain and loss?

2920

What is split brain syndrome in rac?

Can a parameter be passed to a cursor?

1126

For More Un-Answered { Oracle } Questions Click Here