Consider the following transaction code

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

6. Consider the following transaction code

6. Consider the following transaction code:

Begin Transaction
Update names_table set employee_name = "Ramesh" where employee_name = "Mahesh"
Save Transaction SAVE_POINT
Update salaries set salary=salary + 900 where employee_job = "Engineer"
Rollback transaction
Commit transaction
What will be the result produced by this transaction?
1. “Ramesh” will be updated to “Mahesh”, but salaries of engineers will not be updated
2. Neither “Ramesh” will be updated to “Mahesh”, nor the salary of engineers will be updated.
3. “Ramesh” will be updated to “Mahesh” and salary of engineers will also be updated.

(Continued on next question...)

Other Job Interview Questions

• When designing a database table, how do you avoid missing column values for non-primary key columns?
• The IF UPDATE (column_name) parameter in a trigger definition will return TRUE in case of an INSERT statement being executed on the triggered table
• Which of the following is not a valid character datatype in SQL Server?
• Which of the following are not date parts?
• Which of the following is the syntax for creating an Index?
• Is this statement true or false: A cursor is a pointer that identifies a specific working row within a set
• The IF UPDATE (column_name) parameter in a trigger definition will return TRUE in case of an INSERT statement being executed on the triggered table
• Is this statement true or false: A cursor is a pointer that identifies a specific working row within a set
• Which of the following is the syntax for creating an Index?
• Which of the following is not a valid character datatype in SQL Server?
• More...