Oracle
1Z0-007 · Question #190
1Z0-007 Question #190: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-007 to reveal the answer and full explanation for question #190. The question stem and answer options stay visible for context.
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 (
Unlock 1Z0-007 to see the answer
You've previewed enough free 1Z0-007 questions. Unlock 1Z0-007 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.