WGU C170 SQL Data Management Exam
Questions Terms with Accurate Answers
2024/2025
cross join - correct answer cartesian product of T1 and T2
USING - correct answer returns only rows with matching values in column indicated
ON - correct answer returns rows that meet specified join condition
subquery can return: - correct answer single value (1 column, 1 row)
list of values (1 column, multiple rows)
virtual table (multicolumn, multirow)
union - correct answer combines 2 similar tables, returns distinct rows
union all - correct answer combines 2 tables, returns ALL rows
intersect - correct answer returns rows that both query returns
minus - correct answer returns unique rows of only FIRST query
video and audio files - correct answer blob
mediumblob
longblob
, binary files
SQL performance tuning - correct answer CLIENT side
fastest way to get SQL query to return correct answer
DBMS performance tuning - correct answer SERVER side
fastest way to responding clients requests
table scan - correct answer reads table sequentially
slowest
table access - correct answer row ID
fastest
5 things that causes bottleneck - correct answer RAM
CPU
hard disk
network
application mode
hash index - correct answer index based on ordered list of hash values
fast and simple
LNAME="Scott" and FNAME="Shannon"
Questions Terms with Accurate Answers
2024/2025
cross join - correct answer cartesian product of T1 and T2
USING - correct answer returns only rows with matching values in column indicated
ON - correct answer returns rows that meet specified join condition
subquery can return: - correct answer single value (1 column, 1 row)
list of values (1 column, multiple rows)
virtual table (multicolumn, multirow)
union - correct answer combines 2 similar tables, returns distinct rows
union all - correct answer combines 2 tables, returns ALL rows
intersect - correct answer returns rows that both query returns
minus - correct answer returns unique rows of only FIRST query
video and audio files - correct answer blob
mediumblob
longblob
, binary files
SQL performance tuning - correct answer CLIENT side
fastest way to get SQL query to return correct answer
DBMS performance tuning - correct answer SERVER side
fastest way to responding clients requests
table scan - correct answer reads table sequentially
slowest
table access - correct answer row ID
fastest
5 things that causes bottleneck - correct answer RAM
CPU
hard disk
network
application mode
hash index - correct answer index based on ordered list of hash values
fast and simple
LNAME="Scott" and FNAME="Shannon"
