1. Which SQL keyword is used to retrieve a minimum value?

a)     DOWN

b)    LOW

c)     MIN

d)    LOWER

2. The INNER JOIN clause…

a)     returns all rows that have matching value in the field on which the 2 tables are joined.

b)    returns only the rows from the first table, which have non-matching values with the second table in the field on which the 2 tables are joined.

c)     returns all rows from 2 tables.

d)    returns all the matching rows from 2 tables.

3. Which SQL keyword is used to retrieve only unique values?

a)     DISTINCTIVE

b)    DIFFERENT

c)     DISTINCT

d)    UNIQUE

4. If you don't specify ASC or DESC after a SQL ORDER BY clause, the following is used by default:

a)     There is no default value.

b)    DESC

c)     ASC

d)    Random

5. What is an index?

a)     An index is a database table attribute, which speeds-up data search within a table.

b)    An index is the same as alias.

c)     An index is a special way to join 2 or more tables.

d)    An index is a database row attribute, which speeds-up data search within a table.

6. What does ACID stand for?

a)     Access. Consistency. Isolation. Data.

b)    Access. Constraint. Index. Data.

c)     Access. Constant. Information. Data.

d)    Atomicity. Consistency. Isolation. Durability.

7. Which of the following SQL statements is correct?

a)     TRUNCATE Sales TABLE

b)    TRUNCATE * FROM TABLE Sales

c)     TRUNCATE TABLE Sales

d)    TRUNCATE * FROM COLUMN Sales

8. The IN SQL keyword

a)     Is used with the DISTINCT SQL keyword only.

b)    Is used with the INSERT SQL keyword only.

c)     Determines if a value matches any of the values in a list or a sub-query.

d)    Defines the tables we are selecting or deleting data from.

9. Sub-queries can be nested in…

a)     UPDATE statements only.

b)    INSERT statements only.

c)     DELETE statements only.

d)    UPDATE, DELETE, INSERT and SELECT statements.

10. The LIKE SQL keyword is used along with ..

a)     WHERE clause.

b)    ORDER BY clause.

c)     JOIN clause.

d)    GROUP BY clause.