Introduction to SQL

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

• COUNT(*)
• SUM()
• NUMBER()
• COUNT()

Which SQL keyword is used to retrieve a maximum value?

• MAX
• MOST
• TOP
• UPPER

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

• DELETE
• REMOVE
• DROP
• CLEAR

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

• TRUNCATE
• DELETE
• REMOVE
• DROP

Which of the following is not a DDL command?

• UPDATE
• TRUNCATE
• ALTER
• None of the Mentioned

Which of the following are TCL commands?

• ROLLBACK and SAVEPOINT
• UPDATE and TRUNCATE
• SELECT and INSERT
• GRANT and REVOKE

________________ is not a category of SQL command.

• SCL
• TCL
• DCL
• DDL

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

• ASC
• DESC
• There is no default value
• None of the mentioned

Which of the following statement is true?

• DELETE does not free the space containing the table and TRUNCATE free the space containing the table
• Both DELETE and TRUNCATE free the space containing the table
• Both DELETE and TRUNCATE does not free the space containing the table
• 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?

• The AS SQL clause is used to change the name of a column in the result set or to assign a name to a derived column
• The AS clause is used with the JOIN clause only
• The AS clause defines a search condition
• All of the mentioned