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. |
SQL_SERVER_CAN_NOTIFY_OPERATORS_OF_ALERTS_THROUGH_:?$ |
| A. | |
| B. | Net send |
| C. | Pager |
| D. | All of the mentioned |
| Answer» E. | |
| 2. |
Which_of_the_following_members_has_access_to_SQL_Server_Agent_?$ |
| A. | members of the systemadmin |
| B. | members of the sysadmin |
| C. | members of the sysadministraion |
| D. | None of the mentioned |
| Answer» C. members of the sysadministraion | |
| 3. |
An alert can respond to one of the following conditions ? |
| A. | Whenever SQL Server Agent starts |
| B. | On a recurring schedule |
| C. | SQL Server performance conditions |
| D. | All of the mentioned |
| Answer» D. All of the mentioned | |
| 4. |
Which of the following condition is considered for schedule ? |
| A. | Whenever SQL Server Agent starts |
| B. | On a recurring schedule |
| C. | SQL Server performance conditions |
| D. | All of the mentioned |
| Answer» E. | |
| 5. |
_________start and stop the SQL Server Agent Service . |
| A. | SSMS |
| B. | Windows Services console |
| C. | QL Server Service Manager |
| D. | All of the mentioned |
| Answer» E. | |
| 6. |
SQL Agent Job definitions are specified in which database ? |
| A. | msdb |
| B. | master |
| C. | tempdb |
| D. | all of the mentioned |
| Answer» B. master | |
| 7. |
SQL Server Agent consist of _____ component. |
| A. | 2 |
| B. | 3 |
| C. | 4 |
| D. | 5 |
| Answer» C. 4 | |
| 8. |
__________ is a Microsoft Windows service that executes scheduled administrative tasks, which are called jobs in SQL Server 2014. |
| A. | Log shipping |
| B. | Task |
| C. | Agent |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |