Oracle Interview Questions
Questions Answers Views Company eMail

Explain the wait events in statspack report 'db sequential real'?

427

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

394

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

358

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

401

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

404

What is oracle full backup?

384

What is pga_aggregate_target?

402

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.

451

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?

461

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?

408

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

395

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

392

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

485

What are the steps involved in instance recovery in oracle?

392

What is oracle log switch?

407


Un-Answered Questions { Oracle }

Explian File steps in ODI?

449


How to load data from file to file and what are the KM's required for this requirement?

473


When should an artificial (or derived) primary key be used?

438


How to save query output to a local file?

802


How can windows applications connect to oracle servers?

736


What are the differences between date and timestamp in oracle?

801


How to connect to a local oracle 10g xe server?

744


suppose having unique and duplicate but I want to load unique record one table and duplicates one table?

603


How to execute the package in oracle?

829


What are the different windows events activated at runtime ?

2624


What is pragma autonomous transaction in oracle?

779


How to change user password in oracle?

824


while creating requisitions i am unable to see the list of organisation can anyone help me out ?

1945


what systems can odi extract and load data into?

424


How to update values on multiple rows in oracle?

787