Where can you use subqueries? (Select all applicable options.)

Using the customers table and in order to display all customers first names containing the character 'e' and having the character 'a' in the second last position, which of the queries would get the required output?

In the Exhibit, evaluate the structure of the students table: 

A report is needed showing the 10 students who have achieved the highest ranking in the course INT SQL completing the course in the year 1999. 

Which of the following SQL statement would accomplish the task?

In regards of the ORDER BY clause default behavior, what statement is true?

In order to drop the products table, you issued the following command: 

> DROP TABLE products; 

Which of the following statements are true regarding the result of executing this command? (Select three.)

In the Exhibit, examine the data in the PROMO_BEGIN_DATE column of the promotions table: 

In order to display the number of promotions started in 1999 and 2000, which query would produce the required output?

Analyze the structure of the EMPLOYEES and NEW_EMPLOYEES tables that follow: 

Which of the following MERGE statements would be valid?

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

A report is needed showing all promos from the PROMOTIONS table with the following characteristics: 

1. The name of the promo should not begin with 'T' or 'N'. 

2. The promo’s cost should be more than $20000. 

3. The promo’s end should be after 1st January 2001. 

Which WHERE clause would produce the required outcome?