SQL 2011 Quiz
John Duncan


1. What does SQL stand for?
	A)Structured Question Language
	B)Strong Question Language
	C)Structured Query Language
	D)Structured Queue Language

2. What does the SQL FROM clause do?
	A)Specifies a search condition.
	B)Specifies the tables to retrieve rows from.
	C)Specifies the columns we are retrieving
	D)Specifies the attributes to retrieve rows from.

3. Which of the following SQL clauses is used to enter data into a SQL table?
	A)INSERT INTO
	B)WRITE
	C)ENTER
	D)SELECT

4. Which 2 SQL keywords specify the sorting direction of the result set retrieved with ORDER BY clause.
	A)ASC and DESC
	B)HIGH and LOW
	C)UP and DOWN
	D)Top and Bottom

5. We refer to a join as a self-join when…
	A)we are using left and right join together
	B)We are joining two tables only
	C)we are joining more than 2 tables
	D)we are joining table to itself

6. RDBMS stands for…
	A)Real Database Management System
	B)Relational Database Management System
	C)Read Database Master System
	D)Realtime Database Management System

7. The table rows are also known as…
	A)Attributes
	B)Fields
	C)Records
	D)Entity

8. If you join a table to itself, what kind of join are you using?
	A)Selective Join.
	B)Natural Joun
	C)You can't join a table to itself.
	D)Self Join

9. The UPDATE SQL clause can…
	A)update only one row at a time.
	B)update more than one row at a time.
	C)delete more than one row at a time.
	D)delete only one row at a time.

10. Which SQL statement selects all rows from table called Contest, with column ContestDate having values greater or equal to May 25, 20006?
	A)SELECT * FROM Contest HAVING ContestDate >= '05/25/2006'
	B)SELECT * FROM Contest WHERE ContestDate < '05/25/2006'
	C)SELECT * FROM Contest GROUPBY ContestDate >= '05/25/2006'
	D)SELECT * FROM Contest WHERE ContestDate >= '05/25/2006'

11. Which SQL keyword is used to retrieve a minimum value?
	A)DOWN
	B)LOW
	C)MIN
	D)LOWER

12. 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.

13. Which SQL keyword is used to retrieve only unique values?
	A)DISTINCTIVE
	B)DIFFERENT
	C)DISTINCT
	D)UNIQUE

14. 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

15. 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.

16. 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.

17. 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

18. 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.

19. 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.

20. The LIKE SQL keyword is used along with ..
	A)WHERE clause.
	B)ORDER BY clause.
	C)JOIN clause.
	D)GROUP BY clause.