WGU - D427 Data Management - Applications ZyBooks Labs 7 and 8 Verified Multiple Choice and Conceptual Actual Emended Exam Questions With Reviewed 100% Correct Detailed Answers Guaranteed Pass!!Current Update!!

WGU - D427 Data Management - Applications
ZyBooks Labs 7 and 8 Verified Multiple Choice and
Conceptual Actual Emended Exam Questions With
Reviewed 100% Correct Detailed Answers

Guaranteed Pass!!Current Update!!



1. Which SQL statement correctly inserts a new Horse named Babe with breed Quarter Horse,
height 15.3, and birthdate 2015-02-10?

A. INSERT Horse VALUES ('Babe', 'Quarter Horse', 15.3, '2015-02-10');

B. INSERT INTO Horse (RegisteredName, Breed, Height, BirthDate)

VALUES ('Babe', 'Quarter Horse', 15.3, '2015-02-10');

```

C. ```sql

INSERT Horse (RegisteredName, Breed, Height, BirthDate)

VALUES ('Babe', 'Quarter Horse', 15.3);

D. INSERT INTO Horse VALUES ('Babe', 'Quarter Horse', 15.3);



Q3. Which query selects RegisteredName, Height, and BirthDate for horses that are between
15.0 and 16.0 in height OR born after 2020-01-01?

A.

SELECT RegisteredName, Height, BirthDate

FROM Horse

WHERE Height BETWEEN 15.0 AND 16.0 AND BirthDate >= '2020-01-01';

B. SELECT RegisteredName, Height, BirthDate

FROM Horse

,WHERE (Height BETWEEN 15.0 AND 16.0)

OR (BirthDate >= '2020-01-01');

```

C. ```sql

SELECT RegisteredName, Height, BirthDate

FROM Horse

WHERE Height > 15.0 OR BirthDate >= '2020-01-01';

D. SELECT Name, Height, DOB

FROM Horse

WHERE Height BETWEEN 15.0 AND 16.0 OR BirthDate >= '2020-01-01';



4. Which statement correctly creates the Member table with an unsigned integer ID and a
positive annual pledge with cents precision?

A.

CREATE TABLE Member (

ID INT,

AnnualPledge FLOAT(8,2)

);

B.

CREATE TABLE Member (

ID INT UNSIGNED,

AnnualPledge DECIMAL(8,2) UNSIGNED

);

```

C.

```sql

,CREATE TABLE Member (

ID INT PRIMARY KEY,

AnnualPledge DECIMAL

);

D.

CREATE Member (

ID INTEGER AUTO_INCREMENT,

AnnualPledge DECIMAL(8,2)

);



5. LAB - Alter Movie table

The Movie table has the following columns:

ID - positive integer

Title - variable-length string

Genre - variable-length string

RatingCode - variable-length string

Year - integer

Write ALTER statements to make the following modifications to the Movie table:

1. Add a Producer column with VARCHAR data type (max 50 chars).

2. Remove the Genre column.

3. Change the Year column's name to ReleaseYear, and change the data type to SMALLINT.

- ANSWER ALTER TABLE Movie
ADD Producer VARCHAR(50);

ALTER TABLE Movie
DROP Genre;

, ALTER TABLE Movie
CHANGE Year ReleaseYear SMALLINT;

6. LAB - Insert rows into Horse table

The Horse table has the following columns:
ID - integer, auto increment, primary key
RegisteredName - variable-length string
Breed - variable-length string, must be one of the following: Egyptian Arab, Holsteiner, Quarter
Horse, Paint, Saddlebred
Height - decimal number, must be between 10.0 and 20.0
BirthDate - date, must be on or after Jan 1, 2015

Insert the following data into the Horse table:
RegisteredName Breed Height

- ANSWER INSERT INTO Horse (RegisteredName, Breed, Height, BirthDate)
VALUES ('Babe', 'Quarter Horse', 15.3, '2015-02-10');

INSERT INTO Horse (RegisteredName, Breed, Height, BirthDate)
VALUES ('Independence', 'Holsteiner', 16.0, '2017-03-13');

INSERT INTO Horse (RegisteredName, Breed, Height, BirthDate)
VALUES ('Ellie', 'Saddlebred', 15.0, '2016-12-22');

INSERT INTO Horse (Breed, Height, BirthDate)
VALUES ('Egyptian Arab', 14.9, '2019-10-12');

7. LAB - Update rows in Horse table

The Horse table has the following columns:
ID - integer, auto increment, primary key
RegisteredName - variable-length string
Breed - variable-length string, must be one of the following: Egyptian Arab, Holsteiner, Quarter
Horse, Paint, Saddlebred
Height - decimal number, must be ≥ 10.0 and ≤ 20.0
BirthDate - date, must be ≥ Jan 1, 2015

Make the following updates: