Which command in MySQL is used to list all (non-temporary) tables in a given database?

Correct option is D

The SHOW TABLES command in MySQL is used to list all the non-temporary tables in a given database. This command displays all the tables that exist in the current database (excluding temporary tables), which is useful when you want to view the structure of the database.
Important Key Points:
1. SHOW TABLES: This command returns a list of all tables in the currently selected database, excluding temporary ones.
2. Use in Database Selection: Before running this command, you need to select the database you want to work with using the USE command.
3. Listing Tables: It provides a simple way to check the existing tables in a database without requiring additional configuration or parameters.
4. Different from Other Commands: Other commands like DESCRIBE or SHOW are used for getting detailed information about the structure of individual tables, not for listing all tables.
Knowledge Booster:
· Option (a): DESCRIBE TABLES is incorrect because DESCRIBE is used to show the structure of a single table (e.g., columns and their data types), not to list all tables.
· Option (b): There is no DISPLAY TABLES command in MySQL. SHOW TABLES is the correct command for listing all tables.
· Option (c): VIEW TABLES is not a valid MySQL command. The correct command to list all tables is SHOW TABLES.