Which of the following are /SQL*Plus commands?

Examine the description for the CUSTOMERS table in the Exhibit below. 

The CUST_CREDIT_LIMIT column needs to be updated to NULL for all customers who have a NULL value in the CUST_INCOME_LEVEL column of the CUSTOMERS table. 

Which of the following SQL statements would you use to accomplish the task?

In the Exhibit below, examine the description of the EMP_DETAILS table: Which of the following statements are true in regards of SQL statements that can be executed on the above EMP_DETAIL table? (Select two.)

You are connected to a remote database in Chicago from your current location in Singapore, and issued the following command: 

> SELECT ROUND (SYSDATE-promo_begin_date, 0) FROM promotions WHERE (SYSDATE-promo_begin_date)/365 > 2; 

The public synonym for the PROMOTIONS table’s public database link is PROMOTIONS. What would the outcome be?

Evaluate the structure of the SALES, PRODUCTS, and COSTS tables in the Exhibit below. 

The following SQL statements are issued:

 > SELECT prod_id FROM products INTERSECT SELECT prod_id FROM sales MINUS SELECT prod_id FROM costs; 

Which of the following statements is true about the above compound query?

The user OE owns of the ORDERS table. 

The owner has granted the SELECT privilege on the ORDERS table to the user HR. 

Which statement would create a synonym ORD so that HR can execute a SELECT * FROM ord query successfully?

The user Alice owns a DEPT table on which she wants to grant query privileges to all users. 

Which of the following SQL statements will accomplish the task?

On a view, which object privileges can be granted?