UTpaper

Free mock tests & test series

Question 45

The command used to see the fields of the table alongwith their datatypes in SQL is

  1. ASelect fields from dual where table = "MANAGER";
  2. BSelect field_names, datatype from dual where table_ name = "MANAGER";
  3. CDesc MANAGER;
  4. DSelect description from dual where table_ name = "MANAGER";
Show answerHide answer

Correct answer: (C) Desc MANAGER;

Explanation

DESC (DESCRIBE) table_name shows the table's columns with their data types and constraints.

From DSSSB TGT Computer Science Practice Set 4

This is question 45 of DSSSB TGT Computer Science Practice Set 4. See all questions of this paper with answers, or attempt the paper as a timed online test to get your score and all-India rank.