多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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.
正确答案:A
答案解析:
进入题库查看解析

微信扫一扫手机做题