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

632

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

577

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

543

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

546

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

561

What is oracle full backup?

566

What is pga_aggregate_target?

567

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?

564

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?

597

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

656

What are the steps involved in instance recovery in oracle?

545

What is oracle log switch?

611

Un-Answered Questions { Oracle }

What exactly does a dba do?

571

What does a senior database administrator do?

604

What is system tablespace?

1091

How to drop a tablespace?

1041

What are summary column and placeholder column in reports?

1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?

2181

What is rac and what are the various benefits of using rac architecture?

What is the difference between sharding and replication?

1034

what are the API of GL,PO,AP

2262

What are the components of logical database structure in oracle database?

1082

What is pct free/pct used/pct increase parameter in segment? What is growth factor?

551

what is oracle forms?

1102

What is PL/SQL ?

2047

What do you mean by redo log file mirroring?

1023

Mention how can you determine what protocol is being used for interconnect traffic?

For More Un-Answered { Oracle } Questions Click Here