SQL Server Agent Questions and Answers

This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses 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
View Answer

Answer: c
Explanation: 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
View Answer

Answer: d
Explanation: 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
View Answer

Answer: b
Explanation: 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
View Answer

Answer: a
Explanation: 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
View Answer

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

Sanfoundry Certification Contest of the Month is Live. 100+ Subjects. Participate Now!

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
View Answer

Answer: d
Explanation: 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
View Answer

Answer: d
Explanation: 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
View Answer

Answer: c
Explanation: 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
View Answer

Answer: d
Explanation: 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
View Answer

Answer: b
Explanation: 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.

Sanfoundry Global Education & Learning Series – SQL Server.

To practice all areas of SQL Server, here is complete set of 1000+ Multiple Choice Questions and Answers.

If you find a mistake in question / option / answer, kindly take a screenshot and email to [email protected]

« Prev - SQL Server Questions and Answers – Database Maintenance

» Next - SQL Server Questions and Answers – Transferring Database

Related Posts:

Recommended Articles: