An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command: SQL>CREATE INDEX ord_custname_ix ON orders(custname); The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause. You want to check the impact on the performance of the queries if the index is not available. You do not want the index to be dropped or rebuilt to perform this test.Which is the most efficient method of performing this task?（） -题库考试答案搜索网

An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command:
SQL>CREATE INDEX ord_custname_ix ON orders(custname);
The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause.
You want to check the impact on the performance of the queries if the index is not available. You do not want the index to be dropped or rebuilt to perform this test.Which is the most efficient method of performing this task?（）

单选题

2022-01-03 17:23

A、disabling the index
B、making the index invisible
C、making the index unusable
D、using the MONITORING USAGE clause for the index

查看答案

正确答案

B

试题解析

标签： OCP 11G认证考试

感兴趣题目

An uncontrolled flow of gas, oil, or other well fluids into the atmosphere is called a（）.

OCP条款

简述OCP运输条款。

北美陆上联运的OCP条款不是（）。

采用OCP运输条款应具备条件为（）。

OCP运输是指（）

OCP运输方式属于（）。

Jitter is an unwanted variation of one or more characteristics of a periodic signal in electronics and telecommunications and（）refers to call issues that cause variations in timing or time of arrival.

Jitter is an unwanted variation of one or more characteristics of a periodic signal in electronics and telecommunications and（）refers to call issues that cause variations in timing or time of arrival.

Do you like an apple or a banana?（）

The InnoDB engine has a feature known as clustered indexes.
Which three statements are true about clustered indexes as used in InnoDB?（）

An entry of water，gas，oil，or other formation fluid into the wellbore is called a（）.

相关题目: Programs for Web site design and HTML coding are called Web page editors or .; —I think we can use two or more kinds of media together in an advertising campaign.

—; Do you like an apple or a banana?（）; Which American President created an economic plan called the ‘New Deal’?; Do we call a large fire an “incident” or a kind of “disaster”?; CASE OF DEATH OR SERIOUS INJURY TO A PERSON IN AN ACCIDENT OR SHIPPING DISASTER is（）.; Which device is normally used to translate telephone numbers or names to IP addresses for call routing in an H.323 network？（）; Where would you find the call sign or call letters of the radio station on your ship?（）; Where would you find the “call sign” or “call letters”of the radio station on your rig?（）; An electrical device which prevents an action from occurring until all other required conditions are met is called a/an （）.; An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command:
SQL>CREATE INDEX ord_custname_ix ON orders(custname);
The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause.
You want to check the impact on the performance of the queries if the index is not available. You do not want the index to be dropped or rebuilt to perform this test.Which is the most efficient method of performing this task?（）; A sextant having an index error that is off the arc has a（）.; （），how do you charge for an IDD call？; （），how do you charge for an IDD call？; Securing cargo by running timbers from an upper support down to the cargo，either vertically or at an angle，is called（）.; ●In C language，the usual expression statements are (73) or function calls.; ●In C language，the usual expression statements are (73) or function calls.; An uncontrolled flow of gas，oil，or other well fluids into the atmosphere is called a（）.; Youre performing tablespace point-in-time recovery on a tablespace called USERS. If an object in that tablespace has a foreign key constraint owned by another object in the INDEX_TBS which statement is true？（）; An uncontrolled flow of gas，oil，or other well fluids into the atmosphere is called a（）.

广告位招租WX:84302438

题库考试答案搜索网

免费的网站请分享给朋友吧