Latest Update Data - (Latest Update) Data Management – Applications |

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

Question:

• Portland, OR 97212

How many attributes are present in the address fragment?

• 1
• – 2
• – 3
• - 4

Answer:

3

• / 4

Question:

2. The Patient table has the following columns:

first_name varchar(20) last_name varchar (30) birthdate date patient_id int

Which column should be designated as the primary key for the Patient table?

• first_name
• - last_name
• - birthdate
• - patient_id

Answer:

patient_id

Question:

3. The Exam table has the following columns:

exam_id int exam_date date exam_reason varchar(100) patient_number int 2 / 4

Which column should be designated as the foreign key for the Exam table?

• exam_id
• - exam_date
• - exam_reason
• - patient_id

Answer:

patient_id

Question:

4. Which data type represents numbers with fractional values:

a) Varchar

• – integer
• – binary
• - decimal

Answer:

decimal

• / 4

Question:

• Which of the following is a DDL (Data Definition Language) command?

a) INSERT

• – SELECT
• - CREATE INDEX
• - UPDATE

Answer:

CREATE INDEX

CREATE, ALTER, DROP

Question:

• Which of the following is a DML (Data Manipulation Language)

command?

a) CREATE VIEW

• - CREATE TABLE
• – INSERT
• - ALTER INDEX

Answer:

INSERT

• / 4