Examine this SELECT statement and view the Exhibit to see its output:

SELECT constraints_name, constraints_type, search_condition, r_constraints_name, delete_rule, status, FROM user_constraints WHERE table_name = 'ORDERS'; Which two statements are true about the output? (Choose two.)

• A.The R_CONSTRAINT_NAME column contains an alternative name for the constraint.
• B.The DELETE_RULE column indicates the desired state of related rows in the child table when the corresponding row is deleted from the parent table.
• C.The STATUS column indicates whether the table is currently in use.
• D.In the second column, 'c' indicates a check constraint.

Comment: *

Name: *

Email: *

Verification: *

The first DROP operation is performed on PRODUCTS table using the following command:
DROP TABLE products PURGE;
Then you performed the FLASHBACK operation by using the following command:
FLASHBACK TABLE products TO BEFORE DROP;
Which statement describes the outcome of the FLASHBACK command?

• A.It recovers only the table structure.
• B.It recovers the table structure, data, and the indexes.
• C.It recovers the table structure and data but not the related indexes.
• D.It is not possible to recover the table structure, data, or the related indexes.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the details of PRODUCT_INFORMATION table.

You have the requirement to display PRODUCT_NAME from the table where the CATEGORY_ID column has values 12 or 13, and the SUPPLIER_ID column has the value 102088. You executed the following SQL statement:
SELECT product_name
FROM product_information
WHERE (category_id = 12 AND category_id = 13) AND supplier_id = 102088;
Which statement is true regarding the execution of the query?

• A.It would execute and the output would display the desired result.
• B.It would not execute because the entire WHERE clause condition is not enclosed within the parentheses.
• C.It would not execute because the same column has been used in both sides of the AND logical operator to form the condition.
• D.It would execute but the output would return no rows.

Comment: *

Name: *

Email: *

Verification: *

Examine the structure of the MEMBERS table: (Choose the best answer.)

Examine the SQL statement:
SQL > SELECT city, last_name LNAME FROM MEMBERS ORDER BY 1, LNAME DESC; What would be the result execution?

• A.It displays all cities in descending order, within which the last names are further sorted in descending order.
• B.It displays all cities in ascending order, within which the last names are further sorted in descending order.
• C.It fails because a column alias cannot be used in the ORDER BY clause.
• D.It fails because a column number and a column alias cannot be used together in the ORDER BY clause.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about dropping columns from a table? (Choose two.)

• A.A column can be removed only if it contains no data.
• B.Multiple columns can be dropped simultaneously using the ALTER TABLEcommand.
• C.A column must be set as unused before it is dropped from a table.
• D.A column drop is implicitly committed.
• E.A primary key column cannot be dropped.
• F.A column that is referenced by another column in any other table cannot be dropped.

Comment: *

Name: *

Email: *

Verification: *