| Other Oracle General Interview Questions |
|| Asked @
|How do we know whether an index is created on a table ???
|sql command 2 know current database
|What is a Private Synonyms ?
|What is the effect of setting the value "ALL_ROWS" for
OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
|What are joins..how many types of joins are there?
|What is the difference between column level constraints and
table level constraints?
|What are the composite date types in oracle?
|1.What is inline function in oracle and its purpose?
2.What is the equivalent operator for "different from
pattern" in oracle?
3. If you define a variable in oracle, how it will be
available? [a. Until database shut down b. Until table deleted
c. until session get expired]
|Will the Optimizer always use COST-based approach if
OPTIMIZER_MODE is set to "Cost"?
|when i run my query on yesterday it is fast but today it is
|What are the trigger associated with image items ?
|find the second highest salary of the emp table
|For more Oracle General Interview Questions Click Here |