Examine the description of the SALES and PROMOTIONS tables in the Exhibit below. In order to delete rows from the SALES table, where the PROMO_NAME column in the PROMOTIONS table has as values ‘blowout sale’ or ‘everyday low prices’, which of th following DELETE statements are valid? (Select three.)

You have to design a database for student registration, which contains several tables storing academic information. 

Information about a student is stored in the STUDENTS table, and the STUDENT_GRADES table stores information about the student's grades. 

Both of the tables contain a STUDENT_ID column. 

The STUDENT_ID column in the STUDENTS table is a primary key. 

In order to create a foreign key on the STUDENT_ID column of the STUDENT_GRADES table, referring to the STUDENT_ID column of the STUDENTS table, which of the following statements would create the foreign key?

Analyze the structure of the following EMPLOYEES table: 

You have to create a SQL script file containing an INSERT statement. 

When the script is executed, the INSERT statement should insert into the EMPLOYEES table, a row with the specified values. 

The INSERT statement should pass values to the table columns as Table N°2. 

Which of the following INSERT statements would meet the requirements?

Select the statement that would add a SALARY column to the EMPLOYEES table, which would have 100 rows and could not contain null values.

Examine the structure and data in the INVOICE table below: Which of the following SQL statements would be successful when executed? (Select two.)

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

From the following statements, select three situations in which a transaction is completed.

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

It is needed a report on the CUSTOMERS table that shows the customers details sorted in descending order of both the city and their income level in each city. 

Which query would successfully complete the task?