Oracle
1Z0-061 · Question #236
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.
Using DDL Statements to Create and Manage Tables
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
(48 responses)- A4% (2)
- B77% (37)
- C6% (3)
- D10% (5)
- E2% (1)
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 value#SYSDATE#DDL syntax
Community Discussion
No community discussion yet for this question.