ExamVeda
Login
Home
This question belongs to MySQL MySQL Miscellaneous
MySQL Miscellaneous
?

Which statement is used to determine the storage engine for individual tables?

Answer & Solution
Correct Answer: Option C
This question is asking about how to find out which storage engine is used for a specific table in your MySQL database.

The correct answer is Option C: SHOW TABLE STATUS.

Here's why:

* SHOW TABLE STATUS is a MySQL command that provides information about tables in your database, including the storage engine used.

Let's break down the other options:

* Option A: SHOW STATUS OF TABLE and Option B: SHOW STATUS TABLE are not valid MySQL commands.
* Option D: SHOW DEFAULT STATUS is a valid command, but it doesn't tell you the storage engine for individual tables. It provides general information about the MySQL server's status.

Think of it like this: You have a bunch of boxes (tables) and you want to know what's inside each one (storage engine). SHOW TABLE STATUS is the key to unlocking those boxes and revealing the contents!
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.