Re: OCP Sample Test Questions

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!
========================================