Evaluate the following query:
SQL> SELECT TRUNC (ROUND (156.00, -1),-1)
FROM DUAL;
What would be the outcome?

• A.200
• B.160
• C.16
• D.150
• E.100

Comment: *

Name: *

Email: *

Verification: *

View the exhibit and examine the description of the DEPARTMENTS and EMPLOYEES tables.

You wrote this SQL statement to retrieve EMPLOYEE_ID, FIRST_NAME, and DEPARTMENT NAME, for all employees:
SELECT employee_id, first_name, department_name
FROM employees
NATURAL JOIN departments;
The desired output is not obtained after executing the above SQL statement. What could be the reason for this?

• A.The DEPARTMENTS table is not used before the EMPLOYEES table in the FROM clause.
• B.The table prefix is missing for the column names in the SELECT clause.
• C.The NATURAL JOIN clause is missing the USING clause.
• D.The EMPLOYEES and DEPARTMENTS tables have more than one column with the same column name and data type.
  Natural join needs only one column to be the same in each table. The EMPLOYEES and DEPARTMENTS tables have two columns that are the same (Department_ID and Manager_ID)

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of CUSTOMERStable.

Evaluate the following query:

Which statement is true regarding the above query?

• A.It produces an error because conditions on the CUST_CREDIT_LIMITcolumn are not valid.
• B.It produces an error because the condition on the CUST_FIRST_NAMEcolumn is not valid.
• C.It executes successfully.
• D.It produces an error because the condition on the CUST_CITYcolumn is not valid.

Comment: *

Name: *

Email: *

Verification: *

Examine the structure of the SALES table.

Examine this statement:

Which two statements are true about the SALES1 table? (Choose two.)

• A.It will not be created because the column-specified names in the SELECT and CREATE TABLE clauses do not match.
• B.It will have NOT NULL constraints on the selected columns which had those constraints in the SALES table.
• C.It will not be created because of the invalid WHERE clause.
• D.It is created with no rows.
• E.It has PRIMARY KEY and UNIQUE constraints on the selected columns which had those constraints in the SALES table.

Comment: *

Name: *

Email: *

Verification: *

View the exhibit and examine the ORDERStable.
ORDERS
Null? Type
Name
ORDER ID NOT NULL NUMBER(4)
ORDATE DATE DATE
CUSTOMER ID NUMBER(3)
ORDER TOTAL NUMBER(7,2)
The ORDERStable contains data and all orders have been assigned a customer ID. Which statement would add a NOTNULLconstraint to the CUSTOMER_IDcolumn?

• A.ALTER TABLE orders
  ADD customer_id NUMBER(6)CONSTRAINT orders_cust_id_nn NOT NULL;
• B.ALTER TABLE orders
  MODIFY CONSTRAINT orders_cust_id_nn NOT NULL (customer_id);
• C.ALTER TABLE orders
  ADD CONSTRAINT orders_cust_id_nn NOT NULL (customer_id);
• D.ALTER TABLE orders
  MODIFY customer_id CONSTRAINT orders_cust_nn NOT NULL (customer_id);

Comment: *

Name: *

Email: *

Verification: *