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 wait events in statspack report 'db sequential real'?

569

Explain the wait events in statspack report 'db scattered read'?

535

What is your favorite tool for day-to-day oracle operation?

503

What is the difference between truncate and delete? How would a full table scan behave after?

507

What is difference between co-related sub query and nested sub query?

524

What is oracle full backup?

513

What is pga_aggregate_target?

521

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.

558

What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?

578

If you had a tablespace, test_tablespace, which consists of three files:test01.dbf, test02.dbf, and test03.dbf, and someone accidentally used the unix command"rm" to delete the file test02.dbf, what else would you need in order to recover all the data thatwas present in test_tablespace at the time that test02.dbf was deleted?

526

Tell me about standby database? What should we watch out for?

500

What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?

537

Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?

609

What are the steps involved in instance recovery in oracle?

496

What is oracle log switch?

554

Un-Answered Questions { Oracle }

How to set up autotrace for a user account?

972

How to get execution statistics reports on query statements?

1005

How to drop a stored function?

1083

can u give guidance abt packages of plsql

2107

What Are Cross Validation & Adi?

1096

what are the tools used for oracle 10g in real time.

2372

Which directory will you copy your new reports, what would be its extension (.rdf or .rex)?

What is an oracle transaction?

1052

What is an Oracle Rollback Segment?

1063

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4292

What is a dead lock in oracle?

1048

Does a dba have to file taxes?

526

What is an oracle database schema?

1073

Is oracle dba in demand?

536

What are the various constraints used in oracle?

991

For More Un-Answered { Oracle } Questions Click Here