|
Related Questions |
View Answer |
|
Can we delete tuples in a table based on date column? And how?
|
View Answer
|
|
There is a field of type character in the table, but we are storing numeric values like (Roll number) in this field, so if we want to sort the field (in java) according to numbers.How?
|
View Answer
|
|
Define Transaction ?
|
View Answer
|
|
When does a Transaction end ?
|
View Answer
|
|
What does COMMIT do ?
|
View Answer
|
|
What does ROLLBACK do ?
|
View Answer
|
|
What is SAVE POINT ?
|
View Answer
|
|
What is Read-Only Transaction ?
|
View Answer
|
|
What is the function of Optimizer ?
|
View Answer
|
|
What is Execution Plan ?
|
View Answer
|
|
What are the different approaches used by Optimizer in choosing an execution plan ?
|
View Answer
|
|
What are the factors that affect OPTIMIZER in choosing an Optimization approach ?
|
View Answer
|
|
What are the values that can be specified for OPTIMIZER MODE Parameter ?
|
View Answer
|
|
What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ?
|
View Answer
|
|
What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?
|
View Answer
|
|
What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
|
View Answer
|
|
What is RULE-based approach to optimization ?
|
View Answer
|
|
What is COST-based approach to optimization ?
|
View Answer
|
Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.
View All Data Access Interview Questions & Answers - Exam Mode /
Learning Mode
|