Which of the following queries will allow hidden columns to be displayed?
A) DESC on a table.
B) SELECT which specifically references the hidden column.
C) SELECT *.
D) None of the above.

Question

Which of the following queries will allow hidden columns to be displayed?​
A) DESC on a table.​
B) ​SELECT which specifically references the hidden column.
C) ​SELECT *.
D) ​None of the above.

Quizplus · Accepted Answer

SELECT which specifically references the hidden column will allow it to be displayed. DESC on a table will only show the table's structure while SELECT * will display all columns except for hidden ones.

Which of the Following Queries Will Allow Hidden Columns to Be