Free Access Oracle.1z1-071.v2022-04-30.q200 Practice Test (Page 34)

Question 161

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.NULLS influence the precedence of operators in an expression

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

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

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

Question 162

View the Exhibit and examine the structure of the PRODUCT_INFORMATION table. (Choose the best answer.)

PRODUCT_ID column is the primary key.
You create an index using this command:
SQL > CREATE INDEX upper_name_idx
ON product_information(UPPER(product_name));
No other indexes exist on the PRODUCT_INFORMATION table.
Which query would use the UPPER_NAME_IDX index?

A.SELECT product_id, UPPER(product_name)
FROM product_information
WHERE UPPER(product_name) = 'LASERPRO' OR list_price > 1000;

B.SELECT product_id
FROM product_information
WHERE UPPER(product_name) IN ('LASERPRO', 'CABLE');

C.SELECT UPPER(product_name)
FROM product_information;

D.SELECT UPPER(product_name)
FROM product_information
WHERE product_id = 2254;

Question 163

Examine the structure of the BOOKS_TRANSACTIONS table:
Examine the SQL statement:
Which statement is true about the outcome?

A.It displays details for members who have borrowed before today with RM as TRANSACTION_TYPE and the details for members A101 or A102.

B.It displays details for members who have borrowed before today's date with either RM as TRANSACTION_TYPE or MEMBER_ID as A101 and A102.

C.It displays details for only members A101 and A102 who have borrowed before today with RM TRANSACTION_TYPE.

D.It displays details only for members who have borrowed before today with RM as TRANSACTION_TYPE.

Question 164

What is true about non-equijoin statement performance?

A.The join syntax used makes no difference to performance.

B.The BETWEEN condition always performs less well than using the >= and <= conditions.

C.The BETWEEN condition always performs better than using the >= and <= conditions.

D.The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax.

E.Table aliases can improve performance.

Question 165

Which two statements are true about INTERVAL data types?

A.The value in an INTERVAL DAY TO SECOND column can be copied into an INTERVAL YEAR TO MONTH column.

B.INTERVAL YEAR TO MONTH columns only support monthly intervals within a single year.

C.INTERVAL YEAR TO MONTH columns only support monthly intervals within a range of years.

D.INTERVAL DAY TO SECOND columns support fractions of seconds.

E.INTERVAL YEAR TO MONTH columns support yearly intervals.

F.The YEAR field in an INTERVAL YEAR TO MONTH column must be a positive value.

Other Version: 1039Oracle.1z1-071.v2025-05-13.q352; 36Oracle.Prepawayete.1z1-071.v2022-01-25.by.lauren.209q.pdf

Latest Upload: 105OCEG.GRCP.v2025-09-11.q211; 104HP.HPE0-V27.v2025-09-11.q78; 118Oracle.1Z0-1057-23.v2025-09-10.q47; 150Google.Professional-Cloud-Network-Engineer.v2025-09-09.q179; 131SAP.C-S4EWM-2023.v2025-09-08.q83; 164TheSecOpsGroup.CNSP.v2025-09-08.q20; 223CFAInstitute.ESG-Investing.v2025-09-08.q173; 158PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 149Salesforce.Data-Architect.v2025-09-05.q216; 144Adobe.AD0-E605.v2025-09-05.q50

Question 161

Question 162

Question 163

Question 164

Question 165

Download PDF File