In the following query how many rows will be updated? – McqOptions

MCQOPTIONS

1.	In the following query how many rows will be updated?
A.	1-6
B.	No row
C.	0-9
D.	All of above
E.	None of these
Answer» D. All of above

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?