adplus-dvertising
frame-decoration

Question

The _________ database is used by SQL Server Agent for scheduling alerts and jobs, and recording operators.

a.

model

b.

msdb

c.

master

d.

temp

Answer: (b).msdb

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. The _________ database is used by SQL Server Agent for scheduling alerts and jobs, and recording operators.

Similar Questions

Discover Related MCQs

Q. Which of the following is a large object data type?

Q. Data types in SQL Server are organized into how many categories?

Q. Exact Numeric data type is ___________

Q. ntext data type falls under which category?

Q. A column of type __________ may contain rows of different data types.

Q. You want to track date and time of the last write access per row. Select the suitable option among the below.

Q. ________ is a spatial data type.

Q. Which of the following data type is not present in SQL Server?

Q. ______________ is monetary data type in SQL Server.

Q. Which of the data type has a storage size of 8 bytes?

Q. ______________ function returns current date and time.

Q. Which of the following function checks whether the expression is a valid date or not?

Q. Which of the following is not a mathematical function?

Q. @@NESTLEVEL function falls under which of the following category?

Q. __________ are used for supporting encryption, decryption, digital signing and their validation.

Q. DecryptByKeyAutoCert is ________________ type function.

Q. Text and Image Functions are ___________

Q. Which of the following is not a conversion function?

Q. ______________ returns the rank of rows within the partition of a result set, without any gaps in the ranking.

Q. Built in Functions in SQL Server is categorized into how many categories?