WGU - D427|Data Management-Applications|Pre-Assessment:66 Updated Questions and Answers|100% Correct|New Version.

WGU - D427|Data Management-Applications|Pre-Assessment:66
Updated Questions and Answers|100% Correct|New Version.


Correct 66
100%
Incorrect 00


Next steps




Your answers



1 of 66

Definition



SELECT grade, COUNT(*)
FROM student_grades
GROUP BY grade;



Give this one a try later!

, 43. Write a SQL statement to retrieve all of the Customers from Seattle from the
table below.




53. Using the student_grades table listed above, write a query to count how
many students have each grade (A, B, and C).


MODELS TABLE
model_id




26. The Book table has the following columns:

ID—integer, primary key, auto_increment
Title—variable-length string Genre—
variable-length string Year—integer


Write a SQL query to display all Title values in alphabetical order A-Z.




47. Write a query that will return all of the cities from the Customer table above. Do
not include duplicates -list each city only once.


Don't know?




2 of 66

Term


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




Give this one a try later!




SELECT Title, TotalSales
SELECT Title, Genre
FROM Book
FROM Book
LEFT JOIN YearStats ON Book.Year =
WHERE Year = 2020;
YearStats.Year;




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


Don't know?




3 of 66

, Term



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



Give this one a try later!




SELECT COUNT (*)
FROM Book DATETIME
WHERE Year = 2019;




UPDATE Song
SET Year = 2022 patient_id
WHERE Year = 2020;


Don't know?