In order to display the date for the first Monday of the next month you issued the following command: 

>SELECT TO_CHAR (NEXT_DAY (LAST_DAY (SYSDATE), ‘MON’), ‘dd “is the first Monday for” fmmonth rrrr’) FROM DUAL; 

What would the outcome be?

There is needed to list in a single row all employees in DEPARTMENT_ID 30, ordered by HIRE_DATE. Examine the following sample output: 

Which of the following queries will produce the correct output?

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

All products in the table have a list price. 

The following command is issued in order to display each product total price after applying on it both a discount of 25% and a tax of 15%. 

Additionally, freight charges of $100 must be applied to all products. 

SELECT prod_name, prod_list_price – (prod_list_price* (25/100)) + (prod_list_price – (prod_list_price* (25/100)) * (15/100)) + 100 AS “TOTAL PRICE” FROM products; If all the parentheses are removed from the above statement, what would the outcome be?

Which of the following statements is accurate about SQL and /SQL*Plus?

From the customers table you have to generate a list of all customer last names along with their credit limits. In the list, those customers whose credit limit has no values should appear last. 

Which of the following queries would meet the requirements? (Select two.)

Analyze the below query: 

> SELECT TRUNC(ROUND(156.00, -1), -1) FROM DUAL; 

What would the outcome be?

Examine the following SQL statements: 

>SELECT student id, marks, ROWNUM "Rank" FROM (SELECT student_id, marks FROM students ORDER BY marks) WHERE ROWNUM <= 10 AND finish date BETWEEN 01-JAN-99 AND 31-DEC-99 AND course_id = INT_SQL; 

>DELETE FROM sales; On the SALES table, there are no other uncommitted transactions. 

Which of the following statements is true in regards of the DELETE statement?

You need to generate a report on the customers table which shows 50% of each credit amount in each income level. Repeated credit amounts in each income level should not be shown in the report. 

Which of the following queries would produce the required outcome?