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 4596

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

1 3886

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

1 3899

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

1 4046

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

1 4286

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

1 4304

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

2 4378

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

1 4347

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

1 3861

What is RULE-based approach to optimization ?

1 5218

What is COST-based approach to optimization ?

5 8658

How do you rate yourself in oracle and sql server ?

Keane India Ltd,

2 8397

What is E-R diagram ?

CGI, Keane India Ltd,

2 12360

Draw E-R diagram for many to many relationship ?

Keane India Ltd,

3571

Design database draw er diagram for a certain scenario ?

Keane India Ltd, TATA,

4544

Un-Answered Questions { Oracle }

How index is implemented in oracle database?

964

What is oracle database client?

989

what is a package n what r the packages availbla in report

2044

What privilege is needed for a user to delete rows from tables in another schema?

1031

How to put more than 1000 values into an oracle in clause?

989

How to call a stored function with parameters?

986

How to convert a date to char in oracle? Give one example.

1014

How to shutdown your 10g xe server from command line?

1027

What is bind variable in oracle 11g?

1008

What do you mean by hz_ in customer tables? : oracle accounts receivable

1160

how may join possible between (requisition with purchase order)

2180

What is an Oracle Instance?

1084

Difference between inner join vs where ?

993

in the package one interface got failed how to know which interface got failed if we no access to operator?

574

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

1715

For More Un-Answered { Oracle } Questions Click Here