Oracle
1Z0-007 · Question #190
You need to create a table named ORDERS that contain 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…
The correct answer is B. CREATE TABLE orders (. Requirement that Order_Status should be a character data type Not E: Order_status must be a character data type. There is also a syntax error.
Creating and Managing Schema Objects
Question
You need to create a table named ORDERS that contain 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 when the order was placed, today's date should be used instead. Which statement accomplishes this?
Options
- ACREATE TABLE orders (
- BCREATE TABLE orders (
- CCREATE OR REPLACE TABLE orders (
- DCREATE OR REPLACE TABLE orders (
- ECREATE TABLE orders (
- FCREATE TABLE orders (
How the community answered
(25 responses)- B76% (19)
- C12% (3)
- D4% (1)
- F8% (2)
Explanation
Requirement that Order_Status should be a character data type Not E: Order_status must be a character data type. There is also a syntax error.
Topics
#CREATE TABLE#DEFAULT clause#SYSDATE default#DDL
Community Discussion
No community discussion yet for this question.