可学答题网 > 问答 > OCP 11G认证考试题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

View the Exhibit for some of the para


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.
参考答案
参考解析:
分类:OCP 11G认证考试题库