To enable cost-based optimization set the OPTIMIZER_MODE initializatio – McqOptions

MCQOPTIONS

1.	To enable cost-based optimization set the OPTIMIZER_MODE initialization parameter to CHOOSE or COST, you can set this parameter by using __________.
A.	Modifying the OPTIMIZER_MODE parameter in the initialization parameter file
B.	Setting it at session level by issuing an ALTER SESSION statement
C.	Both A & B
D.	None of the above
Answer» D. None of the above

Discussion

No Comment Found

Related MCQs

Which feature of database reduces the amount of data transfer required between sites when a transaction retrieves data from remote tables and referenced in a distributed SQL statement?
In Rewriting your query to access the remote database once it is achieved by using collocated inline views, which term is used for defining two or more tables that are located in the same database?
Which of the agent is used so that the Generic connectivity enables you to connect to a non-oracle database data stores?
All users on the local database can access the remote database and all use the same userid/password to make the connection. How can user access the remote database through the link?
If your distributed query contains ___________, then the cost-based optimization is not effective.
Which of these is used to process information requests in the distributed databases?
If a part of a distributed statement fails, due to an integrity constraint violation then the database returns which error number?
What is site autonomy?
In distributed SQL statements, which of the following retrieves information from two or more nodes?
The REMOTE_OS_AUTHENT parameter operates an externally-authenticated user and it can connect to the remote database using a connected user database link, Select the correct parameter to set.