MCQ IN COMPUTER SCIENCE & ENGINEERING

COMPUTER SCIENCE AND ENGINEERING

SQL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

Which of the following database is used by SQL Server Agent?

A	Pubs
B	Master
C	Tempdb
D	Model

Explanation:

Detailed explanation-1: -Which of the following database is used by SQL Server Agent? Explanation: The msdb database is used by SQL Server Agent for scheduling alerts and jobs, and recording operators.

Detailed explanation-2: -SQL Server Agent uses the SQLAgentUserRole, SQLAgentReaderRole, and SQLAgentOperatorRole fixed database roles in the msdb database to control access to SQL Server Agent for users who aren’t members of the sysadmin fixed server role.

Detailed explanation-3: -The msdb database is used by SQL Server Agent for scheduling alerts and jobs and by other features such as SQL Server Management Studio, Service Broker and Database Mail. For example, SQL Server automatically maintains a complete online backup-and-restore history within tables in msdb.

Detailed explanation-4: -Head over to SSMS and navigate to the SQL Server Agent on the bottom of the Object Explorer.

Detailed explanation-5: -The msdb database is mostly known as “the SQL Server Agent database” because it stores information of all SQL Agent jobs as their configuration and their execution history.

There is 1 question to complete.