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 4681

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

1 3945

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

1 3962

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

1 4117

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

1 4338

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

1 4380

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

2 4489

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

1 4410

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

1 3923

What is RULE-based approach to optimization ?

1 5295

What is COST-based approach to optimization ?

5 8807

How do you rate yourself in oracle and sql server ?

Keane India Ltd,

2 8475

What is E-R diagram ?

CGI, Keane India Ltd,

2 12453

Draw E-R diagram for many to many relationship ?

Keane India Ltd,

3620

Design database draw er diagram for a certain scenario ?

Keane India Ltd, TATA,

4576

Un-Answered Questions { Oracle }

How to export data to a csv file?

1293

Explain how are indexes update?

1060

What are the provisions and resources provided in the oracle’s cloud server?

Can you remove an open file under unix?

692

What is a sub query and what are the different types of subqueries?

1121

How to rebuild an index in oracle?

1023

What are triggers in oracle?

1030

How to rollback the current transaction in oracle?

1049

What do you understand by oracle forms and why are they required?

1009

What is the difference between PFILE and SPFILE in Oracle?

1056

What do you mean by merge in oracle?

993

Why do we need to rebuild indexes?

What do you understand by format trigger?

What is raw datatype in oracle?

1127

How to invoke the data pump import utility?

1158

For More Un-Answered { Oracle } Questions Click Here