Loading...

SQL Server

Which SQL function is used to count the number of rows in a SQL query ?
  1. COUNT()
  2. NUMBER()
  3. SUM()
  4. COUNT(*)
Which SQL keyword is used to retrieve a maximum value ?
  1. MOST
  2. TOP
  3. MAX
  4. UPPER
Which of the following SQL clauses is used to DELETE tuples from a database table ?
  1. DELETE
  2. REMOVE
  3. DROP
  4. CLEAR
___________removes all rows from a table without logging the individual row deletions.
  1. DELETE
  2. REMOVE
  3. DROP
  4. TRUNCATE
Which of the following is not a DDL command ?
  1. UPDATE
  2. TRUNCATE
  3. ALTER
  4. None of the Mentioned
Which of the following are TCL commands ?
  1. UPDATE and TRUNCATE
  2. SELECTand INSERT
  3. GRANT and REVOKE
  4. ROLLBACK and SAVEPOINT
________________ is not a category of SQL command.
  1. TCL
  2. SCL
  3. DCL
  4. DDL
If you don’t specify ASC or DESC after a SQL ORDER BY clause, the following is used by default
  1. ASC
  2. DESC
  3. There is no default value
  4. None of the mentioned
Which of the following statement is true ?
  1. DELETE does not free the space containing the table and TRUNCATE free the space containing the table
  2. Both DELETE and TRUNCATE free the space containing the table
  3. Both DELETE and TRUNCATE does not free the space containing the table
  4. DELETE free the space containing the table and TRUNCATE does not free the space containing the table
What is the purpose of the SQL AS clause ?
  1. The AS SQL clause is used change the name of a column in the result set or to assign a name to a derived column
  2. The AS clause is used with the JOIN clause only
  3. The AS clause defines a search condition
  4. All of the mentioned