Category: 1z0-007

Exam 1z0-007: Introduction to Oracle9i: SQL

Which statement accomplishes this?

You need to create a table named ORDERS that contains four columns:
1. an ORDER_ID column of number data type
2. a CUSTOMER_ID column of number data type
3. an ORDER_STATUS column that contains a character data type
4. a DATE_ORDERED column to contain the date the order was placed
When a row is inserted into the table, if no value is provided for the status of the order, the value
PENDING should be used instead.
Which statement accomplishes this?

Page 1 of 1112345...10...Last »