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