Analyze the description of the EMPLOYEES table in the sample below. 

You issued the following SQL statement: 

►SELECT first_name, department_id, salary FROM employees ORDER BY department_id, first_name, salary desc; 

Which from the following statements are true in regards of the result? (Select two.)

Analyze the structure of the following SALES table. 

Analyze the following statement: 

Which from the following statements are true regarding the SALES1 table? (Select two.)

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

Analyze the structure of ORDERS and CUSTOMERS tables in the sample below. 

You issued the following UPDATE statement: 

Which from the following statements is true in regards of the execution? (Select the best choice.)

Analyze the structure of this PROMOTIONS table: 

All unique promotion costs in all promotion categories should be reported to Management. 

Which from the following queries will satisfy this requirement? (Select the best choice.)

You are asked to create a table for a banking application, with the following requirements for one of the columns in the table: 

1: The duration of a short team loan will be stored in the column. 

2: A format supporting DATE arithmetic with DATE datatypes (without using conversion functions) should be used to store the data. 

3: Loan periods are set at 30 days at maximum. 

4: Interest has to be calculated depending on the number of days allowed for the loan remaining unpaid. 

Which from the following data types would you chose?

Analyze the description of the EMPLOYEES table that follows: Which from the following would be a valid query?

Which ones, from the following, are the minimal requirements for a self-join? (Select two.)