|
Related Questions |
View Answer |
|
Explain how you can build a relationship between the different databases in Access?
|
View Answer
|
|
Between different data, what are the types of relationship can be formed?
|
View Answer
|
|
Explain what is the size limitation for an Access database?
|
View Answer
|
|
Explain how you can import data from other sources into Access database?
|
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
|