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

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

View solution

Q. Which SQL function is used to count the number of rows in a SQL query?

View solution

Q. Which of the following SQL clauses is used to DELETE tuples from a database table?

View solution

Q. ___________removes all rows from a table without logging the individual row deletions.

View solution

Q. Which of the following is not a DDL command?

View solution

Q. Which of the following are TCL commands?

View solution