WGU C170 EXAM WITH 100% CORRECT
AND VERIFIED ANSWERS
Your answers
1 of 51
Definition
RAM
CPU
hard disk
network
application mode
how to grant something
to a specific user intersect
5 things that
DBMS performance tuning causes
bottleneck
Don't know?
, 2 of 51
Definition
add new rows
SELECT intersect
COMMIT INSERT
Don't know?
3 of 51
Term
DROP
returns ALL rows with matching
combines 2 similar tables,
values
returns distinct rows
deletes duplicate columns
removes entire table
from database removes row/s; faster than delete
permanently;
requires ALTER
permission
, Don't know?
4 of 51
Term
WHERE
delete some/all records
from database OC
can be rolled back sorts columns
limits rows returned
returns unique rows of only
FIRST query
used before group by
Don't know?
5 of 51
Definition
returns rows with matching values, includes all rows from T1,
T2 with unmatched values
AND VERIFIED ANSWERS
Your answers
1 of 51
Definition
RAM
CPU
hard disk
network
application mode
how to grant something
to a specific user intersect
5 things that
DBMS performance tuning causes
bottleneck
Don't know?
, 2 of 51
Definition
add new rows
SELECT intersect
COMMIT INSERT
Don't know?
3 of 51
Term
DROP
returns ALL rows with matching
combines 2 similar tables,
values
returns distinct rows
deletes duplicate columns
removes entire table
from database removes row/s; faster than delete
permanently;
requires ALTER
permission
, Don't know?
4 of 51
Term
WHERE
delete some/all records
from database OC
can be rolled back sorts columns
limits rows returned
returns unique rows of only
FIRST query
used before group by
Don't know?
5 of 51
Definition
returns rows with matching values, includes all rows from T1,
T2 with unmatched values
