Exam (elaborations)
WGU D427 - Chapter 7 and 8 questions with verified answers
- Course
- WGU D426
- Institution
- Western Governers University
WGU D427 - Chapter 7 and 8 questions with verified answers
[Show more]
Content preview
WGU D427 - Chapter 7 and 8 questions with verifiedanswers
7.1 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:
Add a Producer column with VARCHAR data type (max 50 chars).
Remove the Genre column.
Change the Year column's name to ReleaseYear, and change the data type to
SMALLINT. Ans✓✓✓-ALTER TABLE movie ADD COLUMN Producer VARCHAR(50);
ALTER TABLE movie DROP COLUMN Genre;
ALTER TABLE movie CHANGE COLUMN Year ReleaseYear SMALLINT;
7.2 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 BirthDate
Babe Quarter Horse 15.3 2015-02-10
Independence Holsteiner 16.0 2017-03-13
Ellie Saddlebred 15.0 2016-12-22
NULL Egyptian Arab 14.9 2019-10-12 Ans✓✓✓-INSERT INTO HORSE
(RegisteredName, Breed, Height, BirthDate)
VALUES
('Babe', 'Quarter Horse', 15.3,'2015-02-10'),
('Independence', 'Holsteiner', 16.0, '2017-03-13'),
('Ellie', 'Saddlebred', 15.0,'2016-12-22'),
(NULL, 'Egyptian Arab', 14.9,'2019-10-12')
7.3 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:
Change the height to 15.6 for horse with ID 2.
Change the registered name to Lady Luck and birth date to May 1, 2015 for horse
with ID 4.
, Change every horse breed to NULL for horses born on or after December 22,
2016. Ans✓✓✓-Update Horse
Set Height = 15.6
Where ID = 2;
Update Horse
Set RegisteredName = 'Lady Luck', BirthDate = '2015-05-01'
Where ID = 4;
Update Horse
Set Breed = Null
Where BirthDate >= '2016-12-22';
7.4 LAB - Delete rows from Horse table
The Horse table has the following columns:
ID - integer, auto increment, primary key
RegisteredName - variable-length string
Breed - variable-length string
Height - decimal number
BirthDate - date
Delete the following rows:
Horse with ID 5.
All horses with breed Holsteiner or Paint.
All horses born before March 13, 2013. Ans✓✓✓-DELETE FROM Horse WHERE ID
= 5;
DELETE FROM Horse WHERE Breed = 'Holsteiner' OR Breed = 'Paint';
DELETE FROM Horse WHERE BirthDate < '2013-03-13';
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller cracker. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $15.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
69484 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 15 years now
Recently viewed by you
Exam (elaborations) ·
ati fundamentals Study Guide Exam 2024 Q&A/ Already Graded A+
Exam (elaborations) ·
Autism Spectrum Disorder (ASD) Guide Questions and Answers
Exam (elaborations) ·
Praxis 5422 (School Counselor Exam) Latest Update 100% Pass
Exam (elaborations) ·
Galen NUR 210 Exam With Complete Solutions Latest Update
Summary ·
resumenes y apuntes de asignaturas basicas de ingenieria
Exam (elaborations) ·
ATI RN CONCEPT-BASED ASSESSMENT LEVEL 3 STUDY GUIDE 2023
Exam (elaborations) ·
Lecture Midterm Review (Mock Test) - Questions Only - ANAT 260
Exam (elaborations) ·
DVA 1502 EXAM PACK 2022, University of South Africa, UNISA
