Evaluate the following SQL statement:
SQL> select cust_id, cust_last_name "Last name"
FROM customers
WHERE country_id = 10
UNION
SELECT cust_id CUST_NO, cust_last_name
FROM customers
WHERE country_id = 30
Identify three ORDERBYclauses either one of which can complete the query.

• A.ORDER BY "Last name"
• B.ORDER BY 2, cust_id
• C.ORDER BY CUST_NO
• D.ORDER BY 2, 1
• E.ORDER BY "CUST_NO"

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the ENPLOYES table:

Which query requires explicit data type conversion?

• A.SELECT join_date FROM employees WHERE join date > '10-02-2018';
• B.SELECT join_date 11.'11 salary FROM employees;
• C.SELECT SUBSTR(join date, 1, 2) - 10 FROM employees;
• D.SELECT join_date + '20' EROM employees;
• E.SELECT salary + '120.50' FROM employees;

Comment: *

Name: *

Email: *

Verification: *

You execute these commands:
CREATE TABLE customers (customer id INTEGER, customer name VARCHAR2 (20));
INSERT INTO customers VALUES (1,'Custmoer1 ');
SAVEPOINT post insert;
INSERT INTO customers VALUES (2, 'Customer2 ');
<TODO>
SELECTCOUNT (*) FROM customers;
Which two, used independently, can replace <TODO> so the query retums 1?

• A.ROLLBACK;
• B.COMMIT;
• C.ROLIBACK TO SAVEPOINT post_ insert;
• D.ROLLEBACK TO post_ insert;
• E.CONOIT TO SAVEPOINT post_ insert;

Comment: *

Name: *

Email: *

Verification: *

Examine the structure of the EMPLOYEES table.

You must display the maximum and minimum salaries of employees hired 1 year ago.
Which two statements would provide the correct output? (Choose two.)

• A.SELECT MIN(Salary) minsal, MAX(salary) maxsalFROM employeesWHERE hire_date < SYSDATE-365GROUP BY MIN(salary), MAX(salary);
• B.SELECT MIN(Salary), MAX(salary)FROM (SELECT salary FROMemployeesWHERE hire_date < SYSDATE-365);
• C.SELECT minsal, maxsalFROM (SELECT MIN(salary) minsal, MAX(salary) maxsalFROM employeesWHERE hire_date < SYSDATE-365GROUP BY MIN(salary), MAX(salary));
• D.SELECT minsal, maxsalFROM (SELECT MIN(salary) minsal, MAX(salary) maxsalFROM employeesWHERE hire_date < SYSDATE-365)GROUP BY maxsal, minsal;

Comment: *

Name: *

Email: *

Verification: *

Which statement is true about the INTERSECT operator used in compound queries?

• A.It processes NULLs in the selected columns.
• B.It ignores NULLs.
• C.INTERSECT is of lower precedence than UNION or UNION ALL.
• D.Multiple INTERSECT operators are not possible in the same SQL statement.

Comment: *

Name: *

Email: *

Verification: *