Quiz: SQL Introduction: Querying the Database

1. What command can be added to a select statement to return a subset of the data?
WHERE (*)
WHEN
ALL
EVERYONE

2. What command retrieves data from the database?
ALTER
SELECT (*)
DESCRIBE
INSERT

3. What command do you use to add rows to a table
INSERT (*)
ADD
ADD_ROW
NEW_ROW

4. What command can be used to show information about the structure of a table?
ALTER
SELECT
DESCRIBE (*)
INSERT

5. Examine the follolowing SELECT statement.
SELECT *
FROM employees;
This statement will retrieve all the rows in the employees table. True or False?
True (*)
False