MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 8 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
WHICH_OF_THE_FOLLOWING_LOCK_IS_INCOMPATIBLE_WITH_ALL_LOCK_MODES_??$ |
| A. | Intent exclusive (IX) |
| B. | Schema stability |
| C. | Schema modification |
| D. | Bulk update |
| Answer» D. Bulk update | |
| 2. |
Which_of_the_following_mode_has_exclusive_range_and_exclusive_resource_lock_?$ |
| A. | RangeX_X |
| B. | RangeS_U |
| C. | RangeS_S |
| D. | RangeI_N |
| Answer» B. RangeS_U | |
| 3. |
Which of the following mode indicates the intention of the transaction to read all of the resources lower in the hierarchy ? |
| A. | IS |
| B. | IX |
| C. | SIX |
| D. | All of the mentioned |
| Answer» D. All of the mentioned | |
| 4. |
Which of the following locking hint is similar to NOLOCK ? |
| A. | PAGLOCK |
| B. | READCOMMITTED |
| C. | READUNCOMMITTED |
| D. | SERIALIZABLE |
| Answer» D. SERIALIZABLE | |
| 5. |
__________ locks allow processes to bulk copy data concurrently into the same table. |
| A. | Bulk update |
| B. | Bulk import |
| C. | Bulk export |
| D. | Bulk copy |
| Answer» B. Bulk import | |
| 6. |
Which is the most restrictive isolation level in transaction ? |
| A. | Repeatable Read |
| B. | Snapshot |
| C. | Read Committed |
| D. | SERIALIZABLE |
| Answer» E. | |
| 7. |
______________ allow concurrent transactions to read (SELECT) a resource. |
| A. | Update locks |
| B. | Shared locks |
| C. | Exclusive Locks |
| D. | All of the mentioned |
| Answer» C. Exclusive Locks | |
| 8. |
Which of the following resource can be locked in SQL Server ? |
| A. | TID |
| B. | RID |
| C. | PID |
| D. | SID |
| Answer» C. PID | |