Online Access Free Oracle.1z1-071.v2022-04-29.q239 Practice Test (Page 32)

1z1-071 Exam Question 151

Which two statements are true about the rules of precedence for operators? (Choose two.)

A.Multiple parentheses can be used to override the default precedence of operators in an expression

B.The concatenation operator | | is always evaluated before addition and subtraction in an expression

C.The + binary operator has the highest precedence in an expression in a SQL statement

D.NULLS influence the precedence of operators in an expression

E.Arithmetic operators with equal precedence area evaluated from left to right within an expression

1z1-071 Exam Question 152

Which two queries execute successfully?

A.SELECT NULLIF(NULL, 100) FROM DUAL;

B.SELECT NULLIF(100, 100) FROM DUAL;

C.SELECT COALESCE(100, 'A' ) FROM DUAL;

D.SELECT NULLIF(100, 'A') FROM DUAL;

E.SELECT COALESCE(100, NULL, 200) FROM DUAL;

1z1-071 Exam Question 153

Examine the description of the PRODUCT_DETAILS table:

Which two statements are true?

A.PRODUCT_ID can be assigned the PRIMARY KEY constraint.

B.PRODUCT_PRICE can be used in an arithmetic expression even if it has no value stored in it.

C.PRODUCT_PRICE contains the value zero by default if no value is assigned to it.

D.PRODUCT_NAME cannot contain duplicate values.

E.EXPIRY_DATE cannot be used in arithmetic expressions.

F.EXPIRY_DATE contains the SYSDATE by default if no date is assigned to it.

1z1-071 Exam Question 154

Examine the description of the EMPLOYERS table:

Examine these requirements:
Disable the manager ID and salary of the lowest paid employees for that manager.
Exclude anyone whose manager is not known.
Exclude any managers where the minimum salary is 6000 or less.
Sort the output by minimum salary with the highest salary shown first.
Which statement will do this?

A.SELECT managar_id, MIN (salary)
FROM employees
HAVING MIN(salary) > 6000
WHERE manager_id IS NOT NULL
GROUP BY manager_id
ORDER BY MTN(salary) DESC;

B.SELECT manager_id, MTN(salary)
FROM employees
WHERE manager_ id IS NOT NULL
GROUP BY manager_id
HAVING MlN (salary) > 6000
ORDER BV MlN (salary);

C.SELECT manager_id, HTN(salary)
FROM employees
WHERE manager_id IS NOT NULL
HAVING MIN (salary) > 6000
GROUP BY manager_id
ORDEU BY MIN (salary) DESC;

D.SELECT manager_id, MIN(salary)
FROM employees
WHERE manager_id IS NOT NULL
AND MIN(salary) > 6000
GROUP BY manager_id
ORDER BY MlN (salary) DESC;

1z1-071 Exam Question 155

Which two tasks require subqueries?

A.Display the total number of products supplied by supplier 102 which have a product status of obsolete.

B.Display the number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE.

C.Display suppliers whose PROD_LIST_PRICE is less than 1000.

D.Display products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of all products, and whose status is orderable.

E.Display the minimum PROD_LIST_PRICE for each product status.

Other Version: 113Oracle.Latestcram.1z1-071.v2022-05-31.by.martina.239q.pdf; 5753Oracle.1z1-071.v2021-12-09.q323; 115Oracle.Lead2passed.1z1-071.v2021-09-02.by.nelly.334q.pdf

Latest Upload: 103SAP.C_ABAPD_2507.v2025-09-12.q56; 103SAP.C_TS452_2022.v2025-09-12.q83; 171ACSM.020-222.v2025-09-11.q48; 157VMware.5V0-31.23.v2025-09-10.q73; 131Oracle.1z0-915-1.v2025-09-10.q24; 160Citrix.1Y0-231.v2025-09-10.q87; 138SAP.C-THR85-2505.v2025-09-09.q29; 167Adobe.AD0-E727.v2025-09-09.q76; 130Oracle.1Z0-1123-25.v2025-09-09.q20; 136SAP.C_SIGPM_2403.v2025-09-08.q20

1z1-071 Exam Question 151

1z1-071 Exam Question 152

1z1-071 Exam Question 153

1z1-071 Exam Question 154

1z1-071 Exam Question 155

Download PDF File