What is the function of Optimizer ?
Answer / guest
The goal of the optimizer is to choose the most efficient
way to execute a SQL statement.
| Is This Answer Correct ? | 4 Yes | 0 No |
How can we find out the current date and time in oracle?
what is primary key?
What is currency type in database ?
What happens if you use a wrong connect identifier?
How to write a query with a full outer join in oracle?
Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?
Explain the use of grant option in exp command.
What WHERE CURRENT OF clause does in a cursor?
What is connection pooling in oracle?
How to pass parameters to procedures in oracle?
i have executed the Delete command after the I have created table whether deletions will be commit or not? if table is successfully created?
What is a heap related to database ?
1 Answers TCS, University of Edinburgh,