Clauses
1.

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

DELETE

 B.  

REMOVE

 C.  

DROP

 D.  

CLEAR
2.

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

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

 B.  

The AS clause is used with the JOIN clause only

 C.  

The AS clause defines a search condition

 D.  

All of the mentioned
3.

If we have not specified ASC or DESC after a SQL ORDER BY clause, the following is used by default
A.  

DESC

 B.  

ASC

 C.  

There is no default value

 D.  

None of the mentioned
4.

Which of the following statement is true?
A.  

TRUNCATE free the table space while DELETE does not.

 B.  

Both TRUNCATE and DELETE statements free the table's space.

 C.  

Both TRUNCATE and DELETE statement does not free the table's space.

 D.  

DELETE free the table space while TRUNCATE does not.
5.

Which of the following is true about the HAVING clause?
A.  

Similar to the WHERE clause but is used for columns rather than groups.

 B.  

Similar to WHERE clause but is used for rows rather than columns.

 C.  

Similar to WHERE clause but is used for groups rather than rows.

 D.  

Acts exactly like a WHERE clause.
6.

_______ clause creates temporary relation for the query on which it is defined.
A.  

WITH

 B.  

FROM

 C.  

WHERE

 D.  

SELECT
7.

Which of the following is true about the SQL AS clause?
A.  

The AS clause in SQL is used to change the column name in the output or assign a name to a derived column.

 B.  

The SQL AS clause can only be used with the JOIN clause.

 C.  

The AS clause in SQL is used to defines a search condition.

 D.  

All of the mentioned
8.

When the wildcard in a WHERE clause is useful?
A.  

When an exact match is required in a SELECT statement.

 B.  

When an exact match is not possible in a SELECT statement.

 C.  

When an exact match is required in a CREATE statement.

 D.  

When an exact match is not possible in a CREATE statement.
9.

What SQL clause is used to restrict the rows returned by a query?
A.  

AND

 B.  

FROM

 C.  

HAVING

 D.  

WHERE
10.

To combine the result-set of two or more SELECT statements, SQL clause used is
A.  

SQL UNION

 B.  

SQL JOIN

 C.  

SQL GROUP BY

 D.  

NONE