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

580

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

541

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

511

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

517

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

532

What is oracle full backup?

529

What is pga_aggregate_target?

527

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.

570

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?

584

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?

536

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

510

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

551

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

617

What are the steps involved in instance recovery in oracle?

508

What is oracle log switch?

572

Un-Answered Questions { Oracle }

What are the daily activities of oracle dba?

566

What are the functions of administration?

506

How many types of km's? And you what are the type's km are used in your project?

530

What is tkprof and how can we use it?

What is oracle datasource?

932

What is a scenario in odi?

536

What are the differences between interval year to month and interval day to second?

971

can we use lexical perameter in oracle plsql if yes how

2276

How to write date and time literals in oracle?

958

suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables

1987

Explain procedure to change characterset of a database.

573

How do I know if oracle client is installed on windows?

964

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

2074

What is a system tablespace and why do we need it?

What is the importance of batch source set up in ar? : oracle accounts receivable

1203

For More Un-Answered { Oracle } Questions Click Here