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'?

636

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

581

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

548

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

552

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

567

What is oracle full backup?

570

What is pga_aggregate_target?

571

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.

603

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?

627

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?

566

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

547

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

617

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

659

What are the steps involved in instance recovery in oracle?

550

What is oracle log switch?

619

Un-Answered Questions { Oracle }

Which is the best option used to move database from one server to another serve on same network and why?

547

Explain the use of rows option in exp command.

1090

Explain the purpose of forms_ddl.

How to invoke the data pump export utility?

1187

How to delete a user account in oracle?

973

How to create a single index for multiple columns?

1037

Why do we need to rebuild indexes?

How to assign a table row to a record variable?

1040

What are the original export and import utilities?

1170

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2292

How to find out what oracle odbc drivers are installed?

1040

Please explain oracle data types with examples?

1068

What is a nvl function?

1031

Explain the difference between a procedure and a function?

1169

What is autocashrule set? : oracle accounts receivable

1402

For More Un-Answered { Oracle } Questions Click Here