What column names are displayed when this command is executed?SHOW COL – McqOptions

MCQOPTIONS

1.	What column names are displayed when this command is executed?SHOW COLUMNS FROM Table_Name LIKE '%name';
A.	prefixed with name
B.	prefixed with %name
C.	suffixed with name
D.	suffixed with %name
E.	None of these
Answer» D. suffixed with %name

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);