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 4706

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

1 3960

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

1 3971

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

1 4126

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

1 4353

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

1 4398

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

2 4515

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

1 4428

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

1 3938

What is RULE-based approach to optimization ?

1 5310

What is COST-based approach to optimization ?

5 8852

How do you rate yourself in oracle and sql server ?

Keane India Ltd,

2 8502

What is E-R diagram ?

CGI, Keane India Ltd,

2 12479

Draw E-R diagram for many to many relationship ?

Keane India Ltd,

3629

Design database draw er diagram for a certain scenario ?

Keane India Ltd, TATA,

4580

Un-Answered Questions { Oracle }

Mention what is oracle real application clusters?

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2270

How to build data dictionary view an new database?

1015

What is an anonymous block?

1258

How should a many-to-many relationship be handled?

561

How can we find out the duplicate values in an oracle table?

1050

How to sort output in descending order in oracle?

1049

Oracle Data Integrator Interview Questions and answers?

656

Is it possible to execute a dynamic sql from forms?

1079

How do you put database is archivelog mode, explain procedure?

554

Explain the designer?

633

How to set up autotrace for a user account?

1061

What is java oracle used for?

1030

What happens to the current transaction if the session is killed?

991

How do I become an administrator?

586

For More Un-Answered { Oracle } Questions Click Here