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

What are the factors that affect OPTIMIZER in choosing an Optimization approach ?

2 4700

What are the values that can be specified for OPTIMIZER MODE Parameter ?

1 3957

Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost"?

1 3967

What is the effect of setting the value of OPTIMIZER_MODE to 'RULE' ?

1 4124

What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ?

1 4350

What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?

1 4393

What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?

2 4506

What is the effect of setting the value 'FIRST_ROWS' for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?

1 4423

What is the effect of setting the 'RULE' for OPTIMIER_GOAL parameter of the ALTER SESSION Command ?

1 3935

What is RULE-based approach to optimization ?

1 5301

What is COST-based approach to optimization ?

5 8833

How do you rate yourself in oracle and sql server ?

Keane India Ltd,

2 8495

What is E-R diagram ?

CGI, Keane India Ltd,

2 12469

Draw E-R diagram for many to many relationship ?

Keane India Ltd,

3627

Design database draw er diagram for a certain scenario ?

Keane India Ltd, TATA,

4579

Un-Answered Questions { Oracle }

What are a collation and state the different types of collation sensitivity?

1170

hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.

2265

What are Oracle Schema Objects?

1114

How to rebuild an index in oracle?

1028

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1865

what is meant by magic query

2186

How to get a list of all user accounts in the database?

1087

Why oracle is used?

1058

What are the main benefits of using spfile over pfile?

641

What are the data types in oracle?

1040

What is the best way to do multi-row insert in oracle?

1067

What is an Oracle Data Block?

1067

What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.

3936

1) Does oracle have any table which contain all the exceptions and it's code internally?

1749

What is backup in Oracle?

1004

For More Un-Answered { Oracle } Questions Click Here