Which of the following statements will provide a list of all of the databases with a name that starts with ‘world’?

Which of the following statements will provide a list of all of the databases with a name that starts with ‘world’?

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%’



Leave a Reply 0

Your email address will not be published. Required fields are marked *