What is true about the following SQL statement?SELECT * FROM Student; – McqOptions

MCQOPTIONS

1.	What is true about the following SQL statement? SELECT * FROM Student;
A.	display only column names in Student
B.	improper case being used
C.	invalid
D.	display contents of Student
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?