What will be the result of the query given below?SELECT Person_id, ACT – McqOptions

MCQOPTIONS

1.	What will be the result of the query given below? SELECT Person_id, ACTIVE AS STATUS, Person_id * 3.14 AS Person_pi, UPPER (LName) AS Last_Name FROM Person;
A.	Error
B.	Person_id, ACTIVE, Person_id * 314, UPPER(LName)
C.	Person_id, Status, Person_pi, Last_Name
D.	All of above
E.	None of these
Answer» D. All of above

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>