100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
Previously searched by you
Previously searched by you
logo
WGU D427 PRACTICE TEST QUESTIONS WITH ANSWER KEY 2024. £8.21   Add to cart
Quickly navigate to
Preview
  2.  
  3. WGU D427
  4.  
  5. WGU D427

Exam (elaborations)

WGU D427 PRACTICE TEST QUESTIONS WITH ANSWER KEY 2024.
 14 views  0 purchase
  • Module
  • WGU D427
  • Institution
  • WGU D427

WGU D427 PRACTICE TEST QUESTIONS WITH ANSWER KEY 2024. 1.47 Write the SQL to create a Product table with the following columns: ID - Integer Name - Variable-length string with maximum 40 characters ProductType - Variable-length string with maximum 3 characters OriginDate - Year, month, ...

[Show more]

Preview 3 out of 26  pages

Document information

  • May 1, 2024
  • 26
  • 2023/2024
  • Exam (elaborations)
  • Questions & answers

Subjects

  • wgu d427 practice test questions with answer key

Written for

  • WGU D427
All documents for this subject (108)

Seller

avatar-seller
NurseAdvocate

Reviews received

Content preview

WGU D427 PRACTICE TEST QUESTIONS WITH
ANSWER KEY 2024.



1.47 Write the SQL to create a Product table with the following columns:
ID - Integer
Name - Variable-length string with maximum 40 characters
ProductType - Variable-length string with maximum 3 characters
OriginDate - Year, month, and day
Weight - Decimal number with six significant digits and one digit after the -
decimal point
Place your CREATE TABLE statement before the INSERT and SELECT
statements. Run your solution and verify the result table contains the three
inserted rows.
CREATE TABLE Product (
ID INT,
Name VARCHAR(40),
ProductType VARCHAR(3),
OriginDate DATE,
Weight DECIMAL(6,1)
);
1.54 Write the SQL to create a Product table with the following columns:
ID - Integer with range 0 to 65,535
Name - Variable-length string with maximum 40 characters
ProductType - Fixed-length string with 3 characters
OriginDateTime - Year, month, day, and time
Weight - Decimal number with variable precision and 4 bytes of storage
Place your CREATE TABLE statement before the INSERT and SELECT

,statements. Run your solution and verify the result table contains the three
inserted rows.
CREATE TABLE Product (
ID SMALLINT UNSIGNED,
Name VARCHAR(40),
ProductType CHAR(3),
OriginDateTime DATETIME,
Weight FLOAT
);
1.6.9
The given SQL creates a Movie table and inserts some movies. The SELECT
statement selects all movies released before January 1, 2000.
Modify the SELECT statement to select the title and release date of PG-13 movies
that are released after January 1, 2008.
Run your solution and verify the result table shows just the titles and release
dates for The Dark Knight and Crazy Rich Asians.
SELECT Title, ReleaseDate
FROM Movie
WHERE Rating = 'PG-13' AND ReleaseDate > '2008-01-01';
1.79
Modify the SELECT statement to only select songs that have a NULL Title value.
Then run your solution, and verify the new query returns only songs by Taylor
Swift and Nirvana.
SELECT *
FROM Song
WHERE Title IS NULL;
1.7.11
Modify the SELECT statement to select only songs that have a NULL Title or
NULL Artist.

, SELECT * FROM Song WHERE Title IS NULL OR Artist IS NULL;
or
SELECT * FROM Song WHERE Title = NULL OR Artist = NULL;
1.8.6
Write three UPDATE statements to make the following changes:
Change the title from 'One' to 'With Or Without You'.
Change the artist from 'The Righteous Brothers' to 'Aretha Franklin'.
Change the release years of all songs after 1990 to 2021.
UPDATE Song
SET Title = 'With Or Without You'
WHERE ID = 200;


UPDATE Song
SET Artist = 'Aretha Franklin'
WHERE ID = 300;


UPDATE Song
SET ReleaseYear = 2021
WHERE ReleaseYear > 1990;
197
The given SQL creates a Movie table with an auto-incrementing ID column.
Write a single INSERT statement immediately after the CREATE TABLE statement
that inserts the following movies:
Raiders of the Lost Ark PG June 15, 1981
The Godfather R March 24, 1972
The Pursuit of Happyness PG-13 December 15, 2006
INSERT INTO Movie (Title, Rating, ReleaseDate)
VALUES ('Raiders of the Lost Ark', 'PG', '1981-06-15'),
('The Godfather', 'R', '1972-03-24'),
('The Pursuit of Happyness', 'PG-13', '2006-12-15');

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

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

Quick and easy check-out

You can quickly pay through credit card for the summaries. There is no membership needed.

Focus on what matters

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 NurseAdvocate. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for £8.21. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

67474 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy revision notes and other study material for 14 years now

Start selling
£8.21
  • (0)
  Add to cart