WGU D427 DATABASE MANAGEMENT APPLICATIONS EXAM
PRE-ASSESSMENT AND OBJECTIVE ASSESSMENT LATEST 2025
WITH ACTUAL QUESTIONS AND CORRECT VERIFIED ANSWERS
ALREADY GRADED A+ 100% GUARANTEED PASS!
"A(n) _____ is a query that is embedded (or nested) inside another query.
- alias
- operator
- subquery
- view - CORRECT ANSWER=> subquery"
"All changes to a table structure are made using the _____ command, followed by a keyword that
produces the specific changes a user wants to make.
- ALTER TABLE
- UPDATE TABLE
- COMMIT TABLE
- DELETE TABLE - CORRECT ANSWER=> ALTER TABLE"
"The SQL aggregate function that gives the number of rows containing non-null values for a given
column is _____.
a. COUNT
b. MIN
c. MAX
d. SUM - CORRECT ANSWER=> COUNT"
"The _____ condition of a JOIN is generally composed of an equality comparison between the foreign
key and the primary key of related tables. - CORRECT ANSWER=> ON"
"Which kind of relationship is displayed in the entity-relationship diagram below?
- Binary one-to-one
- Unary many-to-many
- Ternary one-to-one
- Binary one-to-many
- Unary one-to-one - CORRECT ANSWER=> Binary one-to-many"
"Which kind of relationship is displayed in the entity-relationship diagram below?
- Binary one-to-one
,- Unary many-to-many
- Ternary one-to-one
- Binary one-to-many
- Unary one-to-one - CORRECT ANSWER=> Binary many-to-many"
"Which kind of relationship is displayed in the entity-relationship diagram below?
- Binary one-to-one
- Unary many-to-many
- Ternary one-to-one
- Binary one-to-many
- Unary one-to-one - CORRECT ANSWER=> Binary one-to-one"
"Which data type can be designated to allow for storage of dates
a. VARCHAR
b. INTEGER
c. DECIMAL
d. TIMESTAMP/DATE - CORRECT ANSWER=> TIMESTAMP/DATE"
"PATIENT TABLE
patient_id
first_name
last_name
birthdate
EXAM TABLE
exam_id
exam_date
exam_reason
patient_id
Which query would produce a result set that listed all of the patients, regardless of whether they had an
appointment in the Exam table or not.
- SELECT patient_id, first_name, last_name, birthdate, exam_date
FROM Patient
RIGHT JOIN EXAM ON Patient.patient_id = Exam.patient_id;
- SELECT patient_id, first_name, last_name, birthdate, exam_date
FROM Patient
INNER JOIN EXAM ON Patient.patient_id = Exam.patient_id;
- SELECT patient_id, first_name, last_name, birthdate, exam_date
FROM Patient
, INNER JOIN EXAM ON Patient.patient_id = Exam.exam_id;
- SELECT patient_id, first_name, last_name, birthdate, exam_date
FROM Patient
LEFT JOIN EXAM ON Patient.patient_id = Exam.patient_id; - CORRECT ANSWER=> SELECT patient_id,
first_name, last_name, birthdate, exam_date
FROM Patient
LEFT JOIN EXAM ON Patient.patient_id = Exam.patient_id;"
"Which restriction applies when using a materialized view?
- The users of the view must provide search terms.
- The underlying data must be periodically refreshed.
- The tables referenced in the view must be indexed.
- The rows in the table must be compressed. - CORRECT ANSWER=> The underlying data must be
periodically refreshed."
"Which query illustrates performing an outer join of the Movie table with a different table?
- SELECT M.Title, A.Actor FROM Movie M, Actor A
WHERE M.ActorID = A.ID
- SELECT M.Title, A.Actor FROM Movie M
LEFT JOIN Movie MB ON M.ID, Actor A
- SELECT M.Title, A.Actor FROM Movie M
RIGHT JOIN Actor A ON M.ActorID = A.Id
- SELECT M.Title, A.Actor FROM Movie M
INNER JOIN Actor A ON M.ActorID = A.ID - CORRECT ANSWER=> SELECT M.Title, A.Actor FROM Movie
M
LEFT JOIN Movie MB ON M.ID Actor A"
"Assume there are two tables, A and B.
Which rows will always be included in the result set if Table A is inner joined with Table B?
- Only rows in Tables A and B that share the join condition
- all rows in Table B
- All rows in Table A
- Only rows in Tables A and B that do not share the join condition - CORRECT ANSWER=> Only rows in
Table A and B that share the join condition"
"Portland, OR 97212
How many attributes are present in the address fragment?
PRE-ASSESSMENT AND OBJECTIVE ASSESSMENT LATEST 2025
WITH ACTUAL QUESTIONS AND CORRECT VERIFIED ANSWERS
ALREADY GRADED A+ 100% GUARANTEED PASS!
"A(n) _____ is a query that is embedded (or nested) inside another query.
- alias
- operator
- subquery
- view - CORRECT ANSWER=> subquery"
"All changes to a table structure are made using the _____ command, followed by a keyword that
produces the specific changes a user wants to make.
- ALTER TABLE
- UPDATE TABLE
- COMMIT TABLE
- DELETE TABLE - CORRECT ANSWER=> ALTER TABLE"
"The SQL aggregate function that gives the number of rows containing non-null values for a given
column is _____.
a. COUNT
b. MIN
c. MAX
d. SUM - CORRECT ANSWER=> COUNT"
"The _____ condition of a JOIN is generally composed of an equality comparison between the foreign
key and the primary key of related tables. - CORRECT ANSWER=> ON"
"Which kind of relationship is displayed in the entity-relationship diagram below?
- Binary one-to-one
- Unary many-to-many
- Ternary one-to-one
- Binary one-to-many
- Unary one-to-one - CORRECT ANSWER=> Binary one-to-many"
"Which kind of relationship is displayed in the entity-relationship diagram below?
- Binary one-to-one
,- Unary many-to-many
- Ternary one-to-one
- Binary one-to-many
- Unary one-to-one - CORRECT ANSWER=> Binary many-to-many"
"Which kind of relationship is displayed in the entity-relationship diagram below?
- Binary one-to-one
- Unary many-to-many
- Ternary one-to-one
- Binary one-to-many
- Unary one-to-one - CORRECT ANSWER=> Binary one-to-one"
"Which data type can be designated to allow for storage of dates
a. VARCHAR
b. INTEGER
c. DECIMAL
d. TIMESTAMP/DATE - CORRECT ANSWER=> TIMESTAMP/DATE"
"PATIENT TABLE
patient_id
first_name
last_name
birthdate
EXAM TABLE
exam_id
exam_date
exam_reason
patient_id
Which query would produce a result set that listed all of the patients, regardless of whether they had an
appointment in the Exam table or not.
- SELECT patient_id, first_name, last_name, birthdate, exam_date
FROM Patient
RIGHT JOIN EXAM ON Patient.patient_id = Exam.patient_id;
- SELECT patient_id, first_name, last_name, birthdate, exam_date
FROM Patient
INNER JOIN EXAM ON Patient.patient_id = Exam.patient_id;
- SELECT patient_id, first_name, last_name, birthdate, exam_date
FROM Patient
, INNER JOIN EXAM ON Patient.patient_id = Exam.exam_id;
- SELECT patient_id, first_name, last_name, birthdate, exam_date
FROM Patient
LEFT JOIN EXAM ON Patient.patient_id = Exam.patient_id; - CORRECT ANSWER=> SELECT patient_id,
first_name, last_name, birthdate, exam_date
FROM Patient
LEFT JOIN EXAM ON Patient.patient_id = Exam.patient_id;"
"Which restriction applies when using a materialized view?
- The users of the view must provide search terms.
- The underlying data must be periodically refreshed.
- The tables referenced in the view must be indexed.
- The rows in the table must be compressed. - CORRECT ANSWER=> The underlying data must be
periodically refreshed."
"Which query illustrates performing an outer join of the Movie table with a different table?
- SELECT M.Title, A.Actor FROM Movie M, Actor A
WHERE M.ActorID = A.ID
- SELECT M.Title, A.Actor FROM Movie M
LEFT JOIN Movie MB ON M.ID, Actor A
- SELECT M.Title, A.Actor FROM Movie M
RIGHT JOIN Actor A ON M.ActorID = A.Id
- SELECT M.Title, A.Actor FROM Movie M
INNER JOIN Actor A ON M.ActorID = A.ID - CORRECT ANSWER=> SELECT M.Title, A.Actor FROM Movie
M
LEFT JOIN Movie MB ON M.ID Actor A"
"Assume there are two tables, A and B.
Which rows will always be included in the result set if Table A is inner joined with Table B?
- Only rows in Tables A and B that share the join condition
- all rows in Table B
- All rows in Table A
- Only rows in Tables A and B that do not share the join condition - CORRECT ANSWER=> Only rows in
Table A and B that share the join condition"
"Portland, OR 97212
How many attributes are present in the address fragment?
