What is the value of comm and sal after executing the following query if the initial value of ‘sal’ is 10000?

Question:What is the value of comm and sal after executing the following query if the initial value of ‘sal’ is 10000??

Answer: </P><P>UPDATE EMP SET SAL = SAL + 1000, COMM = SAL*0.1;</P><P>sal = 11000, comm = 1000</P><P>

Tags:Interview Questions, Database, SQL,

Please submit your Interview Answer for the above Question via replying to this post. Thank you for visiting to our blog, Have a Good Day!.

---

Sponsor Advertisement

SMS Management System Software

This software used to Send bulk SMS (short text messages) from your computer and assists you to rapidly connect with your customers and staff, communicate with them easily and cheaply, using latest technology that help to generate bulk SMS on just one click to all the database....