Which of the following statemets are true regarding aggregate functions? (Select two.)

Examine the data in the PROMOTIONS table below. 

In order to display those promo categories which do not have 'discount' in their subcategory, which of the following SQL statements would produce the required outcome? (Select two.)

View the Exhibit and examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: 

Which of the following DELETE statements would be valid?

Examine the structure of the PROMOTIONS table in the following Exhibit. 

In order to generate a report which displays promo names and start date for all promos that have started after the last promo in the 'INTERNET' category, 

which from the following queries would produce the required output?

Analyze the structure of the CUSTOMERS and CUST_HISTORY tables in the Exhibit below. 

The current location of all currently active customers is contained in the CUSTOMERS table. Historical details relating to any location changes of all current and previous customers who are no longer active with the company, are stored in the CUST_HISTORY table. 

In order to identify those customers who have never changed their address, which SET operator would produce the required output?

Select all statements which are true regarding indexes.

Examine the structure of the CUSTOMERS table that follows. In order to display those customers who are in the same country as customers with the last name 'King' and whose credit limit is lower than the maximum credit limit in the countries that have customers with the last name 'King', you issued the following SQL statement on the CUSTOMERS table: 

> SELECT cust_id, cust_last_name FROM customers WHERE country_id IN (SELECT country_id FROM customers WHERE cust_last_name = ‘King’) AND cust_credit_limit < (SELECT MAX (cust_credit_limit) FROM customers WHERE country_id IN(SELECT country_id FROM customers WHERE cust_last_name = ‘King’)); 

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

Dates are stored by default in the format dd-mm-rr. In order to calculate the number of days from 1st Jan 2007 until the current date, which of the following SQL statements would produce the required output? (Select two.)