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

View solution

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

View solution

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

View solution

Q. Exact Numeric data type is ___________

View solution

Q. ntext data type falls under which category?

View solution

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

View solution

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

View solution

Q. ________ is a spatial data type.

View solution

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

View solution

Q. ______________ is monetary data type in SQL Server.

View solution

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

View solution

Q. ______________ function returns current date and time.

View solution

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

View solution

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

View solution

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

View solution

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

View solution

Q. DecryptByKeyAutoCert is ________________ type function.

View solution

Q. Text and Image Functions are ___________

View solution

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

View solution

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

View solution