Which of the following statements will provide a list of all of the databases with a name that starts
with ‘world’?
A.
SELECT SCHEMA_NAME AS `Database` FROM INFORMATION_SCHEMA.SCHEMATA
WHERE SCHEMA_NAME LIKE ‘world%’
B.
SELECT SCHEMA_NAME AS `Database` FROM SCHEMATA_INFORMATION.SCHEMATA
WHERE SCHEMA_NAME LIKE ‘world%’
C.
SELECT NAME AS `Database` FROM INFORMATION_SCHEMA.DATABASE WHERE NAME
LIKE ‘world%’
D.
SELECT NAME AS `Database` FROM SCHEMATA_INFORMATION.DATABASE WHERE
NAME LIKE ‘world%’