WGU C170 PRACTICE EXAM TEST WITH
100% CORRECT AND VERIFIED ANSWERS
Correct 99
100%
Incorrect 00
Your answers
1 of 99
Term
Refer to the given MySQL syntax.
ALTER TABLE tbl_name action [, action ] ... ;
What does this syntax allow? Choose two answers:
Give this one a try later!
Dropping Indexes, Changing column data
Changing column data types, Adding rows
types
Dropping Indexes, Dropping Indexes, Changing
Changing storage space column data types
Don't know?
, 2 of 99
Term
You are creating a database which will have the 2 tables
shown above.
You need to ensure that if a category is removed from the
Category
table, all related product rows would have their CategoryID
set to a null value.
What should you use?
Give this one a try later!
ON DELETE SET TO NULL ON DELETE CASCADE
ON DELETE SET TO NULL ON DELETE RESTRICT
Don't know?
3 of 99
Term
The _____ clause of the GROUP BY statement operates very
much like the WHERE clause in the SELECT statement.
Give this one a try later!
HAVING SELECT
, ORDER BY HAVING
Don't know?
4 of 99
Term
With which command can a database administrato rallowa
usernamed Mary to query the Patient table by executing
SELECT commands on it?
Give this one a try later!
GRANT SELECT ON GRANT Patient TO 'mary'@
PATIENT
'localhost';
TO 'mary'@ 'localhost';
GRANT SELECT ON GRANT SELECT PATIENT TO
PATIENT TO 'mary'@
'mary'@ 'localhost'; 'localhost';
Don't know?
5 of 99
Term
Refer to the given SQL Statement.
1. SELECT invoice_id
2.FROM Invoice
3.WHERE customer_id =
4. FROM customer
, 5.WHERE customer_id = 55547);
What is missing from the subquery at the beginning of Line 4?
Give this one a try later!
(SELECT customer_id (SUBQUERY customer_id
(FIND customer_id (SELECT customer_id
Don't know?
6 of 99
Term
You are creating a relational database to store information
about instructors and the courses that each instructor
teaches. Each course is taught by a single instructor. You
have created an Instructor table and a Course table as
shown above. You need to create a
relationship between the Instructor table and the Course
table. You need to keep duplicate data to a minimum.
What should you do?
Give this one a try later!
Create new columns in the
Create a new table that
Instructors table for each
includes two columns.
course taught.
100% CORRECT AND VERIFIED ANSWERS
Correct 99
100%
Incorrect 00
Your answers
1 of 99
Term
Refer to the given MySQL syntax.
ALTER TABLE tbl_name action [, action ] ... ;
What does this syntax allow? Choose two answers:
Give this one a try later!
Dropping Indexes, Changing column data
Changing column data types, Adding rows
types
Dropping Indexes, Dropping Indexes, Changing
Changing storage space column data types
Don't know?
, 2 of 99
Term
You are creating a database which will have the 2 tables
shown above.
You need to ensure that if a category is removed from the
Category
table, all related product rows would have their CategoryID
set to a null value.
What should you use?
Give this one a try later!
ON DELETE SET TO NULL ON DELETE CASCADE
ON DELETE SET TO NULL ON DELETE RESTRICT
Don't know?
3 of 99
Term
The _____ clause of the GROUP BY statement operates very
much like the WHERE clause in the SELECT statement.
Give this one a try later!
HAVING SELECT
, ORDER BY HAVING
Don't know?
4 of 99
Term
With which command can a database administrato rallowa
usernamed Mary to query the Patient table by executing
SELECT commands on it?
Give this one a try later!
GRANT SELECT ON GRANT Patient TO 'mary'@
PATIENT
'localhost';
TO 'mary'@ 'localhost';
GRANT SELECT ON GRANT SELECT PATIENT TO
PATIENT TO 'mary'@
'mary'@ 'localhost'; 'localhost';
Don't know?
5 of 99
Term
Refer to the given SQL Statement.
1. SELECT invoice_id
2.FROM Invoice
3.WHERE customer_id =
4. FROM customer
, 5.WHERE customer_id = 55547);
What is missing from the subquery at the beginning of Line 4?
Give this one a try later!
(SELECT customer_id (SUBQUERY customer_id
(FIND customer_id (SELECT customer_id
Don't know?
6 of 99
Term
You are creating a relational database to store information
about instructors and the courses that each instructor
teaches. Each course is taught by a single instructor. You
have created an Instructor table and a Course table as
shown above. You need to create a
relationship between the Instructor table and the Course
table. You need to keep duplicate data to a minimum.
What should you do?
Give this one a try later!
Create new columns in the
Create a new table that
Instructors table for each
includes two columns.
course taught.
