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

442

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

407

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

367

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

411

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

415

What is oracle full backup?

394

What is pga_aggregate_target?

413

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.

464

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?

471

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?

417

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

399

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

402

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

491

What are the steps involved in instance recovery in oracle?

403

What is oracle log switch?

419

Un-Answered Questions { Oracle }

What is execute immediate in oracle?

764

What is odi studio?

441

What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable

858

What is the difference between a database and instance?

493

Write a syntax for update query in oracle?

820

Explain a synonym?

812

what are archived logs?

1971

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

1833

Mention how oracle flex asm works?

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

919

Respected sir, Please send me technical questions related to oracle apps..

1603

What is connection pool in oracle?

772

Explain how to close periods in ar. : oracle accounts receivable

1042

How to create id with auto_increment on oracle?

775

i want to know about the javaBean.what is its purpose and how it can use in Forms.

2161

For More Un-Answered { Oracle } Questions Click Here