Re: OCP Sample Test Questions

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Fri, 10 Mar 2000 14:09:26 GMT
Message-ID: <38C90216.A326FC05@edcmail.cr.usgs.gov>

Martin Haltmayer wrote:
>
> 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';

You used the ALTER SESSION command which is not a true DDL command. DDL commands force a commit. Try a same test case with a "true" DDL command:

SQL> create table testtab (id number);

Table created.

SQL> insert into testtab values (1);

1 row created.

SQL> alter table employee pctfree 20;

Table altered.

SQL> select * from testtab;

        ID

---

         1  

HTH,
Brian

--

---

Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my company!

---

Received on Fri Mar 10 2000 - 08:09:26 CST