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