MCQOPTIONS
Home
About Us
Contact Us
Bookmark
Saved Bookmarks
Testing Subject
General Aptitude
Logical and Verbal Reasoning
English Skills Ability
Technical Programming
Current Affairs
General Knowledge
Finance & Accounting
GATE (Mechanical Engineering)
Chemical Engineering
→
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