网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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 been created on the CUSTNAME column in the ORDERS table using the following command: SQLCREATE 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 indexB making the index invisibleC making the index unusableD using the MONITORING USAGE clause for the index” 相关考题
考题
下面程序段的输出结果是______。 class Test{ public static void main(String args[ ]){ MyThread t=new MyThread( )； t.displayOutput("t has been created")； t.start( )； } } class MyThread extends Thread{ public void display Output(String s){ System.out,println(s)； } public void run( ){ displayOutput("t is running")； } }A．t has been created t is runningB．t has been createdC．t is runningD．编译错误
考题
In the following rivers, _____ has been called the American Ruhr.
A.the MississippiB.the MissouriC.the HudsonD.the Ohio
考题
下面程序段的输出结果是（ ）。 class Test{ public s，tatic void main(String args[]){ MyThread t=new MyThread； displayOutput("t has been createD")； start； } } Class MyThread extends Thread{ public void displayOutput(String s){ System．out．println(s)； } public void run{ displayOutput("t is running．")； } }A. t has been created．B.t has been created． t is running．C.t is running．D.编译出错
考题
What is the outcome of this block of code?()
A. It creates a task and workload, and executes the task.B. It creates a task and workload but does not execute the task.C. It produces an error because a template has not been created.D. It produces an error because the SQL Tuning Set has not been created.
考题
下面程序段的输出结果是（ ）。A.t has been created．B.t has been created． t is running．C.t is running．D.编译出错
考题
下面程序段的输出结果是 class Test{ public static void main(String args[]){ MyThread t=new MyThread()； t．displayOutput("t has been created))； t．start()； } } class MyThread extends Thread{ public void displayOutput(String s){ System．out．println(s)； } public void run(){ displayOutput(t is running．")； } }A．t has been created．B．t has been created． t is running．C．t is running．D．编译出错
考题
3下碳程序段的输出结果是( )。 class Test{ public static void main(Srting args[]){ MyThread t=new MyThread(); t.displayOutput("t has been created"); t.start(); } } class MyThread extends Thread{ public void displayOutput(String s){ SYStem.out.println(s); } public void run() { displayOutput("t is running."); } }A．t has been created.B．t has been created. t is running.C．t is running.D．编译出错
考题
While designing your database， you have created the EMPLOYEES table as an index/x7forganized table （IOT）. You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）A、A primary key must have been created.B、A mapping table must have been created.C、An overflow tablespace must have been specified.D、The PCTTHRESHOLD option must have been specified.
考题
Examine the following output： SQL SELECT index_name，status FROM dba_indexes WHERE status=’UNUSABLE’； INDEX_NAME STATUS------------------------------ ----------- EIND UNUSABLE Which two statements about the above index are true（）A、It is ignored by the query optimizer.B、It is not used while the index is being rebuilt.C、The index cannot be rebuilt， and has to be re-created.D、The index is automatically rebuilt when used the next time
考题
A user is browsing to a newly created internal site called www.comptia.org. After putting incredentials the page comes up blank. Which of the following is MOST likely the cause?（）A、The user must add the new site to the local log file.B、A proxy exception has not been configured.C、SMTP has not been configured.D、The loopback address has not been configured.
考题
A customer has just purchased six x346 servers running Windows 2003 Web Edition.They are expecting to add six additional x346’s in three months.They have a requirement to automatically deploy the current server image upon the new servers. What TWO actions are required to complete this task？（）A、Ensure Director Agent is installed on the new servers.B、Ensure a DHCP Sever is installed and configured in the environment.C、Ensure Server Plus Pack option has been installed and configured.D、Ensure Software Distribution has been installed on the IBM Director Server and an image has been created.E、Ensure Remote Deployment Manager has been installed on the IBM Director Server and an image has been created.
考题
While designing your database， you have created the EMPLOYEEStable as an index-organized （IOT）. You want to create a bitmap index on the JOD_IDcolumn to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）A、 A primary key must have been created.B、 A mapping table must have been created.C、 An overflow tablespace must have been specified.D、 The PCTTHRESHOLD option must have been specified.
考题
Evaluate the following code： SQLVARIABLE task_name VARCHAR2（255）； SQLVARIABLE sql_stmt VARCHAR2（4000）； SQLBEGIN ：sql_stmt ：= ’SELECT COUNT（*） FROM customers WHERE cust_state_province =’’CA’’’； ：task_name ：= ’MY_QUICKTUNE_TASK’； DBMS_ADVISOR.QUICK_TUNE（DBMS_ADVISOR.SQLACCESS_ADVISOR， ：task_name， ：sql_stmt）； END； What is the outcome of this block of code？（） A、 It creates a task and workload， and executes the task.B、 It creates a task and workload but does not execute the task.C、 It produces an error because a template has not been created.D、 It produces an error because the SQL Tuning Set has not been created.
考题
An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command: SQLCREATE 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 indexB、making the index invisibleC、making the index unusableD、using the MONITORING USAGE clause for the index
考题
A bitmap join index is defined as（）.A、An index used to join two bitmap indexes on a table.B、A bitmap index created for the join of two or more tables.C、A bitmap index created on the join of two or more indexes.D、A bitmap index created on the join of two or more indexed-organized tables.
考题
A library called contosobuisness.dll has been created and u need to accept it in a page.. all options had the %assembly tag but the att differed.（）A、%assembly TargetName="contosobuisness" %B、%assembly ID="contosobuisness" % C、%@ Assembly Name="contosobuisness" %D、%assembly virtualpath="contosobuisness" %
考题
多选题You have created a job class， CUST_JOB_1， with two jobs， CUST_JOB_1_A and CUST_JOB_1_B. Which two statements are true？ （）AThe member jobs would get dropped when the job class is dropped.BBoth the jobs would be executed concurrently.CThe member jobs would get disabled when the job class is dropped.DThe attributes defined at the class level would be applied to both the jobs.EJobs in the job class must have been assigned the same priority.
考题
单选题A user is browsing to a newly created internal site called www.comptia.org. After putting incredentials the page comes up blank. Which of the following is MOST likely the cause?（）A
The user must add the new site to the local log file.B
A proxy exception has not been configured.C
SMTP has not been configured.D
The loopback address has not been configured.
考题
单选题While designing your database， you have created the EMPLOYEES table as an index/x7forganized table （IOT）. You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）A
A primary key must have been created.B
A mapping table must have been created.C
An overflow tablespace must have been specified.D
The PCTTHRESHOLD option must have been specified.
考题
单选题While designing your database， you have created the EMPLOYEEStable as an index-organized （IOT）. You want to create a bitmap index on the JOD_IDcolumn to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）A
A primary key must have been created.B
A mapping table must have been created.C
An overflow tablespace must have been specified.D
The PCTTHRESHOLD option must have been specified.
考题
单选题An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command： SQLCREATE 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 indexB
making the index invisibleC
making the index unusableD
using the MONITORING USAGE clause for the index
考题
单选题The EMPLOYEES table has six indexes and DML operations are slow. Which command begins monitoring the EMPLOYEE_IDX_FK index to determine whether it has been used by an execution plan？（）A
ALTER TABLE employees monitor index employee_idx_fk; B
ALTER INDEX employee_idx_fk monitoring on; C
ALTER TABLE employees monitor all indexes; D
ALTER INDEX employee_idx_fk monitoring usage;
考题
单选题A bitmap join index is defined as（）.A
An index used to join two bitmap indexes on a table.B
A bitmap index created for the join of two or more tables.C
A bitmap index created on the join of two or more indexes.D
A bitmap index created on the join of two or more indexed-organized tables.
考题
单选题Evaluate the following code： SQLVARIABLE task_name VARCHAR2（255）； SQLVARIABLE sql_stmt VARCHAR2（4000）； SQLBEGIN ：sql_stmt ：= ’SELECT COUNT（*） FROM customers WHERE cust_state_province =’’CA’’’； ：task_name ：= ’MY_QUICKTUNE_TASK’； DBMS_ADVISOR.QUICK_TUNE（DBMS_ADVISOR.SQLACCESS_ADVISOR， ：task_name， ：sql_stmt）； END； What is the outcome of this block of code？（）A
It creates a task and workload， and executes the task.B
It creates a task and workload but does not execute the task.C
It produces an error because a template has not been created.D
It produces an error because the SQL Tuning Set has not been created.
考题
多选题Examine the following output： SQL SELECT index_name，status FROM dba_indexes WHERE status=’UNUSABLE’； INDEX_NAME STATUS------------------------------ ----------- EIND UNUSABLE Which two statements about the above index are true（）AIt is ignored by the query optimizer.BIt is not used while the index is being rebuilt.CThe index cannot be rebuilt， and has to be re-created.DThe index is automatically rebuilt when used the next time
考题
单选题A library called contosobuisness.dll has been created and u need to accept it in a page.. all options had the %assembly tag but the att differed.（）A
%assembly TargetName=contosobuisness %B
%assembly ID=contosobuisness % C
%@ Assembly Name=contosobuisness %D
%assembly virtualpath=contosobuisness %
热门标签
最新试卷