This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Builtin Functions”.
1. ______________ function returns current date and time.
a) SET DATEFIRST
b) SYSDATETIME
c) Cert_ID
d) GETDATE
View Answer
Explanation: GETDATE function is used to obtain the current system date and time. Although GETDATE doesn’t have any input parameters, you still need to include the parentheses in your code because that’s how SQL Server typically identifies functions.
2. Which of the following function checks whether the expression is a valid date or not?
a) ISDATE
b) ISDAY
c) ISVALID
d) ISYEAR
View Answer
Explanation: ISDATE() determines whether a datetime or smalldatetime input expression is a valid date or time value.
3. Which of the following is not a mathematical function?
a) ATN2
b) POWER
c) PI
d) CEIL
View Answer
Explanation: SQL Server has CEILING function to get the smallest integer greater than the specified expression.
4. @@NESTLEVEL function falls under which of the following category?
a) Configuration functions
b) Cursor functions
c) Mathematical functions
d) Date and Time Data Functions
View Answer
Explanation: Configuration functions return information about the current configuration.
5. __________ are used for supporting encryption, decryption, digital signing and their validation.
a) Cryptographic functions
b) Cursor functions
c) Configuration functions
d) None of the mentioned
View Answer
Explanation: Encryption and decryption of data is done by cryptographic functions.
6. DecryptByKeyAutoCert is ________________ type function.
a) Symmetric Encryption and decryption
b) Encryption Hashing
c) Asymmetric Encryption and decryption
d) Symmetric decryption with Automatic key handling
View Answer
Explanation: DecryptByKeyAutoCert function decrypts by using a symmetric key that is automatically decrypted with a certificate.
7. Text and Image Functions are ___________
a) nondeterministic
b) deterministic
c) table valued
d) all of the mentioned
View Answer
Explanation: Text and image functions are nondeterministic. This means they do not always return the same results every time they are called, even with the same set of input values.
8. Which of the following is not a conversion function?
a) CAST and CONVERT
b) PARSE
c) TRY_CAST
d) TRY_CASE
View Answer
Explanation: Conversion functions support data type casting and converting.
9. ______________ returns the rank of rows within the partition of a result set, without any gaps in the ranking.
a) RANK
b) NTILE
c) DENSE_RANK
d) ROW_NUMBER
View Answer
Explanation: DENSE_RANK function makes the rank of a row is one plus the number of distinct ranks that come before the row in question.
10. Built in Functions in SQL Server is categorized into how many categories?
a) 4
b) 5
c) 6
d) 7
View Answer
Explanation: SQL Server provides many built-in functions and also lets you create user-defined functions:- Rowset, Aggregate, Ranking and Scalar Function.
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]
- Practice Programming MCQs
- Check Information Technology Books
- Check SQL Server Books
- Apply for Programming Internship
