Re: Oracle9i Questions

"gg70" <Gaseal3_at_aol.com> wrote in message news:7915866d.0308310743.1b154907_at_posting.google.com...
> Please answer the following if you can.
>
> 1. Given the following Table Name: Publisher and Table Publisher
> Constraint: Pub_ID is a PRIMARY KEY, Pub_ID varchar2(3), Pub_Name
> varchar2(20) and Pub_Phone varchar2(12). What is the command to
> create and insert some information into this table?
>
> 2. Given a Table Name Authors, and Table Authors Constraint -
> Author_Id is a PRIMARY KEY. Author_ID number(3) Auth_Name varchar2(15)
> and Auth_phone varchar2(12). What is the command to create and insert
> some information into this Table?
>
> 3. Given a Table Name Books, and Table Books Constraints:
> ISBN is a PRIMARY KEY
> Pub_id is a FOREIGN KEY AND NOT NULL
> Price should be checked so that its price does not exceed $99.00
> and NOT
> NULL.
> Title should not be NULL
> ISBN Varchar2(13), Title Varchar2(20), pub_id varchar2(3) and Price
> Number(5,2)
> What is the command to create and insert some information into this
> table?
>
>
> 4. Given a Table Name Bk_Author, and Table Bk_Author Constraints:
>
> ISBN is a foreign key should not be NULL
> Author_ID is a foreign key and should not be NULL
> ISBN Varchar2(13),Author_ID Number(3)
> What is the command to create this table and insert some information
> into this table?
>
>
> 5. Given the Table Name: Bk_Author and Table Bk_Author Constraints:
> ISBN is a foreign key should not be NULL
> Author _ID is a foreign key and should not be NULL
> ISBN Varchar2(13) and Author_ID Number(3).
>
> What is the command to create and insert some information into this
> table?
>
> Thanks.

you are joking right? Received on Sun Aug 31 2003 - 10:48:59 CDT