Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1808)
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'?

404

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

371

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

345

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

377

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

382

What is oracle full backup?

365

What is pga_aggregate_target?

385

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.

424

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?

436

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?

392

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

365

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

359

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

462

What are the steps involved in instance recovery in oracle?

371

What is oracle log switch?

384

Un-Answered Questions { Oracle }

What is the difference between oracle media recovery and crash recovery?

878

What is oracle log switch?

384

What is the difference between view and materialized view in Oracle?

830

How can you determine if an oracle instance is up from the operating system level?

378

How to use "startup" command to start default instance?

719

If the valueset if of type –TABLE then how many tables can we attach in the valueset ?

2043

How do I limit the number of oracle database connections generated by weblogic server?

789

When you used JKM ?

422

How to convert characters to times in oracle?

751

What is oracle real application clusters?

What is analyze command used for?

781

Differences between package and loadplans?

404

How to define an oracle sub procedure?

774

What is the difference between translate and replace?

790

What happens if the update subquery returns multiple rows?

787

For More Un-Answered { Oracle } Questions Click Here