Analyze the description of SALES and PROMOTIONS tables in the Exhibit below.

 In order to delete rows from the SALES table, wherein the values for the PROMO_NAME column in the PROMOTIONS table are either ‘blowout sale’ or ‘everyday low price’; 

Which from the following DELETE statements could you use? (Select three.)

In order to display all customers’ first names included in the CUSTOMERS table, when they have the character ‘a’ in the second last position and contain the character ‘e’, which query from the following would produce the required output?

Evaluate the data in the following ORD_ITEMS table: 

Examine the following query:

Which is a true statement regarding the outcome?

Which from the following statements are true about the DELETE and TRUNCATE commands? (Select two.)

Which from the following statements are true regarding views in an Oracle Database? (Select three.)

Analyze the data in the CUST_NAME column of the following CUSTOMERS table: 

You need to display values in the CUST_NAME column where the last name starts with Mc or MC. 

Which from the following WHERE clauses will produce the required outcome? (Select two.)

Which from the following are true regarding the MERGE statement? (Select three.)

Which from the following actions could you perform only with system privileges? (Select three.)