Which of the following statements is valid if `sampledb` is a databa – McqOptions

MCQOPTIONS

1.	Which of the following statements is valid if `sampledb` is a database and `tbl` is a table in it?
A.	SELECT * FROM `member`.`sampledb`
B.	SELECT * FROM `sampledb.member`
C.	SELECT * FROM `member.sampledb`
D.	SELECT * FROM `sampledb`.`member`
E.	None of these
Answer» E. None of these

Discussion

No Comment Found

Related MCQs

What does name represent in the following code snippet?<br><pre class="prettyprint lang-c">CREATE TABLE Employee<br> (<br> Emp_name CHAR(30),<br> Emp_id INT(10),<br> Emp_address CHAR(30),<br> Emp_phone CHAR(12)<br> );<br></pre>
What is true about the following SQL statement?<br><pre class="prettyprint lang-c">SELECT * FROM Student;<br></pre>
What is the meaning of EMPTY SET in the following query?<br><pre class="prettyprint lang-c">SELECT First_name, Last_name, Emp_id<br>FROM Employee<br>WHERE Last_name= Gupta ;<br>/* after Execution*/ Mysql tool RETURN EMPTY SET 0:00sec<br></pre>
Which of the following is more efficient?<br>LOAD DATA, INSERT
The function used to convert a string to an int is ______________.
The function used to convert an int to string is ______________.
In MySQL databases, the structure representing the organizational views of the entire databases is ____________.
The MySQL server used in its client/server architecture is _______________.
The tool for copying databases is ______________.
What does name represent in the following code snippet?