Re: OCP Sample Test Questions

Oh yeah, d is also wrong:

create table test (n number);

insert into test (n) values (5);

alter session set nls_date_format = 'YYYY-MM-DD HH24:MI:SS';

rollback;

select * from test;

will not retrieve any row.

Martin

Martin Haltmayer wrote:
>
> Another one of the bullshit repertoire:
>
> Which of the following statements ends a transaction?
>
> a. COMMIT
>
> b. ROLLBACK
>
> c. DROP
>
> d. ALTER
>
> e. DELETE
>
> The suggested answer is b|c|d, a was missing.
>
> Martin
>
> John Claxton wrote:
> >
> > We're just getting started with sample questions for the Oracle Certified
> > Professional (OCP) tests.
> > You can test your skill and knowledge at
> >
> > http://www.networkessentials.com/certified/ocp
> >
> > where the questions are presented in random order with pop-up answers and
> > cumulative scoring.
> > You can enter comments/questions about each individual question.
> > There's even a form for you to add questions of your own.
> >
> > jc
Received on Thu Mar 09 2000 - 00:00:00 CST