WGU D427 DATA MANAGEMENT APPLICATIONS OA EXAM LATEST
WGU - Data Management - Applications D427
2025 ACTUAL QUESTIONS WITH DETAILED ANSWERS /A+ GRADE
Study online at https://quizlet.com/_gvaaqc
ASSURED
1. San Francisco, CA 94110 USA , 4 Attributes
How many attributes are present in the address frag-
ment?
2. The Package table has the following columns: TrackingNumber
Weight—decimal,
Description—optional variable length string,
LastChangedDate—date,
TrackingNumber—integer,
Which column should be designated the primary key
for the Package table?
3. Which data type will store "2022-01-10 14:22:12" as a DATETIME
temporal value without loss of information?
4. Which SQL command is an example of data definition CREATE, ALTER, DROP, RE-
language (DDL)? NAME, TRUNICATE
5. What does the SQL keyword command TRUNCATE do? TRUNCATE removes all
rows, unlike DELETE, which
removes specific rows.
6. How would a database engine process an update that RESTRICT CONSTRAINT will
violates a RESTRICT referential integrity constraint? reject the UPDATE if the in-
put does not coincide with
predetermined values and
generates an error.
7. Which restrictions applies when using a materialized Materialized views require
view? to be refreshed frequently
and require more storage
space.
, WGU - Data Management - Applications D427
Study online at https://quizlet.com/_gvaaqc
8. Define a SELECT statement? SELECT column1, col-
umn2, ... FROM
table_name;
9. Define a INSERT statement? INSERT INTO table_name
(column1, column2, ...)
VALUES (value1, value2,
...);
10. Define a UPDATE statement? UPDATE table_name
SET column1 = value1, col-
umn2 = value2, ...
WHERE condition;
11. Define a DELETE statement? DELETE FROM
table_name
WHERE condition;
12. The Book table has the following columns: isbn_number
genre - varchar(20),
pages - integer,
author_id - char(3),
isbn_number - varchar(20),
Which column should be designated at the primary key
for the Book table?
13. The Book table has the following columns: author_id
genre - varchar(20),
pages - integer,
author_id - char(3),
isbn_number - varchar(20),
Which column should be designated as the foreign key
for the Book table?
, WGU - Data Management - Applications D427
Study online at https://quizlet.com/_gvaaqc
14. Which data type represents numbers with fractional DECIMAL
values:
15. Which of the following is a DML command? INSERT, DELETE, UPDATE
16. CREATE TABLE Invoice ( Those invoices would be
invoice_id INT NOT NULL AUTO_INCREMENT, deleted also.
date DATE NOT NULL,
customer_id INT NOT NULL,
PRIMARY KEY (invoice_id),
FOREIGN KEY (customer_id) REFERENCES Customer
(customer_id) ON DELETE CASCADE
);
Looking at the Customer and Invoice tables and the
CREATE TABLE for the Invoice table with foreign key
reference statement above, what would happen to in-
voices in the Invoice table that are linked to a customer
if that customer is deleted.
17. CREATE TABLE Invoice ( The delete of the Customer
invoice_id INT NOT NULL AUTO_INCREMENT, would not be allowed.
date DATE NOT NULL,
customer_id INT NOT NULL,
PRIMARY KEY (invoice_id),
FOREIGN KEY (customer_id) REFERENCES Customer
(customer_id) ON DELETE RESTRICT
);
Looking at the Customer and Invoice tables and the
CREATE TABLE for the Invoice table with foreign key
reference statement above, what would happen to in-
WGU - Data Management - Applications D427
2025 ACTUAL QUESTIONS WITH DETAILED ANSWERS /A+ GRADE
Study online at https://quizlet.com/_gvaaqc
ASSURED
1. San Francisco, CA 94110 USA , 4 Attributes
How many attributes are present in the address frag-
ment?
2. The Package table has the following columns: TrackingNumber
Weight—decimal,
Description—optional variable length string,
LastChangedDate—date,
TrackingNumber—integer,
Which column should be designated the primary key
for the Package table?
3. Which data type will store "2022-01-10 14:22:12" as a DATETIME
temporal value without loss of information?
4. Which SQL command is an example of data definition CREATE, ALTER, DROP, RE-
language (DDL)? NAME, TRUNICATE
5. What does the SQL keyword command TRUNCATE do? TRUNCATE removes all
rows, unlike DELETE, which
removes specific rows.
6. How would a database engine process an update that RESTRICT CONSTRAINT will
violates a RESTRICT referential integrity constraint? reject the UPDATE if the in-
put does not coincide with
predetermined values and
generates an error.
7. Which restrictions applies when using a materialized Materialized views require
view? to be refreshed frequently
and require more storage
space.
, WGU - Data Management - Applications D427
Study online at https://quizlet.com/_gvaaqc
8. Define a SELECT statement? SELECT column1, col-
umn2, ... FROM
table_name;
9. Define a INSERT statement? INSERT INTO table_name
(column1, column2, ...)
VALUES (value1, value2,
...);
10. Define a UPDATE statement? UPDATE table_name
SET column1 = value1, col-
umn2 = value2, ...
WHERE condition;
11. Define a DELETE statement? DELETE FROM
table_name
WHERE condition;
12. The Book table has the following columns: isbn_number
genre - varchar(20),
pages - integer,
author_id - char(3),
isbn_number - varchar(20),
Which column should be designated at the primary key
for the Book table?
13. The Book table has the following columns: author_id
genre - varchar(20),
pages - integer,
author_id - char(3),
isbn_number - varchar(20),
Which column should be designated as the foreign key
for the Book table?
, WGU - Data Management - Applications D427
Study online at https://quizlet.com/_gvaaqc
14. Which data type represents numbers with fractional DECIMAL
values:
15. Which of the following is a DML command? INSERT, DELETE, UPDATE
16. CREATE TABLE Invoice ( Those invoices would be
invoice_id INT NOT NULL AUTO_INCREMENT, deleted also.
date DATE NOT NULL,
customer_id INT NOT NULL,
PRIMARY KEY (invoice_id),
FOREIGN KEY (customer_id) REFERENCES Customer
(customer_id) ON DELETE CASCADE
);
Looking at the Customer and Invoice tables and the
CREATE TABLE for the Invoice table with foreign key
reference statement above, what would happen to in-
voices in the Invoice table that are linked to a customer
if that customer is deleted.
17. CREATE TABLE Invoice ( The delete of the Customer
invoice_id INT NOT NULL AUTO_INCREMENT, would not be allowed.
date DATE NOT NULL,
customer_id INT NOT NULL,
PRIMARY KEY (invoice_id),
FOREIGN KEY (customer_id) REFERENCES Customer
(customer_id) ON DELETE RESTRICT
);
Looking at the Customer and Invoice tables and the
CREATE TABLE for the Invoice table with foreign key
reference statement above, what would happen to in-
