Answer Posted / tony
Cost Based Optimizer (CBO) - This method is used if
internal statistics are present. The CBO checks several
possible execution plans and selects the one with the
lowest cost, where cost relates to system resources.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Will you be able to store pictures in the database?explain.
How to use windows user to connect to the server?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
How to change system global area (sga) in oracle?
Explain the use of consistent option in exp command.
How can we find out the current date and time in oracle?
What is the difference between count (*), count (expression), count (distinct expression)?
Why does Oracle not permit the use of PCTUSED with indexes?
1) Does oracle have any table which contain all the exceptions and it's code internally?
What is tns service name?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
Explain oracle 12c new features for developers?
What is the difference between online and offline backups?
How to view the data files in the current database?
Give the various rollback segment states.