Examine the structure of de the PRODUCTS table in the Exhibit below. Examine the following statement: 

SELECT PROD_NAME FROM PRODUCTS WHERE PROD_ID IN (SELECT PROD_ID FROM PRODUCTS WHERE PROD_LIST_PRICE = ( SELECT MAX(PROD_LIST_PRICE) FROM PRODUCTS WHERE PROD_LIST_PRICE < ( SELECT MAX(PROD_LIST_PRICE) FROM PRODUCTS))); 

Which would be the result of the statement’s execution?

You issued the following command: > DROP TABLE employees; From the following, which statements are true regarding the result? (Select three.)

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

─ The duration of the loan term should be stored in the column. 

─ Data shoul be stored in the column in a format that can be easily added and substracted with the DATE datatype without using conversion functions.

 ─ Loan periods are set at 30 days at maximum. 

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

Which from the following data types would you chose?

Examine the data included in the COSTS table in the Exhibit below.

 You must generate a report displaying the IDs of all products in the COSTS table whose unit price is at least a 25% higher than their unit cost. 

Details in the UNIT_COST column should be displayed in descending order. You issue the following query: 

> SELECT PROD_ID FROM COSTS WHERE UNIT_PRICE >= UNIT_COST * 1.25 ORDER BY UNIT_COST * 0.25 DESC;

 Which from the following statements is true regarding the query?

Evaluate the table’s structure and the data included in the CUST_STATUS table. 

You issued the following SQL statement: 

> SELECT CUSTNO, NVL2(NULLIF (AMT_SPENT, CREDIT_LIMIT), 0, 1000)”BONUS” FROM CUST_STATUS; 

Which statement is true regarding the query’s execution?

Examine the structure of the following SALES table: 

Evaluate the following CREATE statement for the SALES1 table: 

 CREATE TABLE SALES1 (PROD_ID, CUST_ID, QUANTITY_SOLD, PRICE) AS SELECT PRODUCT_ID, CUSTOMER_ID, QUANTITY_SOLD, PRICE FROM SALES WHERE 1=2 

Which statements are true about the creation of the SALES1 table? (Select two.)

View the Exhibit and examine the data in the PROMOTIONS table. 

The default date format for the PROMO_BEGIN_DATE column is dd-mon-yy. 

You must produce a report showing the name, cost and start date of all promotions in the promo category that were released before January 1, 2000. 

Which SQL statement would you use?

View the Exhibit and examine the structure in the CUSTOMERS table. 

By using the CLIENTS table, you must generate a report showing the average credit limit for customers in Washington and New York. 

Which SQL statement would produce the required result?