| Question ID 1655 | 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?
|
| Option A | A. CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8),
order_status VARCHAR2(10) DEFAULT 'PENDING', date_ordered VARCHAR2 );
|
| Option B | B. CREATE TABLE orders (
order_id NUMBER(10),
customer_id NUMBER(8),
order_status VARCHAR2(10) DEFAULT 'PENDING',
date_ordered DATE );
|
| Option C | C. CREATE OR REPLACE TABLE orders (
order_id NUMBER(10),
customer_id NUMBER(8),
order_status VARCHAR2(10) DEFAULT 'PENDING',
date_ordered DATE );
|
| Option D | D. CREATE TABLE orders (
order_id NUMBER(10),
customer_id NUMBER(8),
order_status NUMBER(10) DEFAULT 'PENDING',
date_ordered DATE );
|
| Option E | E. CREATE OR REPLACE TABLE orders ( order_id NUMBER(10),
customer_id NUMBER(8),
order_status VARCHAR2(10) = 'PENDING', date_ordered DATE );
|
| Option F | F. CREATE TABLE orders (
order_id NUMBER(10),
customer_id NUMBER(8),
order_status VARCHAR2(10) = 'PENDING',
date_ordered DATE );
|
| Correct Answer | B |
| Question ID 1656 | Evaluate this SQL statement:
SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME FROM EMPLOYEES e, DEPARTMENTS d
WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID;
In the statement, which capabilities of a SELECT statement are performed?
|
| Option A | A. selection, projection, join
|
| Option B | B. selection, intersection, join
|
| Option C | C. intersection, projection, join
|
| Option D | D. difference, projection, product
|
| Option E | E. difference, projection, join
|
| Correct Answer | A |