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认证考试题库

相关推荐

1、View the Exhibit and note the content

View the Exhibit and note the contents of V$DIAG_INFO. Which statement is true about the ADR?（）A The text alert log file will be available ...

2、View the Exhibit and examine the outp

View the Exhibit and examine the output of the query in different times when the following command runs in an RMAN sessions:RMAN> BACKUP DATAB...

3、View the Exhibit to examine the repla

View the Exhibit to examine the replay settings for replay parameters.What is the implication for setting the values for replay parameters?（）A...

4、View the Exhibit to examine the param

View the Exhibit to examine the parameter values.You are planning to set the value for the MEMORY_TARGET parameter of your database instance.What value would you recommend?（）A 90 MBB 272 MBC 362 MBD 1,440 MB

5、View the Exhibit to examine the error

View the Exhibit to examine the error while executing the REPAIR FAILURE command in an RMAN session.What is the reason for this error?（）A An...

6、View the Exhibit to examine the Autom

View the Exhibit to examine the Automatic Database Diagnostic Monitor (ADDM) tasks.Which statement describes the consequence?（）A The ADDM task i...

编辑推荐

简述地中海气候型气候，及主产花卉的特点。..

以下属于霍顿（F.W.Horton）的信息资源管理思想和观点的是（）。..

简述盐酸酸洗的机理。..

某铁路局2011年运输总支出为2350百万元，其中与运量无关支出.....

现代化大型温室应坚固耐用、保温性好，使用造价较低的建筑材.....

行政决策者合理的知识结构应当是（）..