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.

1103

What suggestions do you have to reduce the network traffic?

968

Explain the use of grant option in imp command.

1034

Explain the dml?

990

Explain alias?

1154

Explain the use of constraints option in exp command.

1053

Explain index?

1267

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

1210

Difference between hot backup vs. Cold backup?

1002

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

1153

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

1064

What do you mean by redo log file mirroring?

1041

Explain the use of compress option in exp command.

1026

Explain the use of parfile option in exp command.

1075

Explain the use of log option in exp command.

1127

Un-Answered Questions { Oracle }

Why is cluster verification utility so important in oracle rac?

Explain alias?

1154

Mention how oracle flex asm works?

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

3055

What is iapxtb structure? Explain its importance

how report can be generated if we have the database designed in oracle 10g?

1891

You get a call from you backup dba while you are on vacation. He has corrupted all of the control files while playing with the alter database backup controlfile command. What do you do?

608

What is the parameter mode that can be passed to a procedure?

1059

What is background process in Oracle?

1108

can we implement package in package?

590

What is dump destination? What are bdump, cdump and udump?

570

How to create a server parameter file?

1144

Explain the different normalization forms?

1112

A dba had to remove some archivelogs to free up space in filesystem. Nowwhen the rman job starts to backup archivelogs, it complains about missing archivelogs thatwere deleted by dba. To resolve the issue and continue backing up remainder of archivelogs,which rman command can be used so it wo not complain about missing archivelogs.

605

What is a user role in oracle?

1137

For More Un-Answered { Oracle } Questions Click Here