Evaluate the following SELECTstatement and view the exhibit to examine its output:
SELECT constraint_name, constraint_type, search_condition, r_constraint_name, delete_rule, status, FROM user_constraints WHERE table_name = 'ORDERS';

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

Which statement is true regarding external tables?

You issue the following command to drop the PRODUCTS table:
SQL>DROP TABLE products;
What is the implication of this command? (Choose all that apply.)

Examine the description of the CUSTOMERStable:

You want to display details of all customers who reside in cities starting with the letter D followed by at least two characters.
Which query can be used?

Which statement is true about the Oracle SQL, DELETEand TRUNCATEstatements?