What is the value of val2? – McqOptions

MCQOPTIONS

1.	What is the value of val2?
A.	val1 + 1
B.	unchanged
C.	updated val1
D.	previous val1
E.	None of these
Answer» D. previous val1

Discussion

No Comment Found

Related MCQs

In the following query how many rows will be updated?<br><pre class="prettyprint lang-c">UPDATE person<br>SET Lname= Gupta ,<br>Fname= Ajit ,<br>WHERE person_id < 10;<br>/* person_id is a primary key */<br></pre>
In the following query how many rows will be updated?<br><pre class="prettyprint lang-c">UPDATE Employee<br>SET Lname= Gupta ,<br>Fname = Ajit ,<br>WHERE Emp_id = 101;<br> /* person_id is a primary key */<br></pre>
What is the value of val2?<br><pre class="prettyprint lang-c">UPDATE t SET val1 = val1 + 2, val2 = val1;<br></pre>
In the following query how many rows will be updated?
What is the value of val2?