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

Q. With SQL, how can you return the number of not null records in the “Persons” table?

View solution

Q. What does the ALTER TABLE clause do?

View solution

Q. The UPDATE SQL clause can _____________

View solution

Q. The UNION SQL clause can be used with _____________

View solution

Q. Which SQL statement is used to return only different values?

View solution

Q. How can you change “Hansen” into “Nilsen” in the “LastName” column in the Persons table?

View solution

Q. Which TCL command undo all the updates performed by the SQL in the transaction?

View solution