Vidyalelo
MySQL · Q915

MySQL

Programming · MySQL · question 915

Q915

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

A.
SHOW STATUS OF TABLE
B.
SHOW STATUS TABLE
C.
SHOW TABLE STATUS
Answer
D.
SHOW DEFAULT STATUS

Answer: Option C

Solution

Answer: Option C
Solution:
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!