题目详情
当前位置:首页 > 职业培训考试
题目详情:
发布时间:2024-02-06 03:17:46

[单项选择] 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. disabling the index
B. making the index invisible
C. making the index unusable
D. using the MONITORING USAGE clause for the index

更多"An index called ORD_CUSTNAME_IX has"的相关试题:

[单项选择]Which of the following records has been a source of information in the author's investigation
A. United States Immigration Service reports from 1914 to 1930.
B. Payrolls of southern manufacturing firms between 1910 and 1930.
C. The Volume of cotton exports between 1898 and 1910.
D. The federal census of 1910.
[单项选择]Rice (has been) a (basically) food for (millions of) people for (hundreds of) years.
A. has been
B. basically
C. millions of
D. hundreds of
[单项选择] You created a view called EMP_DEPT_VU that contains three columns from the EMPLOYEES and DEPARTMENTS tables: EMPLOYEE_ID, EMPLOYEE_NAME AND DEPARTMENT_NAME. The DEPARTMENT_ID column of the EMPLOYEES table is the foreign key to the primary key DEPARTMENT_ID column of the DEPARTMENTS table. You want to modify the view by adding a fourth column, MANAGER_ID of NUMBER data type from the EMPLOYEES tables. How can you accomplish this task?()
A. ALTER VIEW emp_dept_vu (ADD manager_id NUMBER);
B. MODIFY VIEW emp_dept_vu (ADD manager_id NUMBER);
C. ALTER VIEW emp_dept_vu AS   SELECT employee_id, employee_name,   department_name, manager_id   FROM employee e, departments d   WHERE e.department_id = d.department_id;
D. MODIFY VIEW emp_dept_vu AS   SELECT employee_id, employee_name,   department_name, manager_id   FROM employees e, departments d   WHERE e.department_id = d.department_id;
E. CREATE OR REPLACE VIEW emp_dept_vu AS   SELECT employee_id, employee_name,   department_name, manager_id   FROM employees e, departments d   WHERE e.department_id = d.department_id;
F. You must remove the existing view first, and then run the CREATE VIEW command   with a new column list to modify a view.
[单项选择]The lady has been asking her boss ______two days off since last week.
[单项选择]The second injection should only have been given once the first drug had {{U}}taken effect{{/U}}.
A. taken place
B. injected
C. worked out
D. worked
[单项选择]The new factory that has been built next to us has ______ the value of our house.
A. demoralized
B. depreciated
C. deterred
D. derailed
[单项选择]—Has Lily come —Yes, she has been here for over ten minutes.
A. yet; already
B. already; yet
C. yet; yet
D. already; already
[单项选择]The republican movement has been gathering momentum in Australia since became Prime Minister in 1992.
A. John Howard
B. Bob Hawke
C. Malcolm Fraser
D. Paul Keating
[单项选择]Entertainment has been made available to everybody by the cinema, radio and television.
A. 影院、收音机和电视使人人都可以享受各种娱乐。
B. 影院、收音机和电视是每个人的主要娱乐方式。
C. 影院、收音机和电视使娱乐成为每个人的可能。
D. 影院、收音机和电视是每个人能够得到的娱乐。
[单项选择]The present selection has apparently been preceded by some explanation of ______.
[单项选择]How long has the project been operating
A. One year.
B. Two years.
C. Three years.
D. Four years.
[单项选择]The celebration of Thanksgiving Day has been observed to thank ______.
A. God
B. their ancestors
C. their parents
D. the Pilgrims
[单项选择]Richard Brinsley Sheridan's has been called a great comedy of manners.
A. The Rivals
B. The Duenna
C. The Critic
D. The School for Scandal
[单项选择]Scientists generally hold that language has been so long in use that the length of time writing is known to cover is ______ in Comparison.
A. overwhelming
B. uninspiring
C. astounding
D. trilling
[单项选择]Lightning has been the second largest storm killer in the US over the past 40 years and is ______ only by flood.
A. exceeded
B. excelled
C. excluded
D. extended
[单项选择]Overproduced corn in American farms has been converted to ______.
A. feed cattle, pigs and poultry
B. manufacture automobile components
C. make artificial beef, pork, and chicken
D. become high-fructose low fat products

我来回答:

购买搜题卡查看答案
[会员特权] 开通VIP, 查看 全部题目答案
[会员特权] 享免全部广告特权
推荐91天
¥36.8
¥80元
31天
¥20.8
¥40元
365天
¥88.8
¥188元
请选择支付方式
  • 微信支付
  • 支付宝支付
点击支付即表示同意并接受了《购买须知》
立即支付 系统将自动为您注册账号
请使用微信扫码支付

订单号:

请不要关闭本页面,支付完成后请点击【支付完成】按钮
恭喜您,购买搜题卡成功
重要提示:请拍照或截图保存账号密码!
我要搜题网官网:https://www.woyaosouti.com
我已记住账号密码