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

Question 116

Examine the description of the PRODUCTS table:

Which three queries use valid expressions?

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

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

C.SELEGT product_id, unit_price, unit_price + surcharge FROM products;

D.SELECT ptoduct_id, (expiry_date-delivery_date) * 2 FROM products;

E.SPLECT product_id, expiry_date * 2 FROM products;

F.SELECT produet_id, unit_pricer, 5 "Discount",unit_price+surcharge-discount FROM products;

Question 117

Examine these requirements:
1. Display book titles for books purchased before January 17, 2007 costing less than 500 or more than 1000.
2. Sort the titles by date of purchase, starting with the most recently purchased book.
Which two queries can be used?

A.SELECT book_title FROM books WHERE (price NOT BETWEEN 500 AND 1000) AND (purchase_date< '17-JAN-2007') ORDER BY purchase_date DESC;

B.SELECT book_title FROM books WHERE (price< 500 OR >1000) AND (purchase date< '17-JAN-2007') ORDER BY purchase date DESC;

C.SELECT book_title FROM books WHERE (price BETWEEN 500 AND 1000) AND (purchase_date<'17-JAN-2007') ORDER BY purchase_date;

D.SELECT book_title FROM books WHERE (price IN (500, 1000)) AND (purchase date < '17-JAN-2007') ORDER BY purchase_date ASC;

Question 118

Examine the structure proposed for the TRANSACTIONS table:

Which two statements are true regarding the creation and storage of data in the above table structure? (Choose two.)

A.The TRANS_DATE column would be able to store day, month, century, year, hour, minutes, seconds, and fractions of seconds.

B.The CUST_STATUS column would give an error.

C.The TRANS_VALIDITY column would give an error.

D.The TRANS_VALIDITY column would have a maximum size of one character.

E.The CUST_CREDIT_LIMIT column would be able to store decimal values.

F.The CUST_STATUS column would store exactly one character.

Question 119

Which two statements are true?

A.Both CASE and DECODE are functions.

B.AIl conditions evaluated using DECODE can also be evaluated using CASE.

C.All conditions evaluated using CASE can also be evaluated using DECODE.

D.CASE is a function and DECODE is not.

E.DECODE is a function and CASE is not.

F.Neither CASE nor DECODE is a function.

Question 120

Which three tasks can be performed by DDL statements?

A.preventing any data modification to a table

B.creating multiple savepoints to enable partial rollback of a transaction

C.modifying a table to prevent data that violate certain conditions from being entered in a column

D.providing an alternative name for a table

E.preventing data retrieval from a table outside of office hours

Other Version: 3175Oracle.1z0-071.v2025-03-22.q314; 6682Oracle.1z0-071.v2024-10-24.q196; 3070Oracle.1z0-071.v2023-10-02.q276; 6685Oracle.1z0-071.v2022-09-21.q298; 5538Oracle.1z0-071.v2022-08-30.q239; 25309Oracle.1z0-071.v2022-02-20.q161; 85Oracle.Prepawaypdf.1z0-071.v2022-01-02.by.miles.211q.pdf

Latest Upload: 240PaloAltoNetworks.NGFW-Engineer.v2026-05-01.q43; 335Nokia.4A0-113.v2026-05-01.q69; 349EC-COUNCIL.312-49v11.v2026-04-30.q214; 273Microsoft.MB-820.v2026-04-30.q101; 238Salesforce.MC-202.v2026-04-30.q57; 250BICSI.INSTC_V8.v2026-04-29.q53; 370NMLS.MLO.v2026-04-28.q82; 267NCARB.Project-Management.v2026-04-28.q27; 484EMC.D-AV-DY-23.v2026-04-27.q184; 1241ServiceNow.CSA.v2026-04-27.q483

Question 116

Question 117

Question 118

Question 119

Question 120

Download PDF File