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;

---

Definitions:

Arrow Pointing

A graphical indicator often used in interfaces and documents to direct attention towards a particular element or direction.

Join Line

The action of connecting two separate lines of text into one continuous line, often used in text editing and programming.

Join Type

A term used in database management that specifies how tables should be combined or linked based on common columns.

One-To-Many Relationship

A type of database relationship where a single record in one table can be associated with one or more records in another table.