D427 DATA MANAGEMENT APPLICATIONS PRACTICE TEST 2 LATEST UPDATED QUESTIONS AND ANSWERS WITH ANSWER KEY WESTERN GOVERNORS’ UNIVERSITY

D427 Practice Test 2
1. Portland, OR 97212
How many attributes are present in the address fragment?
a. 1
b. 2
c. 3
d. 4
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 at the primary key for the Patient table?
a. first name
b. last_name
c. birthdate
d. patient_id
3. The Exam table has the following columns:
exam_id – int
exam_date – date
exam_reason – varchar (100)
patient_id – int
Which column should be designated as the foreign key for the Exam table?
a. exam_id
b. exam_date
c. exam_reason
d. patient_id
4. Which data type represents numbers with fractional values:
lOMoAR cPSD|42147428
a. Varchar
b. Integer
c. Binary
d. Decimal
5. Which of the following is a DDL (Data Defination Language) command?
a. INSERT
b. SELECT
c. CREATE INDEX
d. UPDATE
6. Which of the following is a DML(Data Manipulation Language) command?
a. CREATE VIEW
b. CREATE TABLE
c. INSERT
d. ALTER INDEX