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

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

694

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

630

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

585

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

598

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

624

What is oracle full backup?

617

What is pga_aggregate_target?

631

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.

652

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?

677

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?

623

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

590

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

675

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

696

What are the steps involved in instance recovery in oracle?

594

What is oracle log switch?

667

Un-Answered Questions { Oracle }

Calculate difference between 2 date / times in oracle sql?

1101

How I can use srw.run_report in reports6i?

what is oracle data integrator (odi)?

672

How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2269

How do I limit the number of rows returned by an oracle query after ordering?

1228

What is a data dictionary and how can it be created?

1242

How does one coalesce free space?

599

What is responsibility and how u attach How to create user and how u attach with responsibility.

2098

What is difference between cartesian join and cross join?

1161

Explain the purpose of forms_ddl.

What is index in Oracle?

1133

Explain the use of decode function

HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

2114

What are the key components of oracle’s maximum availability architecture?

How to use regular expression in pattern match conditions in oracle?

1079

For More Un-Answered { Oracle } Questions Click Here