Re: OCP Question (3)

According to the Oracle8 SQL Reference, "A number can store a maximum of 38 digits of precision." If you do not specify a precision, it defaults to 38. I believe this to be true for Oracle7 as well. So the correct answer should be '38'. It is not listed in any of the answers you supplied. But as written below, the create table statement will cause an error due to syntax. The correct syntax should be:

   CREATE TABLE doctor (

     dr_id NUMBER,
     first_name CHAR(15),
     last_name CHAR(15));

HTH,
Brian

Wesley wrote:
>
> > When indicating the field type as number such as
> > create table doctor
> > dr_id number,
> > first_name char(15),
> > last_name char(15);
> > when no precision is indicated as in the above
> > example what is the default precision value
> > assigned to dr_id?
> > 1. 1
> > 2. 9
> > 3. 15
> > 4. 255
> > 5. This will cause an error.
> >
> TIA
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Nov 22 1999 - 08:00:24 CST