Test Index

Java SE 7 Programmer II (1Z0-804)

Question : 6

Total: 8

try {      
/*assume "conn" is a valid Connection object    */  
/* assume a valid Statement object is created*/      
/* assume rollback invocations will be valid*/  
/*use SQL to add 10 to a checking account */  
Savepoint s1 = conn.setSavePoint();      
/*use SQL to add 100 to the same checking account */  
Savepoint s2 = conn.setSavePoint();      
/* use SQL to add 1000 to the same checking account  */  
/* insert valid rollback method invocation here  */  
} catch (Exception e) { }

Which two statements are true?

If conn.rollback(s1) is inserted, account will be incremented by 10.
If conn.rollback(s1) is inserted, account will be incremented by 1010.
If conn.rollback(s2) is inserted, account will be incremented by 100.
If conn.rollback(s2) is inserted, account will be incremented by 110.
If conn.rollback(s2) is inserted, account will be incremented by 1110.

Validate

Go to Question:

Prev Question

Next Question