SQL
August 28, 2024Database-Management-System
August 28, 2024Database-Management-System
| Question 714 |
The command used to see the fields of the table along with their datatypes in SQL is
| Select fields from dual where table=”MANAGER”; | |
| Select field_names, datatype from dual where table_name=”MANAGER”; | |
| Desc MANAGER; | |
| Select description from dual where table_name=”MANAGER” |
Question 714 Explanation:
●Describes either the columns in a table or the current values, as well as the default values, for the stage properties for a table.
● DESCRIBE can be abbreviated to DESC.
● DESCRIBE can be abbreviated to DESC.
Correct Answer: C
Question 714 Explanation:
●Describes either the columns in a table or the current values, as well as the default values, for the stage properties for a table.
● DESCRIBE can be abbreviated to DESC.
● DESCRIBE can be abbreviated to DESC.