View the Exhibit for some of the parameter settings. You start a session and issue the fol

View the Exhibit for some of the parameter settings. You start a session and issue the following command:SQL>CREATE INDEX emp_ename ON emp(ename) TABLESPACE users INVISIBLE;What is the outcome of the above command？（）

A. The index is not used by the optimizer but is maintained during DML operations.

B. The index is not used by the optimizer and is not maintained during DML operations.

C. The index is used by the optimizer only if a hint is specified in the query statement and is maintained during DML operations.

D. The index is used by the optimizer only if a hint is specified in the query statement but is not maintained during DML operations.

您可能感兴趣的试题

The novel contains some marvellously revealing ______ of rural life in the 19th century.A．

答案解析
He failed to carry out some of the provisions of the contract, and now he has to ______ th

答案解析
The novel contains some marvelously revealing ______ of rural life in the 19th century.[19

答案解析
What were some of the factors that contributed to the tulip craze in the Netherlands in th

答案解析
What can we infer about the company？A．The company cannot reserve some accommodation for th

答案解析
What is the main cause of unhappiness for many Americans in the authors view？A．The energy

答案解析
The old companies lose importance and some of th

答案解析