WGU C170 EXAM STUDY GUIDE
DML - Answer -IUDS, CR
insert, update, delete, select
commit, rollback
INSERT - Answer -add new rows
UPDATE - Answer -modify data of existing rows
DELETE - Answer -delete some/all records from database
can be rolled back
COMMIT - Answer -permanently saves
ROLLBACK - Answer -undo changes
SELECT - Answer -data retrieval
WHERE - Answer -limits rows returned
used before group by
ORDER BY - Answer -OC
sorts columns
GROUP BY - Answer -GR
groups rows
BETWEEN - Answer -within range
IS NULL - Answer -value is null
LIKE - Answer -value matches string pattern
IN - Answer -checks value if it matches given value list
EXISTS - Answer -checks if subquery returns any rows
COUNT - Answer -tally amount of NON-NULL values
SUM - Answer -total sum for specified attribute
DML - Answer -IUDS, CR
insert, update, delete, select
commit, rollback
INSERT - Answer -add new rows
UPDATE - Answer -modify data of existing rows
DELETE - Answer -delete some/all records from database
can be rolled back
COMMIT - Answer -permanently saves
ROLLBACK - Answer -undo changes
SELECT - Answer -data retrieval
WHERE - Answer -limits rows returned
used before group by
ORDER BY - Answer -OC
sorts columns
GROUP BY - Answer -GR
groups rows
BETWEEN - Answer -within range
IS NULL - Answer -value is null
LIKE - Answer -value matches string pattern
IN - Answer -checks value if it matches given value list
EXISTS - Answer -checks if subquery returns any rows
COUNT - Answer -tally amount of NON-NULL values
SUM - Answer -total sum for specified attribute
