READ Free Dumps For Oracle- 1z1-051
Question ID 4912 | You need to create a table named ORDERS that contain four columns: |
Option A | A. CREATE TABLE orders (order_id NUMBER (10),customer_id NUMBER (8),order_status VARCHAR2 (10),date_ordered DATE = SYSDATE); |
Option B | B. CREATE TABLE orders (order_id NUMBER (10),customer_id NUMBER (8),order_status VARCHAR2 (10),date_ordered DATE DEFAULT SYSDATE); |
Option C | C. CREATE OR REPLACE TABLE orders (order_id NUMBER (10),customer_id NUMBER (8),order_status VARCHAR2 (10),date_ordered DATE DEFAULT SYSDATE); |
Option D | D. CREATE OR REPLACE TABLE orders (order_id NUMBER (10),customer_id NUMBER (8),order_status VARCHAR2 (10),date_ordered DATE = SYSDATE); |
Option E | E. CREATE TABLE orders (order_id NUMBER (10),customer_id NUMBER (8),order_status NUMBER (10),date_ordered DATE = SYSDATE); |
Correct Answer | B |
Question ID 4913 | Examine the structure of the EMPLOYEES table: |
Option A | A. INSERT INTO employees VALUES ( NULL, 'John', 'Smith'); |
Option B | B. INSERT INTO employees( first_name, last_name) VALUES( 'John', 'Smith'); |
Option C | C. INSERT INTO employees VALUES ( 1000, 'John', NULL); |
Option D | D. INSERT INTO employees (first_name, last_name, employee_id) VALUES ( 1000, 'John', 'Smith'); |
Option E | E. INSERT INTO employees (employee_id) VALUES (1000); |
Option F | F. INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'John', ' '); |
Correct Answer | C,E,F |