View the Exhibit and examine the details of the PRODUCT_INFORMATIONtable.
Exhibit

You must display PRODUCT_NAME from the table where the CATEGORY_IDcolumn has values 12or 13, and the SUPPLIER_IDcolumn has the value 102088.
You executed this SQL statement:

Which statement is true regarding the execution?

• A.It would not execute because the entire WHEREclause is not enclosed within parentheses.
• B.It would execute and return the desired result.
• C.It would not execute because the same column has been used twice with the ANDlogical operator.
• D.It would execute but would return no rows.

Comment: *

Name: *

Email: *

Verification: *

Which CREATE TABLEstatement is valid?

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

Comment: *

Name: *

Email: *

Verification: *

You issued this command:

Which three statements are true?

• A.The HR.EMPLOYEES table may be moved to the recycle bin.
• B.Synonyms for HR.EMPLOYEES are dropped.
• C.Sequences used to populate columns in the HR.EMPLOYEES table are dropped.
• D.All constraints defined on HR.EMPLOYEES are dropped.
• E.All indexes defined on HR.EMPLOYEES are dropped.
• F.Views referencing HR.EMPLOYEES are dropped.

Comment: *

Name: *

Email: *

Verification: *

Evaluate the following SQL commands:

The command to create a table fails. Identify the reason for the SQL statement failure.

• A.You cannot use the NEXTVAL sequence value as a DEFAULT value for a column.
• B.You cannot use ORD_NO and ITEM_NO columns as a composite primary key because ORD_NO is also the FOREIGN KEY.
• C.You cannot use the BETWEEN clause in the condition of a CHECK constraint.
• D.You cannot use SYSDATE in the condition of a CHECK constraint.

Comment: *

Name: *

Email: *

Verification: *

View the exhibit and examine the ORDERStable.
ORDERS
Name Null? Type
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
  ADD CONSTRAINT orders_cust_id_nn NOT NULL (customer_id);
• C.ALTER TABLE orders
  MODIFY 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: *