网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index. Which two are possible if table updates are performed which affect the invisible index columns?（）
A
The index remains invisible.
B
The index is not updated by the DML statements on the indexed table.
C
The index automatically becomes visible in order to have it updated by DML on the table.
D
The index becomes unusable but the table is updated by the DML.
E
The index is updated by the DML on the table.
参考答案
参考解析
解析：
暂无解析
更多 “多选题You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index. Which two are possible if table updates are performed which affect the invisible index columns?（）AThe index remains invisible.BThe index is not updated by the DML statements on the indexed table.CThe index automatically becomes visible in order to have it updated by DML on the table.DThe index becomes unusable but the table is updated by the DML.EThe index is updated by the DML on the table.” 相关考题
考题
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
考题
You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index.Which two are possible if table updates are performed which affect the invisible index columns?（）A. The index remains invisible.B. The index is not updated by the DML statements on the indexed table.C. The index automatically becomes visible in order to have it updated by DML on the table.D. The index becomes unusable but the table is updated by the DML.E. The index is updated by the DML on the table.
考题
Examine the SQL statements that creates ORDERS table:For which columns would an index be automatically created when you execute the above SQL statement? ()
A. SER_NOB. ORDER_IDC. STATUSD. PROD_IDE. ORD_TOTALF. Composite index on ORDER_ID and ORDER_DATE
考题
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 EMPLOYEES table as an index-organized 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.
考题
You are a DBA of your company. You created a database named SALES on an Oracle 10g instance. You have defined an index named INDEX1 on the database table named INVENTORY. Users are complaining that queries accessing the INVENTORY table are running slow. Upon investigation you determine that the tablespace where the index is located is experiencing high I/O and you decide to relocate the index to another tablespace. Which of these will be the best way to accomplish this objective？（）A、 Rebuild the index.B、 Coalesce the index.C、 Drop and re-create the index in the new tablespace.D、 Relocate the index using the ALTER INDEX...MOVE statement.
考题
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
考题
As a result of performance analysis， you created an index on the prod_name column of the prod_det table， which contains about ten thousand rows. Later， you updated a product name in the table. How does this change affect the index？（）A、A leaf will be marked as invalid.B、An update in a leaf row takes place.C、The index will be updated automatically at commit.D、A leaf row in the index will be deleted and inserted.E、The index becomes invalid when you make any updates.
考题
You work as a database administrator for Certkiller .com. As a result of performance analysis， you created an index on theprod_namecolumn of the Certkiller prodtable， which contains about ten thousand rows. Later， you updated a product name in the table. How does this change affect the index？（）A、A leaf will be marked as invalid.B、An update in a leaf row takes place.C、The index will be updated automatically at commit.D、A leaf row in the index will be deleted and inserted.E、The index becomes invalid when you make any updates
考题
Your database is in ARCHIVELOG mode. You lost an index tablespace due to a disk failure while the database was open. You have neither a backup of the lost index tablespace nor the scripts containing the CREATE INDEX statements to recreate the indexes. Currently， several users are executing long-running queries on the database. What will happen to the ongoing activity in the database？（）A、 The queries that are currently executing will abort and an error message will be returned to the user.B、 The queries that are currently executing will execute normally but future queries will not executed.C、 Data Manipulation Language （DML） statements cannot be performed on the tables on which the indexes are based.D、 The currently executing and future queries will execute normally， but will be slower
考题
You have created an Oracle 10g database named SALES， which will be used by an application named SalesOrders. Users of the SalesOrders application complain that application response time is slow when they generate reports. The SalesOrders application accesses a table that contains 10 million rows. You decide to create an index on this table using the NOLOGGING option so that the index creation process is completed in the least amount of time. Which of the following is NOT true about an index created with the NOLOGGING option？（）A、 The index can be changed from NOLOGGING to LOGGINGB、 The index cannot be recovered even in the ARCHIVELOG mode.C、 The index can only be created if the base table is created with the NOLOGGING option.D、 The index can be recovered if you perform a backup after the CREATE INDEX statement.
考题
On your Oracle Database, you issue the following commands to create indexes: SQL CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE; SQL CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id); Which two statements are true?（）A、Only the ORD_CUSTOMER_IX1 index created.B、Both the indexes are updated when a row is inserted, updated, or deleted in the ORDERS table.C、Both the indexes are created: however, only ORD_CUSTOMERS_IX1 is used by the optimizer for queries on the ORDERS table.D、The ORD_CUSTOMER_IX1 index is not used by the optimizer even when the OPTIMIZER_USE_INVISIBLE_INDEXES parameters is set to true.E、Both the indexes are created and used by the optimizer for queries on the ORDERS table.F、Both the indexes are created: however, only ORD_CUSTOMERS_IX2 is used by the optimizer for queries on the ORDERS table.
考题
Which two statements are true regarding B-tree index（）A、The leaf blocks in the index are doubly linked.B、The leaf node stores a bitmap for each key value.C、The rows with NULL value in key columns also have entries in the index.D、The deletion of a row from the table causes a logical deletion in index leaf block and the space becomes available for the new leaf entry.
考题
You are creating a cluster. The tables in the cluster have a relatively uniform distribution of values in the index column and the queries against the clustered table will almost use an equality operator to retrieve the desired row. Which type of cluster will you create？（）A、 Index clusterB、 Hash clusterC、 Sorted Hash clusterD、 Real Application Cluster
考题
You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index. Which two are possible if table updates are performed which affect the invisible index columns?（）A、The index remains invisible.B、The index is not updated by the DML statements on the indexed table.C、The index automatically becomes visible in order to have it updated by DML on the table.D、The index becomes unusable but the table is updated by the DML.E、The index is updated by the DML on the table.
考题
单选题Your database is in ARCHIVELOG mode. You lost an index tablespace due to a disk failure while the database was open. You have neither a backup of the lost index tablespace nor the scripts containing the CREATE INDEX statements to recreate the indexes. Currently， several users are executing long-running queries on the database. What will happen to the ongoing activity in the database？（）A
The queries that are currently executing will abort and an error message will be returned to the user.B
The queries that are currently executing will execute normally but future queries will not executed.C
Data Manipulation Language （DML） statements cannot be performed on the tables on which the indexes are based.D
The currently executing and future queries will execute normally， but will be slower
考题
多选题On your Oracle Database, you issue the following commands to create indexes: SQL CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE; SQL CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id); Which two statements are true?（）AOnly the ORD_CUSTOMER_IX1 index created.BBoth the indexes are updated when a row is inserted, updated, or deleted in the ORDERS table.CBoth the indexes are created: however, only ORD_CUSTOMERS_IX1 is used by the optimizer for queries on the ORDERS table.DThe ORD_CUSTOMER_IX1 index is not used by the optimizer even when the OPTIMIZER_USE_INVISIBLE_INDEXES parameters is set to true.EBoth the indexes are created and used by the optimizer for queries on the ORDERS table.FBoth the indexes are created: however, only ORD_CUSTOMERS_IX2 is used by the optimizer for queries on the ORDERS table.
考题
多选题You lost a data file that belongs to an index tablespace in your database， which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries. Which two options would you use to solve this problem？ （）ARestore the lost data file from the backup， and then flash back the database.BRestore the data file pertaining to index tablespace， and then recover the tablespace.CRestore all the data files， and then perform an incomplete recovery to get the tablespace back.DRestore all the data files， and then perform an incomplete recovery using the backup control file.EDrop and re-create the index tablespace， and then re-create all of the indexes in that tablespace.
考题
多选题Which two statements are true regarding B-tree index（）AThe leaf blocks in the index are doubly linked.BThe leaf node stores a bitmap for each key value.CThe rows with NULL value in key columns also have entries in the index.DThe deletion of a row from the table causes a logical deletion in index leaf block and the space becomes available for the new leaf entry.
考题
多选题Which two operations can be performed on an external table（）ACreate a view on the table.BCreate an index on the table.CCreate a synonym on the table.DAdd a virtual column to the table.EUpdate the table using the UPDATE statement.FDelete rows in the table using the DELETE command.
考题
多选题Which two operations can be performed on an external table（）ACreate a view on the table.BCreate an index on the table.CCreate a synonym on the table.DAdd a virtual column to the table.EUpdate the table using the UPDATE statement.FDelete rows in the table using the DELETE command
考题
多选题You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index. Which two are possible if table updates are performed which affect the invisible index columns?（）AThe index remains invisible.BThe index is not updated by the DML statements on the indexed table.CThe index automatically becomes visible in order to have it updated by DML on the table.DThe index becomes unusable but the table is updated by the DML.EThe index is updated by the DML on the table.
考题
单选题As a result of performance analysis， you created an index on the prod_name column of the prod_det table， which contains about ten thousand rows. Later， you updated a product name in the table. How does this change affect the index？（）A
A leaf will be marked as invalid.B
An update in a leaf row takes place.C
The index will be updated automatically at commit.D
A leaf row in the index will be deleted and inserted.E
The index becomes invalid when you make any updates.
考题
单选题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
考题
单选题You find that some queries on a table are taking a long time to execute because there are no indexes created on the table. You decide to invoke the SQL Access Advisor to determine the appropriate index to be created. Which package will you use to invoke the SQL Access Advisor？（）A
DBMS_SERVER_ALERTB
DBMS_ADVISORC
DBMS_RESOURCE_MANAGERD
DBMS_REPAIR
考题
多选题Examine the SQL statements that creates ORDERS table: For which columns would an index be automatically created when you execute the above SQL statement? （）ASER_NOBORDER_IDCSTATUSDPROD_IDEORD_TOTALFComposite index on ORDER_ID and ORDER_DATE
考题
多选题Which two statements are true regarding B-tree indexs（）AThe leaf blocks in the index are doubly linked.BThe leaf node stores a bitmap for each key value.CThe rows with NULL value in key columns also have entries in the index.DThe deletion of a row from the table causes a logical deletion in index leaf block and the space becomesavailable for the new leaf entry
热门标签
最新试卷