Which from the following statements are true about subqueries? (Select two.)

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

Based on the PROMOTIONS table, you have to display the names and cost of all promotions in the 'TV' and 'internet' categories that have ended between March 15 and October 15, 2000. 

Which of the following queries would produce the required outcome? (Select two.)

Which of the following statements are true about the ORDER BY clause? (Select two.)

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

Which of the following statements is describing the ROWID data type?

Which of the following statements complete a transaction? (Select two)

Which of the following statements is true in regards of the COALESCE function?

The CUSTOMER_ID column is the primary key for the CUSTOMERS table. 

In order to determine how extended is your customer base, which expression would find the number of different countries represented in the CUSTOMERS table?