WGU - D427 - Data Management - Applications - PreAssessment

WGU - D427 - Data Management - Applications - PreAssessment 28 studiers today 4.3 (11 reviews) Students also studied Terms in this set (66) Western Governors UniversityD 333 Save C839v5/D334 Additional Practice Teacher 165 terms ShawnD_Preview WGU - D427 Data Management - Ap...27 terms helen_robertson4 Preview D427 Data Management Application...25 terms lashawnleary6ctr Preview D427 25 terms rble San Francisco, CA 94110 USA How many attributes are present in the address fragment?

• 1
• 2
• 3
• 4

4

The Package table has the following columns:

Weight—decimal Description—optional variable length string LastChangedDate—date TrackingNumber—integer Which column should be designated the primary key for the Package table?

• Weight
• Description
• LastChangedDate
• TrackingNumber

Tracking Number

Which data type will store "2022-01-10 14:22:12" as a temporal value without loss of information?

- DATE

- DATETIME

- DECIMAL

- BIGINT

DATETIME

Which SQL command is an example of data definition language (DDL)?

- UPDATE

- ALTER

- SELECT

- DELETE

CREATE, ALTER, OR DROP

How would a database engine process an update that violates a RESTRICT referential integrity constraint?

• The offending value would be set to the database

default.

• The update would be rejected by the database.
• The offending value would be changed to NULL.
• The updated value would flow to the primary key.

The update would be rejected by the database.Which restriction applies when using a materialized view?

• The users of the view must provide search terms.
• The underlying data must be periodically refreshed.
• The tables referenced in the view must be indexed.
• The rows in the table must be compressed.

The underlying data must be periodically refreshed.Which query illustrates performing an outer join of the Movie table with a different table?

• SELECT M.Title, A.Actor FROM Movie M, Actor A

WHERE M.ActorID = A.ID

• SELECT M.Title, A.Actor FROM Movie M

LEFT JOIN Movie MB ON M.ID, Actor A

• SELECT M.Title, A.Actor FROM Movie M

RIGHT JOIN Actor A ON M.ActorID = A.Id

• SELECT M.Title, A.Actor FROM Movie M

INNER JOIN Actor A ON M.ActorID = A.ID SELECT M.Title, A.Actor FROM Movie M LEFT JOIN Movie MB ON M.ID Actor A

Assume there are two tables, A and B.Which rows will always be included in the result set if Table A is inner joined with Table B?

• Only rows in Tables A and B that share the join condition
• all rows in Table B
• All rows in Table A
• Only rows in Tables A and B that do not share the join

condition Only rows in Table A and B that share the join condition

• Portland, OR 97212

How many attributes are present in the address fragment?

• 1
• 2
• 3
• 4

3

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

patient_id

3. The Exam table has the following columns:

exam_id int exam_date date exam_reason varchar(100) patient_number int Which column should be designated as the foreign key for the Exam table?

• exam_id
• exam_date
• exam_reason
• patient_id

patient_id

• Which data type represents numbers with fractional

values:

• varchar
• integer
• binary
• decimal

decimal

• Which of the following is a DDL (Data Definition

Language) command?

- INSERT

- SELECT

- CREATE INDEX

- UPDATE

CREATE INDEX

CREATE, ALTER, DROP

• Which of the following is a DML (Data Manipulation

Language) command?

- CREATE VIEW

- CREATE TABLE

- INSERT

- ALTER INDEX

INSERT

• Patient Table

PK patient id first name last name birthdate Exam Table PK exam id exam date exam reason FK patient id CREATE TABLE Exam ( exam_id INT NOT NULL AUTO_INCREMENT, exam_date DATE NOT NULL, exam_reason VARCHAR(100), patient_id INT NOT NULL, PRIMARY KEY (exam_id), FOREIGN KEY (patient_id) REFERENCES Patient (patient_id) ON DELETE CASCADE ); What would happen to exams in the Exam table that are linked to a patient if that patient is deleted?

• Those exams would remain in the database
• Those exams would be deleted also
• The Patient ID for those exams would be changed to

NULL

• Nothing would happen

Those exams would be deleted also