D427 D 427 Final Exam Latest

D427 / D 427 Final Exam (Latest Update 2025 / 2026) Data Management – Applications | Questions and Answers | Grade A | 100% Correct (Verified Answers) - WGU

Question:

ORDER BY

Answer:

SELECT column_name(s) FROM table_name ORDER BY column_name [ASC|DESC]

Question:

SELECT DISTINCT

Answer:

SELECT DISTINCT column_name(s) FROM table_name 1 / 3

Question:

SUM add up all costs in the book table

Answer:

SELECT SUM (Cost) FROM Book;

Question:

UPDATE

Modify existing data in a table

Answer:

UPDATE table_name SET column1=value, column2=value,...WHERE some_column=some_value

UPDATE Book SET Cost = Cost + 10 WHERE Cost > 100;

• / 3

Question:

positive decimal value representing a balance of up to $24,999, with 2 digits

Answer:

AccountBalance DECIMAL(7,2) UNSIGNED (positive value) CHECK (AccountBalance < = 24999.99)

Question:

Relationship maximum

Answer:

Relationship maximum is the greatest number of instances of one entity that can relate to a single instance of another entity.

Question:

Relationship minimum

Answer:

the least number of instances of one entity that can relate to a single instance of another entity

• / 3