Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: OCP Sample Test Questions
The question, as supplied seems to say:
> Which of the following statements ends a transaction?
> a. COMMIT
> b. ROLLBACK
> c. DROP
> d. ALTER
> e. DELETE
It does not say -
> d. ALTER (the DDL version)
nor does it say
> d. ALTER TABLE
Arguably, given the question as stated, it would be possible to claim that ROLLBACK is also wrong, because not every use of the ROLLBACK statement guarantees to terminate a transaction, viz: rollback to savepoint X
-- Jonathan Lewis Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk Kari Pannila wrote in message <38C8F8BD.9AF89FA6_at_ougf.fi>...Received on Fri Mar 10 2000 - 00:00:00 CST
>Hi
>
>The point is that 'ALTER SESSION' is NOT a DDL
>(Data Definition Language) command but a Session Control command.
>
![]() |
![]() |