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

630

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

573

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

542

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

545

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

561

What is oracle full backup?

564

What is pga_aggregate_target?

566

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.

601

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?

622

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?

563

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

543

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

596

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

655

What are the steps involved in instance recovery in oracle?

545

What is oracle log switch?

605

Un-Answered Questions { Oracle }

What is the difference between BPA AND Contract What are documents and test cases u followed

2374

What are the LKM types?

589

If you are not sure what command does a particular unix function what is the best way to determine the command?

563

What is the purpose of tables, private synonyms and public synonyms in Oracle?

1037

what is difference between sql plus and sql*plus? (not sql and sql plus).

3886

What do you mean by redo log file mirroring?

1022

How to avoid duplicate entries in the forms?

What is auto invoicing? Explain : oracle accounts receivable

1122

What is the difference between single instance environment and rac environment?

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

1049

Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?

2851

How to drop a tablespace?

1039

What is the purpose of the grep command?

2133

What is StandAlone Agent and default port number?

693

What are the various oracle database objects?

1139

For More Un-Answered { Oracle } Questions Click Here