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

Q. ________________ is not a category of SQL command.

View solution

Q. If you don’t specify ASC or DESC after a SQL ORDER BY clause, the following is used by default ______________

View solution

Q. What is the purpose of the SQL AS clause?

View solution

Q. What does DML stand for?

View solution

Q. With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” ends with an “a”?

View solution

Q. With SQL, how can you return all the records from a table named “Persons” sorted descending by “FirstName”?

View solution