单选题How does DB2 protect the integrity of indexes when data is updated?（）ALocks are acquired on the data.BLocks are acquired on index keys.CLocks are acquired on index pages.DLocks 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.
参考解析
解析：
暂无解析
相关考题：
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
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
钮锁、拉杆、桥锁、桥板是用于绑扎集装箱的工具。（）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.
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.
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.
Which of the following best describes how locks are used in DB2?（）A、To maintain control of updated rows for commit processingB、To ensure only committed changes are altered by another applicationC、To allow two applications to update the same row of data simultaneouslyD、To prevent multiple applications from accessing the same data simultaneously
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.
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.
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
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
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.
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
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
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.
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.
单选题Which statement is true about loading data using the conventional path of SQL*Loader（）ARedo is not generated while performing conventional path loads.BOnly PRIMARY KEY， UNIQUE KEY， and NOT NULL constraints are checked.CNo exclusive locks are acquired when the conventional path loads are performed.DInstead of performing transactions， SQL*Loader directly writes data blocks to the data files.EINSERT triggers are disabled before the conventional path load and reenabled at the end of the load.
单选题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？（）AA leaf will be marked as invalid.BAn update in a leaf row takes place.CThe index will be updated automatically at commit.DA leaf row in the index will be deleted and inserted.EThe index becomes invalid when you make any updates
单选题Which statement is true about loading data using the conventional path of SQL*Loader（）ARedo is not generated while performing conventional path loads.BOnly PRIMARY KEY， UNIQUE KEY， and NOT NULL constraints are checked.CNo exclusive locks are acquired when the conventional path loads are performed.DInstead of performing transactions， SQL*Loader directly writes data blocks to the data files.EINSERT triggers are disabled before the conventional path load and reenabled at the end of the load
单选题Which of the following best describes how locks are used in DB2?（）ATo maintain control of updated rows for commit processingBTo ensure only committed changes are altered by another applicationCTo allow two applications to update the same row of data simultaneouslyDTo prevent multiple applications from accessing the same data simultaneously
多选题Which statements are correct about temporary tables（）AIndexes and views can be created on temporary tables.BBoth the data and the structure of temporary tables can be exported.CTemporary tables are always created in a user’s temporary tablespace.DThe data inserted into a temporary table in a session is available to other sessions.EData manipulation language （DML） locks are never acquired on the data of temporary tables
多选题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?（）ABoth the indexes are created; however, only the ORD_COSTOMER index is visible.BThe optimizer evaluates index access from both the Indexes before deciding on which index to use for query execution plan.COnly the ORD_CUSTOMER_IX1 index is created.DOnly the ORD_CUSTOMER_IX2 index is created.EBoth the indexes are updated when a new row is inserted, updated, or deleted In the orders table.
单选题What is true regarding InnoDB locking?（）AInnoDB uses row and table-level locks, but row locks are not escalatesBInnoDB locks only those rows that are updatedCInnoDB only uses row locks, not page or table-level locksDInnoDB row locks may be escalated to page or table-level locksEInnoDB uses row-level or table-level locks depending on the number of rows affected
单选题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？（）AYou should drop the XML index on the table. Modify the primary key. Recreate the XML index BYou 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. CYou 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. DYou should disable the XML index on the GoodsDetails column. Modify the primary key.Enable the XML index on the ProductSpecs column.
多选题Which three statements are correct about temporary tables？（）AIndexes and views can be created on temporary tables.BBoth the data and the structure of temporary tables can be exported.CTemporary tables are always created in a user’s temporary tablespace.DThe data inserted into a temporary table in a session is available to other sessions.EData manipulation language （DML） locks are never acquired on the data of temporary tables.
多选题Which two statements are true about a bitmap index？ （）AIt is recommended for the columns that have unique values.BIt can be converted to a B-tree index by using the ALTER INDEX command.CIt 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.DUpdating the key column locks the whole bitmap segment that contains the bit for the key value to be updated.
单选题How does DB2 protect the integrity of indexes when data is updated?（）ALocks are acquired on the data.BLocks are acquired on index keys.CLocks are acquired on index pages.DLocks are acquired on index pointers.
单选题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？（）AA leaf will be marked as invalid.BAn update in a leaf row takes place.CThe index will be updated automatically at commit.DA leaf row in the index will be deleted and inserted.EThe index becomes invalid when you make any updates.
单选题钮锁、拉杆、桥锁、桥板是用于绑扎集装箱的工具。（）ALashing bars, twist locks, bridge plates and bridge fittings are tools used for lashing containers.BTwist locks, bridge plates, bridge fittings and lashing bars are tools used for lashing containers.CTwist locks, lashing bars, bridge fittings and bridge plates are tools used for lashing containers.DLashing bars, bridge fittings, bridge plates and twist locks are tools used for lashing containers.