|
Question |
Rating |
View Answer |
|
What is COST-based approach to optimization ? |
|
View Answer |
|
What is RULE-based approach to optimization ? |
|
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 the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ? |
|
View Answer |
|
What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ? |
|
View Answer |
|
What are the values that can be specified for OPTIMIZER MODE Parameter ? |
|
View Answer |
|
What are the factors that affect OPTIMIZER in choosing an Optimization approach ? |
|
View Answer |
|
What are the different approaches used by Optimizer in choosing an execution plan ? |
|
View Answer |
|
What is Execution Plan ? |
|
View Answer |
|
What is the function of Optimizer ? |
|
View Answer |
|
What is Read-Only Transaction ? |
|
View Answer |
|
What is SAVE POINT ? |
|
View Answer |
|
What does ROLLBACK do ? |
|
View Answer |
|
What does COMMIT do ? |
|
View Answer |
|
When does a Transaction end ? |
|
View Answer |
|
Define Transaction ? |
|
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 |
|
Can we delete tuples in a table based on date column? And how?
|
|
View Answer |
|
Explain how you can import data from other sources into Access database? |
|
View Answer |
|
Explain what is the size limitation for an Access database? |
|
View Answer |