Explore topic-wise MCQs in Structured Query Language (SQL).

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. E-mail
B. Net send
C. Pager
D. All of the mentioned
Answer» E.
Discussion
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
Discussion
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
Discussion
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.
Discussion
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.
Discussion
6.

SQL Agent Job definitions are specified in which database ?

A. msdb
B. master
C. tempdb
D. all of the mentioned
Answer» B. master
Discussion
7.

SQL Server Agent consist of _____ component.

A. 2
B. 3
C. 4
D. 5
Answer» C. 4
Discussion
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
Discussion