250+ TOP MCQs on SQL Server Agent and Answers

SQL Server Multiple Choice Questions on “SQL Server Agent”.

1. __________ 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: c
Clarification: The SQL Server Agent is a service that lets you configure scheduled tasks and system alerts.

2. Point out the correct statement.
a) SQL Server Agent uses SQL Server to store job information
b) SQL Server Agent can run a job on a schedule
c) By default, the SQL Server Agent service is disabled when SQL Server 2014 is installed
d) All of the mentioned

Answer: d
Clarification: SQL Server Agent runs continuously in the background as a Windows Service.

3. SQL Server Agent consist of _____ component.
a) 2
b) 3
c) 4
d) 5

Answer: b
Clarification: SQL Server Agent consist of jobs,alerts and operators.

4. SQL Agent Job definitions are specified in which database?
a) msdb
b) master
c) tempdb
d) all of the mentioned

Answer: a
Clarification: msdb is a system database that is created when you first install SQL Server.

5. Point out the wrong statement.
a) SQL Server Log shipping allows you to automate a variety of administrative task
b) SQL Server task manager allows you to automate a variety of administrative task
c) SQL Server Agent allows you to automate a variety of administrative task
d) All of the mentioned

Answer: c
Clarification: SQL Server Agent is used to create and schedule a job that automates database administration.

6. _________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: d
Clarification: Open up Microsoft SQL Server Configuration Manager and locate the SQL Server Agent service. If the status of that service is “RUNNING”, you do not need to do anything.

7. 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: d
Clarification: A schedule specifies when a job runs.

8. 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: c
Clarification: An alert is an automatic response to a specific event. For example, an event can be a job that starts or system resources that reach a specific threshold.

9. SQL Server can notify operators of alerts through ____________
a) E-mail
b) Net send
c) Pager
d) All of the mentioned

Answer: d
Clarification: An operator defines contact information for an individual responsible for the maintenance of one or more instances of SQL Server.

10. 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: b
Clarification: Members of the SQLAgentUserRole, SQLAgentReaderRole, and SQLAgentOperatorRole fixed database roles in msdb, and members of the sysadmin fixed server role have access to SQL Server Agent.