Examine the structure of the EMPLOYEES table:

You want to create a SQL script file that contains an INSERT statement. When the script is run, the INSERT statement should insert a row with the specified values into the EMPLOYEES table. The INSERT statement should pass values to the table columns as specified below: Which INSERT statement meets the above requirements?

• A. INSERT INTO employees
  VALUES (emp_id_seq.NEXTVAL, '&ename', '&jobid',
  2000, NULL, &did IN (20,50));
• B. INSERT INTO (SELECT *
  FROM employees
  WHERE department_id IN (20,50)
  WITH CHECK OPTION)
  VALUES (emp_id_seq.NEXTVAL, '&ename', '&jobid', 2000, NULL, &did);
• C. INSERT INTO (SELECT *
  FROM employees
  WHERE (department_id = 20 AND
  department_id = 50)
  WITH CHECK OPTION )
  VALUES (emp_id_seq.NEXTVAL, '&ename', '&jobid', 2000, NULL, &did);
• D. INSERT INTO employees
  VALUES (emp_id_seq.NEXTVAL, '&ename', '&jobid', 2000, NULL, &did);
• E. INSERT INTO (SELECT *
  FROM employees
  WHERE department_id IN (20,50))
  VALUES (emp_id_seq.NEXTVAL, '&ename', '&jobid', 2000, NULL, &did);

Which is an /SQL*Plus command?

• A. RENAME
• B. DESCRIBE
• C. UPDATE
• D. INSERT
• E. SELECT
• F. DELETE

Evaluate the set of SQL statements:
CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)); ROLLBACK; DESCRIBE DEPT
What is true about the set?

• A. The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.
• B. The DESCRIBE DEPT statement displays the structure of the DEPT table.
• C. The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.
• D. The ROLLBACK statement frees the storage space occupies by the DEPT table.

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?

• A. CREATE TABLE orders (
  order_id NUMBER (10),
  customer_id NUMBER (8),
  order_status VARCHAR2 (10),
  date_ordered DATE = SYSDATE);
• B. CREATE TABLE orders (
  order_id NUMBER (10),
  customer_id NUMBER (8),
  order_status VARCHAR2 (10),
  date_ordered DATE DEFAULT SYSDATE);
• C. CREATE TABLE orders (
  order_id NUMBER (10),
  customer_id NUMBER (8),
  order_status NUMBER (10),
  date_ordered DATE DEFAULT SYSDATE);
• D. CREATE OR REPLACE TABLE orders (
  order_id NUMBER (10),
  customer_id NUMBER (8),
  order_status VARCHAR2 (10),
  date_ordered DATE = SYSDATE);
• E. CREATE OR REPLACE TABLE orders (
  order_id NUMBER (10),
  customer_id NUMBER (8),
  order_status VARCHAR2 (10),
  date_ordered DATE DEFAULT SYSDATE);
• F. CREATE TABLE orders (
  order_id NUMBER (10),
  customer_id NUMBER (8),
  order_status NUMBER (10),
  date_ordered DATE = SYSDATE);