Is there any error in executing the following query?SELECT Student_id, – McqOptions

MCQOPTIONS

1.	Is there any error in executing the following query? SELECT Student_id, ACTIVE , Student_id * 3.145, UPPER (LastName) FROM Student;
A.	NO
B.	Depends on condition
C.	Yes
D.	Undefined behaviour
E.	None of these
Answer» B. Depends on condition

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>