Evaluate the description of the MEMBERS table: Analyze the partial query below: 

►SELECT city, last_name LNAME FROM members …; 

You need to display all cities that contain the string AN. The cities have to be returned in ascending order, with the last names further sorted in descending order. 

Which two of the following clauses would you add to the query to obtain the required output?

You issued this command: 

►ALTER TABLE employees SET UNUSED (department_id) 

Two of the following statements are true. 

Select them.

You are asked to create a table for a banking application. 

One of the columns must satisfy theese three requirements: 

1) Store a load period of up to 10 years. 

2) Be used for calculating interest for the number of days the loan remains unpaid. 

3) Be stored in a format that supports DATE arithmetic without using conversion functions. 

Which data type must you use to obtain the desired result?

The column ORDER_DATE, of data type DATE, exists in the ORDERS table. 

The default display format for a date is DD-MON-RR. 

Coose two of the following WHERE conditions that demonstrate the correct usage of conversion functions.

Choose two of the following statements that are true regarding savepoints.

Evaluate the description of the ORDER_ITEMS table: 

Analyze this incomplete query: 

Choose two that can replace

Evaluate the data in the PRODUCTS table: 

Analyze these three queries: 

Which of the following queries will generate the same output?

Evaluate the description of the EMPLOYEES table: 

Choose two of the following queries that will return rows for employees whose manager works in a different department.