Oracle General Interview Questions
Questions Answers Views Company eMail

What are the factors causing the reparsing of SQL statements in SGA?

1 3725

Whatz the main diff between Subquery and a Join

Oracle, Zeta Interactive,

14 28933

Define Transaction ?

5 8314

When does a Transaction end ?

2 6564

What does COMMIT do ?

4 8992

What is SAVE POINT ?

5 7964

What is Read-Only Transaction ?

3 4975

What is the function of Optimizer ?

1 3638

What are the different approaches used by Optimizer in choosing an execution plan ?

2 4160

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

2 3570

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

1 3241

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

1 3213

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

1 3309

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

1 3553

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

1 3545


Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What are the differences between char and varchar2 in oracle?

541


How to use regular expression in pattern match conditions in oracle?

558


What is a private synonym?

1057


What is concurrency in oracle?

522


Can we store pictures in the database and if so, how it can be done?

564






How to connect ms access to oracle servers?

531


How to run the anonymous block again?

578


Please explain oracle data types with examples?

564


What are temporal data types in oracle?

580


How do I manually create a database in oracle?

516


How to define an anonymous block?

591


Explain the use of consistent option in exp command.

533


Explain the use of indexes option in imp command.

539


What is the difference between I and G in Oracle?

577


What are the general rules on data consistency?

561