itgle.com

多选题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

题目
多选题
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.

相似考题

1.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 indexB. making the index invisibleC. making the index unusableD. using the MONITORING USAGE clause for the index

2.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

3.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.

4.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”相关问题

  • 第1题：

    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.

    正确答案:B

  • 第2题：

    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

    正确答案:B

  • 第3题：

    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

    正确答案:D

  • 第4题：

    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 LOGGING
    • B、 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.

    正确答案:C

  • 第5题：

    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.

    正确答案:A,D

  • 第6题：

    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.

    正确答案:A,E

  • 第7题：

    多选题
    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.


    正确答案： D,E
    解析： 暂无解析

  • 第8题：

    多选题
    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.


    正确答案： B,D
    解析： 暂无解析

  • 第9题：

    多选题
    Which two operations can be performed on an external table（）
    A

    Create a view on the table.

    B

    Create an index on the table.

    C

    Create a synonym on the table.

    D

    Add a virtual column to the table.

    E

    Update the table using the UPDATE statement.

    F

    Delete rows in the table using the DELETE command


    正确答案： E,F
    解析： 暂无解析

  • 第10题：

    单选题
    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.


    正确答案： E
    解析： 暂无解析

  • 第11题：

    单选题
    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_ALERT

    B

    DBMS_ADVISOR

    C

    DBMS_RESOURCE_MANAGER

    D

    DBMS_REPAIR


    正确答案： D
    解析： 暂无解析

  • 第12题：

    多选题
    Which two statements are true regarding B-tree indexs（）
    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 becomesavailable for the new leaf entry


    正确答案： C,B
    解析： 暂无解析

  • 第13题：

    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.

    正确答案:A

  • 第14题：

    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.

    正确答案:D

  • 第15题：

    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

    正确答案:D

  • 第16题：

    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.

    正确答案:B,F

  • 第17题：

    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 cluster
    • B、 Hash cluster
    • C、 Sorted Hash cluster
    • D、 Real Application Cluster

    正确答案:B

  • 第18题：

    单选题
    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


    正确答案： B
    解析： 暂无解析

  • 第19题：

    多选题
    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？ （）
    A

    Restore the lost data file from the backup， and then flash back the database.

    B

    Restore the data file pertaining to index tablespace， and then recover the tablespace.

    C

    Restore all the data files， and then perform an incomplete recovery to get the tablespace back.

    D

    Restore all the data files， and then perform an incomplete recovery using the backup control file.

    E

    Drop and re-create the index tablespace， and then re-create all of the indexes in that tablespace.


    正确答案： B,E
    解析： 暂无解析

  • 第20题：

    多选题
    Which two operations can be performed on an external table（）
    A

    Create a view on the table.

    B

    Create an index on the table.

    C

    Create a synonym on the table.

    D

    Add a virtual column to the table.

    E

    Update the table using the UPDATE statement.

    F

    Delete rows in the table using the DELETE command.


    正确答案： F,B
    解析： 暂无解析

  • 第21题：

    多选题
    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.


    正确答案： B,E
    解析： 暂无解析

  • 第22题：

    单选题
    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


    正确答案： D
    解析： 暂无解析

  • 第23题：

    多选题
    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_NO

    B

    ORDER_ID

    C

    STATUS

    D

    PROD_ID

    E

    ORD_TOTAL

    F

    Composite index on ORDER_ID and ORDER_DATE


    正确答案： C,F
    解析： 暂无解析

相关内容