niusouti.com

单选题How does DB2 protect the integrity of indexes when data is updated?（）A Locks are acquired on the data.B Locks are acquired on index keys.C Locks are acquired on index pages.D Locks are acquired on index pointers.

题目
单选题
How does DB2 protect the integrity of indexes when data is updated?（）
A

Locks are acquired on the data.

B

Locks are acquired on index keys.

C

Locks are acquired on index pages.

D

Locks are acquired on index pointers.

相似考题

1.What is true regarding InnoDB locking?()A.InnoDB uses row and table-level locks, but row locks are not escalatesB.InnoDB locks only those rows that are updatedC.InnoDB only uses row locks, not page or table-level locksD.InnoDB row locks may be escalated to page or table-level locksE.InnoDB uses row-level or table-level locks depending on the number of rows affected

2.钮锁、拉杆、桥锁、桥板是用于绑扎集装箱的工具。（）A、Lashing bars, twist locks, bridge plates and bridge fittings are tools used for lashing containers.B、Twist locks, bridge plates, bridge fittings and lashing bars are tools used for lashing containers.C、Twist locks, lashing bars, bridge fittings and bridge plates are tools used for lashing containers.D、Lashing bars, bridge fittings, bridge plates and twist locks are tools used for lashing containers.

3. You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named named Dworks in the instance. The Dworks table has a table named BillDetails which has a clustered primary key named BillId on the BillId column. The BillDetails table has a single XML column named GoodsDetails. The XML column has an XML index and XML data are stored in this XML column. A new column named GoodsID is added to the BillDetails table. GoodsID must be included in the primary key.  So what action should you perform to achieve this goal？（）  A、You should drop the XML index on the table. Modify the primary key. Recreate the XML index B、You should alter the XML index and set the ALLOW_ROW_LOCKS = OFF option. Alter the primary key and set the ALLOW_ROW_LOCKS = ON option. C、You should move the XML data to a temporary table. Clear the XML data from the original table by setting the GoodsDetails column to NULL. Modify the primary key. Repopulate the ProductSpecs column. D、You should disable the XML index on the GoodsDetails column. Modify the primary key.Enable the XML index on the ProductSpecs column.

4.Onboard a Ro-Ro vessel many decks are used for the carriage of both rolling and container cargoes，as such it is most useful if a deck socket accepts both ______．A.Twist-Locks and lashing hooksB.Container locks and bridge fittingsC.Bridge fittings and lashing hooksD.Twist-locks and container locks

更多“单选题How does DB2 protect the integrity of indexes when data is updated?（）A Locks are acquired on the data.B Locks are acquired on index keys.C Locks are acquired on index pages.D Locks are acquired on index pointers.”相关问题

  • 第1题：

    How does DB2 protect the integrity of indexes when data is updated?（）

    • A、Locks are acquired on the data.
    • B、Locks are acquired on index keys.
    • C、Locks are acquired on index pages.
    • D、Locks are acquired on index pointers.

    正确答案:A

  • 第2题：

    Which two statements are true about a bitmap index？ （）

    • A、It is recommended for the columns that have unique values.
    • B、It can be converted to a B-tree index by using the ALTER INDEX command.
    • C、It has a bitmap segment for each distinct value in the key column， containing a string of bits in which each bit represents the presence or absence of a key column value.
    • D、Updating the key column locks the whole bitmap segment that contains the bit for the key value to be updated.

    正确答案:C,D

  • 第3题：

    Which  statements are correct about temporary tables（）

    • A、Indexes and views can be created on temporary tables.
    • B、Both the data and the structure of temporary tables can be exported.
    • C、Temporary tables are always created in a user’s temporary tablespace.
    • D、The data inserted into a temporary table in a session is available to other sessions.
    • E、Data manipulation language （DML） locks are never acquired on the data of temporary tables

    正确答案:A,C,E

  • 第4题：

    Which statement is true about loading data using the conventional path of SQL*Loader（）

    • A、Redo is not generated while performing conventional path loads.
    • B、Only PRIMARY KEY， UNIQUE KEY， and NOT NULL constraints are checked.
    • C、No exclusive locks are acquired when the conventional path loads are performed.
    • D、Instead of performing transactions， SQL*Loader directly writes data blocks to the data files.
    • E、INSERT triggers are disabled before the conventional path load and reenabled at the end of the load.

    正确答案:C

  • 第5题：

    Which statement is true about loading data using the conventional path of SQL*Loader（）

    • A、Redo is not generated while performing conventional path loads.
    • B、Only PRIMARY KEY， UNIQUE KEY， and NOT NULL constraints are checked.
    • C、No exclusive locks are acquired when the conventional path loads are performed.
    • D、Instead of performing transactions， SQL*Loader directly writes data blocks to the data files.
    • E、INSERT triggers are disabled before the conventional path load and reenabled at the end of the load

    正确答案:C

  • 第6题：

    Which two statements describe good practices for an application developer to reduce lockingconflicts in Oracle database（）

    • A、Avoid coding unnecessary long-running transactions.
    • B、Allow the database to handle locks in default locking mode.
    • C、Always explicitly code the locks as per the requirement of the application.
    • D、Allow escalation of row locks to block locks if too many row locks cause problem.

    正确答案:A,B

  • 第7题：

    单选题
    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
    解析： 暂无解析

  • 第8题：

    单选题
    Which of the following best describes how locks are used in DB2?（）
    A

    To maintain control of updated rows for commit processing

    B

    To ensure only committed changes are altered by another application

    C

    To allow two applications to update the same row of data simultaneously

    D

    To prevent multiple applications from accessing the same data simultaneously


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

  • 第9题：

    多选题
    On your Oracle 12c database, you Issue the following commands to create indexes SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customers_id, sales_rep_id) INVISIBLE; SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customers_id, sales_rep_id); Which two statement are correct?（）
    A

    Both the indexes are created; however, only the ORD_COSTOMER index is visible.

    B

    The optimizer evaluates index access from both the Indexes before deciding on which index to use for query execution plan.

    C

    Only the ORD_CUSTOMER_IX1 index is created.

    D

    Only the ORD_CUSTOMER_IX2 index is created.

    E

    Both the indexes are updated when a new row is inserted, updated, or deleted In the orders table.


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

  • 第10题：

    单选题
    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named named Dworks in the instance. The Dworks table has a table named BillDetails which has a clustered primary key named BillId on the BillId column. The BillDetails table has a single XML column named GoodsDetails. The XML column has an XML index and XML data are stored in this XML column. A new column named GoodsID is added to the BillDetails table. GoodsID must be included in the primary key.  So what action should you perform to achieve this goal？（）
    A

    You should drop the XML index on the table. Modify the primary key. Recreate the XML index 

    B

    You should alter the XML index and set the ALLOW_ROW_LOCKS = OFF option. Alter the primary key and set the ALLOW_ROW_LOCKS = ON option. 

    C

    You should move the XML data to a temporary table. Clear the XML data from the original table by setting the GoodsDetails column to NULL. Modify the primary key. Repopulate the ProductSpecs column. 

    D

    You should disable the XML index on the GoodsDetails column. Modify the primary key.Enable the XML index on the ProductSpecs column.


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

  • 第11题：

    多选题
    Which two statements are true about a bitmap index？ （）
    A

    It is recommended for the columns that have unique values.

    B

    It can be converted to a B-tree index by using the ALTER INDEX command.

    C

    It has a bitmap segment for each distinct value in the key column， containing a string of bits in which each bit represents the presence or absence of a key column value.

    D

    Updating the key column locks the whole bitmap segment that contains the bit for the key value to be updated.


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

  • 第12题：

    单选题
    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
    解析： 暂无解析

  • 第13题：

    Which of the following best describes how locks are used in DB2?（）

    • A、To maintain control of updated rows for commit processing
    • B、To ensure only committed changes are altered by another application
    • C、To allow two applications to update the same row of data simultaneously
    • D、To prevent multiple applications from accessing the same data simultaneously

    正确答案:B

  • 第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题：

    What is true regarding InnoDB locking?（）

    • A、InnoDB uses row and table-level locks, but row locks are not escalates
    • B、InnoDB locks only those rows that are updated
    • C、InnoDB only uses row locks, not page or table-level locks
    • D、InnoDB row locks may be escalated to page or table-level locks
    • E、InnoDB uses row-level or table-level locks depending on the number of rows affected

    正确答案:B

  • 第16题：

    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

  • 第17题：

    Which three statements are correct about temporary tables？（）

    • A、Indexes and views can be created on temporary tables.
    • B、Both the data and the structure of temporary tables can be exported.
    • C、Temporary tables are always created in a user’s temporary tablespace.
    • D、The data inserted into a temporary table in a session is available to other sessions.
    • E、Data manipulation language （DML） locks are never acquired on the data of temporary tables.

    正确答案:A,C,E

  • 第18题：

    单选题
    Which statement is true about loading data using the conventional path of SQL*Loader（）
    A

    Redo is not generated while performing conventional path loads.

    B

    Only PRIMARY KEY， UNIQUE KEY， and NOT NULL constraints are checked.

    C

    No exclusive locks are acquired when the conventional path loads are performed.

    D

    Instead of performing transactions， SQL*Loader directly writes data blocks to the data files.

    E

    INSERT triggers are disabled before the conventional path load and reenabled at the end of the load.


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

  • 第19题：

    单选题
    Which statement is true about loading data using the conventional path of SQL*Loader（）
    A

    Redo is not generated while performing conventional path loads.

    B

    Only PRIMARY KEY， UNIQUE KEY， and NOT NULL constraints are checked.

    C

    No exclusive locks are acquired when the conventional path loads are performed.

    D

    Instead of performing transactions， SQL*Loader directly writes data blocks to the data files.

    E

    INSERT triggers are disabled before the conventional path load and reenabled at the end of the load


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

  • 第20题：

    多选题
    Which  statements are correct about temporary tables（）
    A

    Indexes and views can be created on temporary tables.

    B

    Both the data and the structure of temporary tables can be exported.

    C

    Temporary tables are always created in a user’s temporary tablespace.

    D

    The data inserted into a temporary table in a session is available to other sessions.

    E

    Data manipulation language （DML） locks are never acquired on the data of temporary tables


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

  • 第21题：

    单选题
    What is true regarding InnoDB locking?（）
    A

    InnoDB uses row and table-level locks, but row locks are not escalates

    B

    InnoDB locks only those rows that are updated

    C

    InnoDB only uses row locks, not page or table-level locks

    D

    InnoDB row locks may be escalated to page or table-level locks

    E

    InnoDB uses row-level or table-level locks depending on the number of rows affected


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

  • 第22题：

    多选题
    Which three statements are correct about temporary tables？（）
    A

    Indexes and views can be created on temporary tables.

    B

    Both the data and the structure of temporary tables can be exported.

    C

    Temporary tables are always created in a user’s temporary tablespace.

    D

    The data inserted into a temporary table in a session is available to other sessions.

    E

    Data manipulation language （DML） locks are never acquired on the data of temporary tables.


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

  • 第23题：

    单选题
    How does DB2 protect the integrity of indexes when data is updated?（）
    A

    Locks are acquired on the data.

    B

    Locks are acquired on index keys.

    C

    Locks are acquired on index pages.

    D

    Locks are acquired on index pointers.


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

  • 第24题：

    单选题
    钮锁、拉杆、桥锁、桥板是用于绑扎集装箱的工具。（）
    A

    Lashing bars, twist locks, bridge plates and bridge fittings are tools used for lashing containers.

    B

    Twist locks, bridge plates, bridge fittings and lashing bars are tools used for lashing containers.

    C

    Twist locks, lashing bars, bridge fittings and bridge plates are tools used for lashing containers.

    D

    Lashing bars, bridge fittings, bridge plates and twist locks are tools used for lashing containers.


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

相关内容