To see the table structure, which of the following commands is issued? – McqOptions

MCQOPTIONS

1.	To see the table structure, which of the following commands is issued?
A.	VIEW tbl_name
B.	SELECT TABLE tbl_name
C.	SELECT tbl_name
D.	DESCRIBE tbl_name
E.	None of these
Answer» E. None of these

Discussion

No Comment Found

Related MCQs

Identify the table name in the following statement.INSERT INTO Employee VALUES('Ajit','M',NULL);
x in the following statement is ____________.DELETE FROM x USING x LEFT JOIN y ON x.col = y.col;
In the following code, InnoDB is __________.CREATE TABLE Employee( Emp_name CHAR(30), Emp_id INT(10), PRIMARY KEY (Emp_id) ) ENGINE = InnoDB;
What column names are displayed when this command is executed?SHOW COLUMNS FROM Table_Name LIKE '%name';
abc in the following statement is ___________.DELETE FROM xyz WHERE abc = 5;
The collations this statement lists are ______________.SHOW COLLATION LIKE 'utf8%'
What is tamp in the following command?mysql -h xyz.host.try.net -p -u tamp
What is the host name in the following command?mysql -h interview.mania.com -p -u sampadam
The number of attributes in the following table is ______________.CREATE TABLE Student( name CHAR(30), id INT(11) );
What does Student & name specify?CREATE TABLE Student (name);