MCQOPTIONS
Bookmark
Saved Bookmarks
→
Mysql
→
Data Types in Mysql
→
The following statement is valid.
1.
The following statement is valid.
SELECT name, id FROM Employee UNION name, salary FROM Person;
A.
False
B.
True
C.
NA
D.
NA
E.
NA
Answer» C. NA
Show Answer
Discussion
No Comment Found
Post Comment
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>
Reply to Comment
×
Name
*
Email
*
Comment
*
Submit Reply
