Which two statements provide the definition for a view named view1 in the test database?
A.
SHOW CREATE VIEW view1 FROM test
B.
SHOW CREATE VIEW test-view1
C.
SELECT VIEW_DEFINITION_SCHEMA.VIEWS
FROM INFORMATION _SCHEMA.VIEWS
WHERE TABLE_NAME=”view1”
AND TABLE_SCHEMA = “test”
D.
SELECT DEFINITION
FROM INFORMATION_SCHEMA.VIEWS
WHERE NAME = “test”
E.
SHOW DEFINITION FOR test.view
Correct syntax:
B. SHOW CREATE VIEW test.view1;
C. SELECT VIEW_DEFINITION FROM INFORMATION_SCHEMA.views WHERE TABLE_NAME=”view1″
AND TABLE_SCHEMA=”test”;
B C
B,c
B C tested