What will be the output of a query given below?SELECT *FROM Employee; – McqOptions

MCQOPTIONS

1.	What will be the output of a query given below? SELECT * FROM Employee;
A.	Show all columns of table Employee
B.	Show all rows and columns of table Employee
C.	Show all rows of table Employee
D.	All of above
E.	None of these
Answer» C. Show all rows of table Employee

Discussion

No Comment Found

Related MCQs

In the following query * stands for<br><pre class="prettyprint lang-c"> SELECT * FROM Employee;<br></pre>
In the following query Employee stands for<br><pre class="prettyprint lang-c">SELECT Emp_id, fname, lname, Birth_date<br> FROM Employee;<br></pre>
What will be the output of a query given below?<br><pre class="prettyprint lang-c">SELECT *<br>FROM Employee;<br></pre>
Find the error?<br><pre class="prettyprint lang-c">SELECT *;<br></pre>
What will be the output of a query given below?<br><pre class="prettyprint lang-c">SELECT Employee_id, FirstName, LastName<br>FROM person;<br></pre>
Is there any error in executing the following query?<br><pre class="prettyprint lang-c">SELECT USER (),<br>VERSION (), DATABASE ();<br></pre>
Is there any error in executing the following query?<br><pre class="prettyprint lang-c">SELECT Student_id, ACTIVE ,<br>Student_id * 3.145,<br>UPPER (LastName)<br>FROM Student;<br></pre>
If in Table Customer , a column Customer_id consists of {1,2,2,3,3,5,6,7,8,8} then what will be the output on executing the following query?<br><pre class="prettyprint lang-c">SELECT DISTINICT emp_id<br>FROM employee;<br></pre>
If in Table account , a column Customer_id consists of {1,2,2,3,3,5,6,7,8,8} then what will be the output on executing the following query?<br><pre class="prettyprint lang-c">SELECT DISTINICT Customer_id<br>FROM account;<br></pre>
What will be the result of the query given below?<br><pre class="prettyprint lang-c">SELECT Person_id,<br> ACTIVE AS STATUS,<br>Person_id * 3.14 AS Person_pi,<br>UPPER (LName) AS Last_Name<br>FROM Person;<br></pre>