MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 7 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. |
UPDATEUSAGE?$ |
| A. | @objname |
| B. | @updateusage |
| C. | All of the mentioned |
| Answer» B. @updateusage | |
| 2. |
Which_of_the_following_determines_type_or_resource_to_which_the_lock_applies_?$ |
| A. | sp_lock |
| B. | sp_who |
| C. | sp_monitor |
| D. | sp_spaceused |
| Answer» E. | |
| 3. |
_____________ displays an estimate of the current amount of disk space used by a table. |
| A. | sp_lock |
| B. | sp_who |
| C. | sp_monitor |
| D. | sp_spaceused |
| Answer» E. | |
| 4. |
Which of the following stored procedure reports snapshot information about current SQL Server user ? |
| A. | sp_lock |
| B. | sp_who |
| C. | sp_monitor |
| D. | sp_user |
| Answer» C. sp_monitor | |
| 5. |
_________ reports the total processor time with respect to the available capacity of the server. |
| A. | Disk Read Bytes/sec |
| B. | Avg.Disk Queue Length |
| C. | Processor time |
| D. | Response time |
| Answer» D. Response time | |
| 6. |
Which of the following is one of the most crucial performance counters for monitoring ? |
| A. | Disk Write Bytes/sec |
| B. | Memory Queue Length |
| C. | Virtual Memory |
| D. | All of the mentioned |
| Answer» B. Memory Queue Length | |
| 7. |
Which of the following option can be used to launch Perfmon ? |
| A. | Type “start perfmon” at the command prompt |
| B. | Go to Start | Programs | Administrative Tools | Performance Monitor |
| C. | Go to Start | Run | Perfmon |
| D. | All of the mentioned |
| Answer» E. | |