Oracle Data Access Interview Questions

 
1.
Explain Can we delete tuples in a table based on date column? And how?
2.
Explain What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command?
3.
Explain What is Read-Only Transaction?
4.
Explain What is Execution Plan?
5.
Explain What is SAVE POINT?
6.
Explain What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command?
7.
What is RULE-based approach to optimization?
8.
Explain Transaction?
9.
Explain What does COMMIT do?
10.
Explain What is the function of Optimizer?
11.
Explain What are the different approaches used by Optimizer in choosing an execution plan ?
12.
Explain 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?
13.
Explain When does a Transaction end?
14.
Explain What does ROLLBACK do?
15.
What is COST-based approach to optimization?
16.
Explain What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command?
17.
Explain What are the factors that affect OPTIMIZER in choosing an Optimization approach?
18.
Explain What are the values that can be specified for OPTIMIZER MODE Parameter?
19.
Explain Can we delete tuples in a table based on date column? And how?
20.
Explain What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command?
21.
Explain What is Read-Only Transaction?
22.
Explain What is Execution Plan?
23.
Explain What is SAVE POINT?
24.
Explain What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command?
25.
What is RULE-based approach to optimization?
26.
Explain Transaction?
27.
Explain What does COMMIT do?
28.
Explain What is the function of Optimizer?
29.
Explain What are the different approaches used by Optimizer in choosing an execution plan ?
30.
Explain 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?
31.
Explain When does a Transaction end?
32.
Explain What does ROLLBACK do?
33.
What is COST-based approach to optimization?
34.
Explain What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command?
35.
Explain What are the factors that affect OPTIMIZER in choosing an Optimization approach?
36.
Explain What are the values that can be specified for OPTIMIZER MODE Parameter?
37.
Explain Can we delete tuples in a table based on date column? And how?
38.
Explain What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command?
39.
Explain What is Read-Only Transaction?
40.
Explain What is Execution Plan?
41.
Explain What is SAVE POINT?
42.
Explain What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command?
43.
What is RULE-based approach to optimization?
44.
Explain Transaction?
45.
Explain What does COMMIT do?
46.
Explain What is the function of Optimizer?
47.
Explain What are the different approaches used by Optimizer in choosing an execution plan ?
48.
Explain 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?
49.
Explain When does a Transaction end?
50.
Explain What does ROLLBACK do?
51.
What is COST-based approach to optimization?
52.
Explain What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command?
53.
Explain What are the factors that affect OPTIMIZER in choosing an Optimization approach?
54.
Explain What are the values that can be specified for OPTIMIZER MODE Parameter?
55.
Explain Can we delete tuples in a table based on date column? And how?
56.
Explain What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command?
57.
Explain What is Read-Only Transaction?
58.
Explain What is Execution Plan?
59.
Explain What is SAVE POINT?
60.
Explain What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command?
61.
What is RULE-based approach to optimization?
62.
Explain Transaction?
63.
Explain What does COMMIT do?
64.
Explain What is the function of Optimizer?
65.
Explain What are the different approaches used by Optimizer in choosing an execution plan ?
66.
Explain 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?
67.
Explain When does a Transaction end?
68.
Explain What does ROLLBACK do?
69.
What is COST-based approach to optimization?
70.
Explain What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command?
71.
Explain What are the factors that affect OPTIMIZER in choosing an Optimization approach?
72.
Explain What are the values that can be specified for OPTIMIZER MODE Parameter?