Suppose you want to select a database named sampledb as the default – McqOptions

MCQOPTIONS

1.	Suppose you want to select a database named sampledb as the default database. Which of the following commands do you use?
A.	USE DATABASE sampledb
B.	USE sampledb
C.	SELECT DATABASE sampledb
D.	SELECT DATABASE()
E.	None of these
Answer» C. SELECT DATABASE sampledb

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>