Loading...

SQL Server

_____________ function returns current date and time.
  1. SET DATEFIRST
  2. SYSDATETIME
  3. Cert_ID
  4. GETDATE
Which of the following function checks whether the expression is a valid date or not ?
  1. ISDATE
  2. ISDAY
  3. ISVALID
  4. ISYEAR
Which of the following is not a mathematical function ?
  1. ATN2
  2. POWER
  3. PI
  4. CEIL
@@NESTLEVEL function falls under which of the following category ?
  1. Configuration functions
  2. Cursor functions
  3. Mathematical functions
  4. Date and Time Data Functions
__________ are used for supporting encryption, decryption, digital signing and their validation.
  1. Cryptographic functions
  2. Cursor functions
  3. Configuration functions
  4. None of the mentioned
DecryptByKeyAutoCert is ________________ type function.
  1. Symmetric Encryption and decryption
  2. Encryption Hashing
  3. Asymmetric Encryption and decryption
  4. Symmetric decryption with Automatic key handling
Text and Image Functions are ___________
  1. nondeterministic
  2. deterministic
  3. table valued
  4. All of the mentioned
Which of the the following is not conversion function?
  1. CAST and CONVERT
  2. PARSE
  3. TRY_CAST
  4. TRY_CASE
______________ returns the rank of rows within the partition of a result set, without any gaps in the ranking.
  1. RANK
  2. NTILE
  3. DENSE_RANK
  4. ROW_NUMBER
Built in Functions in SQL Server is categorized in to how many category ?
  1. 4
  2. 5
  3. 6
  4. 7