Which CREATE TABLEstatement is valid?

• A.
• B.
• C.
• D.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the ORDERS table. The ORDER_ID column is the PRIMARY KEY in the ORDERS table.

Evaluate the following CREATE TABLE command:
CREATE TABLE new_orders(ord_id, ord_date DEFAULT SYSDATE, cus_id)
AS
SELECT order_id.order_date,customer_id
FROM orders;
Which statement is true regarding the above command?

• A.The NEW_ODRDERS table would not get created because the column names in the CREATE TABLE command and the SELECT clause do not match.
• B.The NEW_ODRDERS table would not get created because the DEFAULT value cannot be specified in the column definition.
• C.The NEW_ODRDERS table would get created and all the constraints defined on the specified columns in the ORDERS table would be passed to the new table.
• D.The NEW_ODRDERS table would get created and only the NOT NULL constraint defined on the specified columns would be passed to the new table.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the details of the PRODUCT_INFORMATION table. (Choose two.) Evaluate this SQL statement:
SELECT TO_CHAR (list_price, '$9,999')
From product_information;
Which two statements are true regarding the output?

• A.A row whose LIST_PRICE column contains value 1123.90 would be displayed as
  $1,123.
• B.A row whose LIST_PRICE column contains value 11235.90 would be displayed as
  $1,123.
• C.A row whose LIST_PRICE column contains value 1123.90 would be displayed as
  $1,124.
• D.A row whose LIST_PRICE column contains value 11235.90 would be displayed as
  #######.

Comment: *

Name: *

Email: *

Verification: *

Examine the commands used to create DEPARTMENT_DETAILSand COURSE_DETAILS tables:

You want to generate a list of all department IDs along with any course IDs that may have been assigned to them.
Which SQL statement must you use?
SELECT d.department_id, c.course_id FROM department_details d RIGHT OUTER JOIN

• A.course_details c ON (d.department_id=c. department_id);
  SELECT d.department_id, c.course_id FROM department_details d LEFT OUTER JOIN
• B.course_details c ON (d.department_id=c. department_id);
  SELECT d.department_id, c.course_id FROM course_details c LEFT OUTER JOIN
• C.department_details d ON (c.department_id=d. department_id);
  SELECT d.department_id, c.course_id FROM department_details d RIGHT OUTER JOIN
• D.course_details c ON (c.department_id=d. department_id);

Comment: *

Name: *

Email: *

Verification: *

Examine the structure of the EMPLOYEES table.

You must display the maximum and minimum salaries of employees hired 1 year ago.
Which two statements would provide the correct output? (Choose two.)

• A.SELECT minsal, maxsal
  FROM (SELECT MIN(salary) minsal, MAX(salary) maxsal
  FROM employees
  WHERE hire_date < SYSDATE-365
  GROUP BY MIN(salary), MAX(salary));
• B.SELECT minsal, maxsal
  FROM (SELECT MIN(salary) minsal, MAX(salary) maxsal
  FROM employees
  WHERE hire_date < SYSDATE-365)
  GROUP BY maxsal, minsal;
• C.SELECT MIN(Salary) minsal, MAX(salary) maxsal
  FROM employees
  WHERE hire_date < SYSDATE-365
  GROUP BY MIN(salary), MAX(salary);
• D.SELECT MIN(Salary), MAX(salary)
  FROM (SELECT salary FROM
  employees
  WHERE hire_date < SYSDATE-365);

Comment: *

Name: *

Email: *

Verification: *