WGU C170 Database Management Test Exam
Review Questions with all Answers verified for
accuracy Updated 2024/2025
The ................ operator could be used in place of INTERSECT if the DBMS does not
support it. - correct answer IN
The ................__ operator could be used in place of MINUS if the DBMS does not
support it. - correct answer NOT IN
The ................................___ statement combines the output of two SELECT queries
and returns all results common to both queries. - correct answer INTERSECT
A(n) ................................................_ query can be used to produce a relation that
retains the duplicate rows. - correct answer UNION ALL
The ................................................ statement can be used to combine rows from two
queries, returning only the rows that appear in both sets. - correct answer INTERSECT
The syntax of the MINUS statement in Oracle is ................................___. - correct
answer query MINUS query
If the DBMS does not support the INTERSECT statement, one can use
a(n) ................__ subquery to achieve the same result. - correct answer IN
UNION, INTERSECT, and MINUS work properly only if relations are intersect-
compatible, which means that the names of the relation attributes and their data types
must be different. - correct answer False
A(n) ................................................__ view is a view that can be used to update
attributes in the base tables that are used in the view. - correct answer updatable
, A(n) ................................................___ routine pools multiple transactions into a single
batch to update a master table field in a single operation. - correct answer batch
update
In which two ways can data redundancy affect managing disk space and calculation
speed? - correct answer Additional proccessing time is needed to udate redundant
data
Redundant data takes up disk space
With which command can a database admin allow a user named Mary to query the
Patient table by executing SELECT commands on it - correct answer GRANT SELECT
ON PATIENT TO 'Mary' @ 'localhost'
What does the WHERE identify in basic SQL SELECT statement - correct answer The
rows to be included in the result set
Which condition must be in effect to use the INSERT INTO ... VALUES syntax for an
INSERT statement - correct answer The VALUES list must contain a value for each
attribute/column in the table
Which method creates an empty copy of a table and then populates it from the original
table? - correct answer CREATE TABLE newTableName LIKE tableName INSERT
INTO newTableName SELECT * FROM tableName;
ALTER TABLE tableName action [, action] ...;
What does this syntax allow? - correct answer Changing column types
Dropping indexes
What is the proper command to change a view? - correct answer ALTER VIEW
Review Questions with all Answers verified for
accuracy Updated 2024/2025
The ................ operator could be used in place of INTERSECT if the DBMS does not
support it. - correct answer IN
The ................__ operator could be used in place of MINUS if the DBMS does not
support it. - correct answer NOT IN
The ................................___ statement combines the output of two SELECT queries
and returns all results common to both queries. - correct answer INTERSECT
A(n) ................................................_ query can be used to produce a relation that
retains the duplicate rows. - correct answer UNION ALL
The ................................................ statement can be used to combine rows from two
queries, returning only the rows that appear in both sets. - correct answer INTERSECT
The syntax of the MINUS statement in Oracle is ................................___. - correct
answer query MINUS query
If the DBMS does not support the INTERSECT statement, one can use
a(n) ................__ subquery to achieve the same result. - correct answer IN
UNION, INTERSECT, and MINUS work properly only if relations are intersect-
compatible, which means that the names of the relation attributes and their data types
must be different. - correct answer False
A(n) ................................................__ view is a view that can be used to update
attributes in the base tables that are used in the view. - correct answer updatable
, A(n) ................................................___ routine pools multiple transactions into a single
batch to update a master table field in a single operation. - correct answer batch
update
In which two ways can data redundancy affect managing disk space and calculation
speed? - correct answer Additional proccessing time is needed to udate redundant
data
Redundant data takes up disk space
With which command can a database admin allow a user named Mary to query the
Patient table by executing SELECT commands on it - correct answer GRANT SELECT
ON PATIENT TO 'Mary' @ 'localhost'
What does the WHERE identify in basic SQL SELECT statement - correct answer The
rows to be included in the result set
Which condition must be in effect to use the INSERT INTO ... VALUES syntax for an
INSERT statement - correct answer The VALUES list must contain a value for each
attribute/column in the table
Which method creates an empty copy of a table and then populates it from the original
table? - correct answer CREATE TABLE newTableName LIKE tableName INSERT
INTO newTableName SELECT * FROM tableName;
ALTER TABLE tableName action [, action] ...;
What does this syntax allow? - correct answer Changing column types
Dropping indexes
What is the proper command to change a view? - correct answer ALTER VIEW
