Which statement is valid if `sampledb` is a database and `tbl` is – McqOptions

MCQOPTIONS

1.	Which statement 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 `sampledb`.`member`
D.	SELECT * FROM `member`.`sampledb`
E.	None of these
Answer» D. SELECT * FROM `member`.`sampledb`

Discussion

No Comment Found

Related MCQs

Stored programs refer to stored objects of how many of the following types?<br>functions, procedures, triggers, events
How many of the following is considered as a special character by mysql_real_escape_string() ?<br>null byte, single quote, backslash
Which of these has lower memory requirement?<br><pre class="prettyprint lang-c">mysql_use_result(), mysql_store_result()<br></pre>
How many of the following take a connection handler as argument?<br><pre class="prettyprint lang-c">mysql_store_result(), mysql_use_result()<br></pre>
The number of attributes in the following table is ______________.<br><pre class="prettyprint lang-c">CREATE TABLE Student (<br> Stu_name CHAR(30),<br> Stu_id INT<br> );<br></pre>
To how many of the following does the prepared-statement API apply to?<br>CREATE TABLE, DELETE, DO, INSERT
How many of the following return rows?<br>SELECT, SHOW, DESCRIBE
Which of these is more restrictive?<br><pre class="prettyprint lang-c">mysql_query(), mysql_real_query()<br></pre>
The default case sensitivity of the database and table names depends on ___________.
Which statement is valid if `sampledb` is a database and `tbl` is a table in it?