Free Access Oracle.1z0-071.v2023-05-08.q154 Practice Test (Page 3)

Question 6

Which three statements are true about single-row functions? (Choose three.)

A.They can accept only one argument

B.The data type returned can be different from the data type of the argument

C.They can be nested to any level

D.The argument can be a column name, variable, literal or an expression

E.They can be used only in the WHERE clause of a SELECT statement

F.They return a single result row per table

Question 7

Examine the description of the PRODUCTS table:

Which three queries use valid expressions? (Choose three.)

A.SELECT product_id, unit_price, unit_price + surcharge FROM products;

B.SELECT product_id, unit_price | | 5 "Discount", unit_price + surcharge - discount FROM products;

C.SELECT product_id, unit_price, 5 "Discount", unit_price + surcharge - discount FROM products;

D.SELECT product_id, (unit_price * 0.15 / (4.75 + 552.25)) FROM products;

E.SELECT product_id, (expiry_date - delivery_date) * 2 FROM products;

F.SELECT product_id, expiry_date * 2 FROM products;

Question 8

See the Exhibit and examine the structure of the PROMOTIONS table:

Using the PROMOTIONS table,
you need to find out the average cost for all promos in the range $0-2000 and $2000-5000 in category A.
You issue the following SQL statements:

What would be the outcome?

A.It generates an error because multiple conditions cannot be specified for the WHEN clause.

B.It executes successfully and gives the required result.

C.It generates an error because CASE cannot be used with group functions.

D.It generates an error because NULL cannot be specified as a return value.

Question 9

Examine the description of the EMPLOYEES table:

Which two queries return the highest salary in the table?

A.SELECT MAX (MAX (salary))
FROM employees
GROUP BY department_id;

B.SELECT MAX (salary)
FROM employees;

C.SELECT department_id, MAX(salary)
FROM employees
GROUP BY department_id;

D.SELECT MAX (salary)
FROM employees
GROUP BY department_id;

E.SELECT MAX (salary)
FROM employees
GROUP BY department_id
HAVING MAX (salary) = MAX (MAX (salary));

Question 10

Which three statements are true regarding subqueries?

A.Multiple columns or expressions can be compared between the main query and subquery.

B.Subqueries can contain ORDER BY but not the GROUP BY clause.

C.Main query and subquery can get data from different tables.

D.Subqueries can contain GROUP BY and ORDER BY clauses.

E.Main query and subquery must get data from the same tables.

F.Only one column or expression can be compared between the main query and subquery.

Other Version: 4097Oracle.1z0-071.v2025-03-22.q314; 7450Oracle.1z0-071.v2024-10-24.q196; 3647Oracle.1z0-071.v2023-10-02.q276; 7465Oracle.1z0-071.v2022-09-21.q298; 6184Oracle.1z0-071.v2022-08-30.q239; 25860Oracle.1z0-071.v2022-02-20.q161; 85Oracle.Prepawaypdf.1z0-071.v2022-01-02.by.miles.211q.pdf

Latest Upload: 101Google.ADP.v2026-09-11.q22; 100AIChE.CCPSC.v2026-09-11.q41; 120Scrum.PSPO-III.v2026-09-10.q23; 216Scrum.PSPO-I.v2026-09-09.q157; 184ScaledAgile.SAFe-SPC.v2026-09-08.q108; 144Oracle.1Z0-1033-26.v2026-09-08.q43; 213Pegasystems.PEGACPSSA25V1.v2026-09-08.q144; 160BCI.CBCI.v2026-09-07.q89; 200Salesforce.Plat-Admn-202.v2026-09-07.q170; 168Fortinet.NSE7_SSE_AD-25.v2026-09-05.q85

Question 6

Question 7

Question 8

Question 9

Question 10

Download PDF File