Examine the structure of the CUSTOMERS and GRADES tables in the following Exhibit: 

In order to display names and grades of those customers with the highest credit limit, which of the following SQL statements would accomplish the task? (Select two.)

Which of the following statements are true about views? (Select two.)

Examine the structure of the following products table: 

Analyze the following two SQL statements: 

> SELECT prod_id, NVL2(prod_expiry_date, prod_expiry_date + 15, “) FROM products; 

> SELECT prod_id, NVL(prod_expiry_date, prod_expiry_date + 15) FROM products; 

In regards of the outcome, which statement is true?

Which of the following statements is true regarding subqueries?

Examine the following data in the products table: 

PROD_ID PROD_LIST_PRICE ---------------------------------------------- 123456 152525.99 The following query is issued: 

> SELECT RPAD(( ROUND(prod_list_price)), 10, '*') FROM products WHERE prod_id = 123456; 

What would the outcome be?

Which of the following statements is true about subqueries?

Which of the following statements are true regarding constraints? (Select two.)

See the Exhibit and examine the structure of the PROMOSTIONS table: 

Which of the following SQL statements are valid? (Select all that apply.)