Free Access Oracle.1z1-071.v2025-05-13.q352 Practice Test (Page 49)

Question 236

Examine the description of the CUSTOMERS table:

You need to display last names and credit limits of all customers whose last name starts with A or B in lower or upper case, and whose credit limit is below 1000.
Examine this partial query:

Which two WHERE conditions give the required result?

A.Option E

B.Option C

C.Option A

D.Option D

E.Option B

Question 237

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.

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) INETRSECT 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 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);

D.(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;

Question 238

Examine the data in the CUST_NAME column of the CUSTOMERS table:
CUST_NAME
---------------------
Renske Ladwig
Jason Mallin
Samuel McCain
Allan MCEwen
Irene Mikkilineni
Julia Nayer
You want to display the CUST_NAME values where the last name starts with Mc or MC.
Which two WHERE clauses give the required result?

A.WHERE SUBSTR(cust_name, INSTR(cust_name,' ') + 1) LIKE 'Mc%' OR 'MC%'

B.WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name,' ') + 1)) LIKE 'Mc%'

C.WHERE UPPER(SUBSTR(cust_name, INSTR(cust_name,' ') + 1)) LIKE UPPER('MC%')

D.WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name,' ') + 1)) IN ('MC%','Mc%')

E.WHERE SUBSTR(cust_name, INSTR(cust_name,' ') + 1) LIKE 'Mc%'

Question 239

View the exhibits and examine the structures of the COSTSand PROMOTIONStables.

Evaluate the following SQL statement:

What would be the outcome of the above SQL statement?

A.It displays prod IDs in the promos which cost less than the highest cost in the same time interval.

B.It displays prod IDs in the promo with the lowest cost.

C.It displays prod IDs in the promos with the lowest cost in the same time interval.

D.It displays prod IDs in the promos with the highest cost in the same time interval.

Question 240

Which two statements are true about substitution variables? (Choose two.)

A.A substitution variable prefixed with && prompts only once for a value in a session unless it is set to undefined in the session

B.A substitution variable used to prompt for a column name must be enclosed in a single quotation marks

C.A substitution variable can be used only in a SELECTstatement

D.A substitution variable used to prompt for a column name must be enclosed in double quotation marks

E.A substitution variable can be used with any clause in a SELECTstatement

F.A substitution variable prefixed with & always prompts only once for a value in a session

Other Version: 4541Oracle.1z1-071.v2022-04-30.q200; 36Oracle.Prepawayete.1z1-071.v2022-01-25.by.lauren.209q.pdf

Latest Upload: 202PaloAltoNetworks.NGFW-Engineer.v2026-05-01.q43; 299Nokia.4A0-113.v2026-05-01.q69; 255EC-COUNCIL.312-49v11.v2026-04-30.q214; 228Microsoft.MB-820.v2026-04-30.q101; 211Salesforce.MC-202.v2026-04-30.q57; 206BICSI.INSTC_V8.v2026-04-29.q53; 335NMLS.MLO.v2026-04-28.q82; 243NCARB.Project-Management.v2026-04-28.q27; 463EMC.D-AV-DY-23.v2026-04-27.q184; 1117ServiceNow.CSA.v2026-04-27.q483

Question 236

Question 237

Question 238

Question 239

Question 240

Download PDF File