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.