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?CREATE TABLE Employee ( Emp_name CHAR(30), Emp_id INT(10), Emp_address CHAR(30), Emp_phone CHAR(12) );
What is true about the following SQL statement?SELECT * FROM Student;
What is the meaning of EMPTY SET in the following query?SELECT First_name, Last_name, Emp_idFROM EmployeeWHERE Last_name= Gupta ;/* after Execution*/ Mysql tool RETURN EMPTY SET 0:00sec
Which of the following is more efficient?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?