WGU C170 WITH QUESTIONS AND ANSWERS WITH 100% VERIFIED SOLUTION GRADE A+ CORRECT ANSWERS

Refer to the given SQL statement.


1. SELECT SPNAME
2. FROM SALESPERSON
3. WHERE SPNUM=
4. FROM CUSTOMER
5. WHERE CUSTNUM=20900);


What is missing from the subquery at the beginning of line 4?


(SPNUM
(FIND SPNUM
(SELECT SPNUM
(SUBQUERY SPNUM


Give this one a try later!

, (SELECT SPNUM




Which SQL statement retrieves all of the columns from the Owners table?


SELECT * FROM Owners;
SELECT ALL FROM Owners;
RETRIEVE COMPLETE FROM Owners;
RETRIEVE ALL COLUMNS FROM Owners;


Give this one a try later!


SELECT * FROM Owners;




Refer to the given SQL statement.


SELECT EMPNUM
FROM EMPLOYEE


Which line added to the end of the statement returns employee numbers of at least
1000?


WHERE EMPNUM = 1000+;
WHERE EMPNUM > 1000;
WHERE EMPNUM => 1000;
WHERE EMPNUM >= 1000;


Give this one a try later!

, WHERE EMPNUM >= 1000;




Refer to the given SQL statement.


SELECT product_name, product_number, mfg_city FROM product;


Which statement, when added before this statement, generates a view?


VIEW viewprod:
ALTER viewprod AS
WHERE VIEW viewprod IS
CREATE VIEW viewprod AS


Give this one a try later!


CREATE VIEW viewprod AS




Refer to the diagram of an index table.


Salesperson Table
Record
Address Salesperson
Number Salesperson
Name City
Hire Date
Commission
Rate
1 119 Taylor, A New York 1/21/01 20%
2 137 Baker, B Detroit 2/3/11 10%
3 186 Adams, A Dallas 8/23/96 5%