What does Student & name specify?CREATE TABLE Student (name); – McqOptions

MCQOPTIONS

1.	What does Student & name specify? CREATE TABLE Student (name);
A.	column specs and table name
B.	table name and number of rows
C.	table name and column specs
D.	table name and number of columns
E.	None of these
Answer» D. table name and number of columns

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>