搜题

【单选题】

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?（） <img src="https://nimg.ppkao.com/2018-08/yiyu/2018080210525934337.jpg?sign=92173c029f905d2e451b142ae7953a42&t=62d30596" />

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.

查看正确答案

更多“ 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?（） <img src="https://nimg.ppkao.com/2018-08/yiyu/2018080210525934337.jpg?sign=92173c029f905d2e451b142ae7953a42&t=62d30596" />”相关的问题

第1题

[单选题] View the Exhibit exhibit1 to examine the series of SQL commands. View the Exhibit exhibit2 to examine the plans available in the SQL plan baseline. The baseline in the first row of the Exhibit is created when OPTIMIZER_MODE was set to FIRST_ROWS. Which statement is true if the SQL query in exhibit1 is executed again when the valueof OPTIMIZER_MODE is set to FIRST_ROWS?（）

A、The optimizer uses a new plan because none of the plans in the exhibit2 are fixed plans. B、The optimizer uses the plan in the second row of the exhibit2 because it is an accepted plan. C、The optimizer uses the plan in the first row of the exhibit2 because it is the latest generated plan. D、The optimizer uses the plan in the first row of the exhibit2 because OPTIMIZER_MODE was set to FIRST_ROW during its creation.

点击查看答案

第2题

[] View the Exhibit and examine the output. You execute the following RMAN command to perform the backup operation: What is the multiplexing level in the preceding backup process（） View the Exhibit and examine the output. You execute the following RMAN command to perform the backup operation: What is the multiplexing level in the preceding backup process（）

A、A. 4 B、B. 8 C、C. 7 D、D. 0

点击查看答案

第3题

[单选题] Examine the exhibit to view the parameters set in your parameter file. (Click the Exhibit(s) button.) You restart the instance. To what value will the MEMORY_MAX_TARGET parameter be set by default?（）

A、120M B、320M C、480M D、600M

点击查看答案

第4题

[单选题] View the Exhibit to examine the Automatic SQL Tuning result details.Which action would you suggest for the selected SQL statement in the Exhibit?（）

A、Accept the recommended SQL profile. B、Collect statistics for the related objects. C、Run the Access Advisor for the SQL statement. D、Run the Segment Advisor for recommendations.

点击查看答案

第5题

[单选题] The following exhibit shows ipv6 route output. What would the metric be fo r a summary route that summarizes all three OSPFv3 routes displayed?（）

A、160 B、140 C、120 D、100

点击查看答案

第6题

[单选题] View the Exhibit and note the files available in the $ORACLE_HOME/dbs folder. The ASM instanceis already running. You used the following steps to start the database instance and open the database： Which file is used to start the instance in this case（）

A、init.ora B、spfile.ora C、initorcl.ora D、spfile+ASM.ora

点击查看答案

第7题

[单选题] You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created.You want to look at the definition of the view (the SELECT statement on which the view was create.) How do you obtain the definition of the view?（）

A、Use the DESCRIBE command in the EMP_DEPT VU view. B、Use the DEFINE VIEW command on the EMP_DEPT VU view. C、Use the DESCRIBE VIEW command on the EMP_DEPT VU view. D、Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view. E、Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view. F、Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.

点击查看答案

第8题

[单选题] You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was create.) How do you obtain the definition of the view?（）

点击查看答案

第9题

[单选题] You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was create.) How do you obtain the definition of the view? （）

点击查看答案

第10题

[] You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was created.) How do you obtain the definition of the view?（）

A、A.Use the DESCRIBE command on the EMP_DEPT_VU view. B、B.Use the DEFINE VIEW command on the EMP_DEPT_VU view. C、C.Use the DESCRIBE VIEW command on the EMP_DEPT_VU view. D、D.Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view. E、E.Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view. F、F.Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.

点击查看答案

账号：登录

答题记录

我的收藏

我的题库

客服

TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服