What is the value of val2?UPDATE t SET val1 = val1 + 2, val2 = val1; – McqOptions

MCQOPTIONS

1.	What is the value of val2?UPDATE t SET val1 = val1 + 2, val2 = val1;
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?UPDATE personSET Lname= Gupta ,Fname= Ajit ,WHERE person_id < 10;/* person_id is a primary key */
In the following query how many rows will be updated?UPDATE EmployeeSET Lname= Gupta ,Fname = Ajit ,WHERE Emp_id = 101; /* person_id is a primary key */
What is the value of val2?UPDATE t SET val1 = val1 + 2, val2 = val1;
In the following query how many rows will be updated?
What is the value of val2?