1. Categories >> Software >> Databases >> Oracle
  2. Suggest New Category


Oracle Interview Questions
Questions Answers Views Company eMail

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

 2 3619

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

 1 3277

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

 1 3250

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

 1 3343

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

 1 3584

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

 1 3588

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

 2 3434

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

 1 3654

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

 1 3001

What is RULE-based approach to optimization ?

 1 4576

What is COST-based approach to optimization ?

 5 7068

How do you rate yourself in oracle and sql server ?

Keane India Ltd,

2 7356

What is E-R diagram ?

CGI, Keane India Ltd,

2 11217

Draw E-R diagram for many to many relationship ?

Keane India Ltd,

3159

Design database draw er diagram for a certain scenario ?

Keane India Ltd, TATA,

4105

Un-Answered Questions { Oracle }

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

524

Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

1666

Difference between open_form and call_form in oracle.

680

What is bulk copy or bcp in oracle?

610

What is File steps?

325




How to delete a column in an existing table in oracle?

603

Explain user account with reference to oracle.

535

What are dba privileges?

261

Can we look-up a table from source qualifier transformation. Ie. Unconnected lookup?

1

how do u compile a form i.e .fmb file in Unix or in dos

4020

Why does for update in oracle 8 cause an ora-01002 error?

546

How to rename an index?

588

What happens in oracle commit?

570

Explain the characteristics of oracle dba?

638

How to count duplicated values in a column in oracle?

554

For More Un-Answered { Oracle } Questions Click Here