Solved

Which MySQL Command Displays All Tables Associated with the Database

Question 18

Multiple Choice

Which MySQL command displays all tables associated with the database ELPATRON?


A) SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE (TABLE_SCHEMA = 'ELPATRON') ;
B) SELECT * FROM INFORMATION_SCHEMA.VIEWS WHERE (TABLE_SCHEMA = 'ELPATRON') ;
C) SELECT * FROM USER_OBJECTS 'ELPATRON';
D) SHOW TABLES WHERE TABLE_SCHEMA = ELPATRON;

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions