Opinion on a question

[Erikxxx]

Hi all,

I'm preparing for the Introduction to SQL exam and I came accross the following question.

Which two statements complete a transaction? (Choose two.)

A. DELETE employees;
B. DESCRIBE employees;
C. ROLLBACK TO SAVEPOINT C;
D. GRANT SELECT ON employees TO SCOTT;
E. ALTER TABLE employees SET UNUSED COLUMN sal;
F. SELECT MAX(sal) FROM employees WHERE department_id = 20;

Answer: C,E according to my notes.

I would also say that D is completing a transaction since all DDL
statements implicitly commit a transaction.

Any opinion on this?

Many Thanks
Erik

 

[psilons]

No, C is wrong. A "ROLLBACK TO SAVEPOINT" will not complete a transaction. It just rollbacks to savepoint. So, it seems like D & E are correct answer.

 

[Erikxxx]

HI Psilons,

Thanks for your answer. It does make sense what you saying and I totally agree with you. I had my exam yesterday and I passed it with 92%

Now it's time to prepare for the next one.

Cheers
Erik