Examine the following query: 

> SELECT promo_name || q’ {‘s start date was \}’ || promo_begin_date AS “Promotion Launches” FROM promotions; 

What would be the outcome of the above query?

Examine the structure of the employees and departments tables in the Exhibit below: 

You need to update the EMPLOYEES table with the following requirements:

 - Update only those employees who work in Boston or Seattle (locations 2900 and 2700). 

- Set department_id for these employees to the department_id corresponding to London (location_id 2100) - For employees in location_id 2100, set their salary to 1.1 times the average salary of their department. 

- For employees in location_id 2100, set their commission to 1.5 times the average commission of their department. You issue the following command: 

SQL>UPDATE employees SET department_id = (SELECT department_id FROM departments WHERE location_id = 2100), (salary, commission) = (SELECT 1. 1*AVG(salary), 1.5*AVG(commission) FROM employees, departments WHERE departments.location_id IN(2900,2700,2100)) WHERE department_id IN (SELECT department_id FROM departments WHERE location_id = 2900 OR location_id = 2700); 

Which will be the result of executing the above command?

The following commands are executed: 

> DEFINE hiredate = ’01-APR-2011’ 

> SELECT employee_id, first_name, salary FROM employees WHERE hire_date 

> ‘&hiredate’ AND manager_id 

> &mgr_id; For the input, 

which substitution variables are you asked for?

In order to display the date 11-oct-2007 in words as Eleventh of October, Two Thousand Seven', 

which of the following SQL statement would produce the required outcome?

When using SQL functions built into Oracle Database, 

which from the following tasks can be performed? (Select three.)

It produces an error because positional notation cannot be used in the order by clause with set operators. 

Analyze the following SQL statement: 

> SELECT promo_id, promo_category FROM promotions WHERE promo_category = ‘Internet’ ORDER BY 2 DESC UNION SELECT promo_id, promo_category FROM promotions WHERE promo_category = ‘TV’ UNION SELECT promo_id, promo_category FROM promotions WHERE promo_category = ‘Radio’; 

Which of the following statements is true about the outcome?

There is no limit on the number of subquery levels in the WHERE clause of a SELECT statement. It is needed a report in which the credit limit has been incremented by $1000 for each customer.

 In the output, the heading Name will be used for customer’s last names and New Credit Limit will be the heading for the incremented credit limit. 

Only the first letter of each word should be in uppercase in the column headings. 

Which from the following statements would satisfy the requirement?

Examine the structure of the CUSTOMERS table in the following Exhibit: 

You want to generate a report from the CUSTOMERS table, which shows an increment of a 15% in the credit limit for all customers. 

Those customers for whom no credit limit has been entered, should be displayed the message "Not available". 

Which from the following SQL statements would produce the required outcome?