Suppose that a locking implementation of REPEATABLE READ requires that a transaction obtain an X lock on a table when a write is requested. When a read is requested, a transaction is required to obtain an IS lock on the
What will be an ideal response?
The INSERT statement requires an X lock on the table, and it cannot obtain that lock
if the select statement has an IS lock on the table.
You might also like to view...
The following are true about a HyperLink control, except __________.
a. its Text property is shown to the user at runtime b. it generates an event c. it allows the user to navigate to another Web page d. its Target property controls whether new page will appear in a separate window
To ensure that a workbook CANNOT be edited, you must ________
A) apply the Mark as Final status B) password protect the workbook C) click the Edit Anyway button D) rename the workbook
As shown in the accompanying figure, a ____ object forces the user to select only one option from a group of options.
A. CheckBox B. RadioButton C. TextBox D. CheckList
Match each term with the correct statement below.
A. A process that blocks a group of tracks and sectors to be used by a particular file system, such as NTFS B. Created to make stable images of files and folders on servers based on the point-in-time when the image is made C. A logical designation of disk storage that is created out of one or more physical disks D. Uses traditional disk management techniques and contains primary partitions, extended partitions, and logical drives E. Only backs up files that are new or that have been updated F. A process that creates a table containing file and folder information for a specific file system in a partition G. A backup of an entire system H. Does not use traditional partitioning I. Provides a means to establish multiple paths between a server and its disk storage