View the structure of the PROGRAMS table in the Exhibit below: Which of the following SQL statements would succeed at execution? (Select two.)

Examine columns in the STUDENT_GRADES table that follows: In order to identify the students that have a grade point average (GPA) higher than 3.0 for the calendar year 2001, which statement would you use?

Examine the structures of the PROMOTIONS and SALES tables in the Exhibits. 

Analyze the following SQL statements: 

> SELECT p.promo_id, p.promo_name, s.prod_id FROM sales s RIGHT OUTER JOIN promotions p ON (s.promo_id = p.promo_id); 

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

Analyze the following statements:

 CREATE ROLE registrar; GRANT UPDATE ON student_grades TO registrar; GRANT registrar to user1, user2, user3; 

What would be the result of this set of SQL statements?

Examine the structure of the PROMOTIONS table that follows: 

Based on the PROMOTIONS table, for all promos in the range $0-2000 and $2000-5000 in category A, you have to obtain the average cost as the output. In that order, you issued the following SQL statements: 

SQL

> SELECT AVG (CASE WHEN promo_cost BETWEEN 0 AND 2000 AND promo_category = ‘A’ THEN promo_cost ELSE null END) “CAT_2000A”, AVG (CASE WHEN promo_cost BETWEEN 2001 AND 5000 AND promo_category = ‘A’ THEN promo_cost ELSE null END) “CAT_5000A” FROM promotions; 

What would be the result?

Evaluate the structure of the following employees table: 

Choose the valid INSERT statement from the following options:

Evaluate the structure of the following marks table: Which of the following statements would succeed at execution? (Select two.)

Evaluate the description of the following orders table: After having inserted some rows in the table, you want to alter the table by creating the PRIMARY KEY constraint on the ORD_ID column. 

In this scenario, which of the following statements is true?