What command do you use to perform a query in SQL?
USE
SELECT
QUERY
CHOSE
What wildcard character retrieves all records with the SELECT command?
*
%
$
?
What would you use to combine two parameters in a query in SQL?
PLUS
BOTH
COMBINE
AND
What clause would you use with the SELECT command that would pull records based on a range?
COMBO
BETWEEN
OR
What keyword used with the SELECT statement is used to not output specified records?
DISALLOW
DISREGARD
NOT
What would you use to combine columns from two different tables?
JOIN
Which clause used with the SELECT command will return values that you want to exclude from the normal parameters?
EXCEPT
INTERSECT
SEARCH
EXCLUDE
What clause is used to combine related data from multiple table sources?
What statement would you use to add data to a table?
ADD
INSERT
PRESENT
What statement would you use to change data in a table?
CHANGE
MODIFY
UPDATE
What statement is used to delete one or more rows in a table?
DELETE
REMOVE
TRUNCATE
What statement is used to delete a table from a database?
DROP
How can you prevent the accidental loss of an entire table?
Use the DELETE TRANS command.
Use the LOOPBACK command.
Use the SAFEDELETE command.
Use referential integrity.
What do you perform when you want to recall specific records from a database?
recall
virtual extraction
reach
query
What command would you use to delete a table while leaving the table structure in place for future use?
DELETE TABLE
TRUNCATE TABLE
REMOVE TABLE
STOP TABLE
