Free Access Oracle.1z0-071.v2022-08-30.q239 Practice Test (Page 23)

Question 106

Examine the structure of the EMPLOYEES table.

You must display the details of employees who have manager with MANAGER_ID 100, who were hired in the past 6 months and who have salaries greater than 10000.
Which query would retrieve the required result?

A.(SELECT last_name, hire_date, salary
FROM employees
WHERE salary > 10000
UNION ALL
SELECT last_name, hire_date, salary
FROM employees
WHERE manager_ID = (SELECT employee_id FROM employees WHERE employee_id = 100)) UNION SELECT last_name, hire_date, salary FROM employees WHERE hire_date > SYSDATE -180;

B.SELECT last_name, hire_date, salary
FROM employees
WHERE manager_id = (SELECT employee_id FROM employees WHERE employee_id = '100') UNION SELECT last_name, hire_date, salary FROM employees WHERE hire_date > SYSDATE -180 INTERSECT SELECT last_name, hire_date, salary FROM employees WHERE salary > 10000;

C.SELECT last_name, hire_date, salary
FROM employees
WHERE salary > 10000
UNION ALL
SELECT last_name, hire_date, salary
FROM employees
WHERE manager_ID = (SELECT employee_id FROM employees WHERE employee_id = 100) INTERSECT SELECT last_name, hire_date, salary FROM employees WHERE hire_date > SYSDATE- 180;

D.SELECT last_name, hire_date, salary
FROM employees
WHERE manager_id = (SELECT employee_id FROM employees WHERE employee_id = 100) UNION ALL (SELECT last_name, hire_date, salary FROM employees WHERE hire_date > SYSDATE -180 INTERSECT SELECT last_name, hire_date, salary FROM employees WHERE salary > 10000);

Question 107

Which two statements are true about INTERVAL data types? (Choose two.)

A.The YEAR field in an INTERVAL YEAR TO MONTHcolumn must be a positive value.

B.INTERVAL DAY TO SECONDcolumns support fractions of seconds.

C.INTERVAL YEAR TO MONTHcolumns only support monthly intervals within a single year.

D.INTERVAL YEAR TO MONTHcolumns support yearly intervals.

E.INTERVAL YEAR TO MONTHcolumns only support monthly intervals within a range of years.

F.The value in an INTERVAL DAY TO SECONDcolumn can be copied into an INTERVAL YEAR TO MONTH column.

Question 108

Examine the description of the EMPLOYEES table:

Which query requires explicit data type conversion?

A.SELECT SUBSTR(join_date, 1, 2) - 10 FROM employees;

B.SELECT join_date FROM employees WHERE join_date > '10-02-2018';

C.SELECT join_date + '20' FROM employees;

D.SELECT join_date || ' ' || salary FROM employees;

E.SELECT salary + '120.50' FROM employees;

Question 109

View the Exhibit and examine the structure of the PROMOTIONS table.

Evaluate the following SQL statement:

Which statement is true regarding the outcome of the above query?

A.It shows COST_REMARK for all the promos in the promo category 'TV'.

B.It produces an error because subqueries cannot be used with the CASE expression.

C.It produces an error because the subquery gives an error.

D.It shows COST_REMARK for all the promos in the table.

Question 110

View the Exhibit and examine the structure of CUSTOMERStable.

Evaluate the following query:

Which statement is true regarding the above query?

A.It produces an error because conditions on the CUST_CREDIT_LIMITcolumn are not valid.

B.It produces an error because the condition on the CUST_FIRST_NAMEcolumn is not valid.

C.It executes successfully.

D.It produces an error because the condition on the CUST_CITYcolumn is not valid.

Other Version: 4128Oracle.1z0-071.v2025-03-22.q314; 7455Oracle.1z0-071.v2024-10-24.q196; 3660Oracle.1z0-071.v2023-10-02.q276; 3040Oracle.1z0-071.v2023-05-08.q154; 7493Oracle.1z0-071.v2022-09-21.q298; 25889Oracle.1z0-071.v2022-02-20.q161; 85Oracle.Prepawaypdf.1z0-071.v2022-01-02.by.miles.211q.pdf

Latest Upload: 129Adobe.AD0-E911.v2026-09-12.q35; 117Google.ADP.v2026-09-11.q22; 131AIChE.CCPSC.v2026-09-11.q41; 131Scrum.PSPO-III.v2026-09-10.q23; 220Scrum.PSPO-I.v2026-09-09.q157; 188ScaledAgile.SAFe-SPC.v2026-09-08.q108; 147Oracle.1Z0-1033-26.v2026-09-08.q43; 221Pegasystems.PEGACPSSA25V1.v2026-09-08.q144; 170BCI.CBCI.v2026-09-07.q89; 214Salesforce.Plat-Admn-202.v2026-09-07.q170

Question 106

Question 107

Question 108

Question 109

Question 110

Download PDF File