Quiz 11
Quiz yourself on the stored procedures and testing in MySQL.
We'll cover the following...
We'll cover the following...
Question # 1
1.
Which query/ queries will print the views in the MovieIndustry database?
A.
SHOW TABLES IN MovieIndustry
WHERE table_type='VIEW';
B.
SHOW FULL TABLES IN MovieIndustry
WHERE table_type='VIEW';
C.
SELECT * FROM information_schema.tables
WHERE table_type='VIEW';
D.
SELECT VIEWS FROM information_schema.tables;
1 / 1