MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 4 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. |
AN_XML_DEADLOCK_GRAPH_HAS________MAIN_SECTIONS.?$ |
| A. | 2 |
| B. | 3 |
| C. | 4 |
| D. | 5 |
| Answer» C. 4 | |
| 2. |
______________section_lists_all_the_resources_that_were_involved_in_the_deadlock.$ |
| A. | Processes |
| B. | Resources |
| C. | WAIT stats |
| D. | All of the mentioned |
| Answer» D. All of the mentioned | |
| 3. |
Which of the following occurs when two connections need access to same piece of data concurrently and the meanwhile another is blocked because at a particular time, only one connection can have access ? |
| A. | Lock |
| B. | Block |
| C. | Deadlock |
| D. | Exclusive lock |
| Answer» C. Deadlock | |
| 4. |
Which of the following design strategy can reduce the occurrence of blocking locks ? |
| A. | Use non-clustered indexes on high-usage tables |
| B. | Use clustered indexes on high-usage tables |
| C. | Use clustered indexes on less-usage tables |
| D. | Make sure that CREATE and DROP statements use an existing index |
| Answer» C. Use clustered indexes on less-usage tables | |