?
To see the table structure which command is issued?
Answer & Solution
Correct Answer:
Option
D
This question asks you about how to see the structure of a table in MySQL. The structure refers to the columns, their data types, and other details about how the table is organized.
Here are the options:
Option A: VIEW tbl_name;
This is incorrect. VIEW is used to create a virtual table based on an existing table, not for viewing the structure.
Option B: SELECT TABLE tbl_name;
This is also incorrect. SELECT is used for retrieving data from a table, not for viewing its structure.
Option C: SELECT tbl_name;
This is incorrect. SELECT is used for retrieving data from a table, not for viewing its structure.
Option D: DESCRIBE tbl_name;
This is the correct answer! DESCRIBE is the command used in MySQL to display the structure of a table. It shows you the column names, their data types, and other properties.
So the answer to this question is Option D: DESCRIBE tbl_name;
Here are the options:
Option A: VIEW tbl_name;
This is incorrect. VIEW is used to create a virtual table based on an existing table, not for viewing the structure.
Option B: SELECT TABLE tbl_name;
This is also incorrect. SELECT is used for retrieving data from a table, not for viewing its structure.
Option C: SELECT tbl_name;
This is incorrect. SELECT is used for retrieving data from a table, not for viewing its structure.
Option D: DESCRIBE tbl_name;
This is the correct answer! DESCRIBE is the command used in MySQL to display the structure of a table. It shows you the column names, their data types, and other properties.
So the answer to this question is Option D: DESCRIBE tbl_name;
Join the Discussion
Login to post a comment or share your explanation.
Login