MCQOPTIONS
Bookmark
Saved Bookmarks
→
Mysql
→
Data Types
→
What is the value of val2?
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
Show Answer
Discussion
No Comment Found
Post Comment
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?
Reply to Comment
×
Name
*
Email
*
Comment
*
Submit Reply
Your experience on this site will be improved by allowing cookies. Read
Cookie Policy
Reject
Allow cookies