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

Question 61

View the Exhibit and examine the structure of the CUSTOMERS and CUST_HISTORY tables.
The CUSTOMERS table contains the current location of all currently active customers.
The CUST_HISTORY table stores historical details relating to any changes in the location of all current as well as previous customers who are no longer active with the company.
You need to find those customers who have never changed their address.
Which SET operator would you use to get the required output?

A.INTERSECT

B.UNION

C.MINUS

D.UNION ALL

Question 62

Examine the structure of the BOOKS_TRANSACTIONStable.

You want to update this table such that BOOK_IDis set to 'INVALID'for all rows where no MEMBER_ID has been entered.
Examine this partial SQL statement:

Which condition must be used in the WHEREclause to perform the required update?
MEMBER_ID = '';

A.MEMBER_ID = NULL;

B.MEMBER_ID IS NULL;

C.MEMBER_ID = "";

Question 63

Examine the structure of the PROMOTIONS table: (Choose the best answer.)

Management requires a report of unique promotion costs in each promotion category.
Which query would satisfy this requirement?

A.SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1

B.SELECT DISTINCT promo_cost, promo_category FROM promotions

C.SELECT promo_category, DISTINCT promo_cost FROM promotions

D.SELECT DISTINCT promo_cost, DISTINCT promo_category FROM promotions;

Question 64

Which three statements about roles are true?

A.Roles are assigned to roles using the ALTER ROLE statement.

B.A single user can be assigned multiple roles.

C.Roles are assigned to users using the ALTER USER statement.

D.A single role can be assigned to multiple users.

E.Privileges are assigned to a role using the ALTER ROLE statement.

F.A role is a named group of related privileges that can only be assigned to a user.

G.Privileges are assigned to a role using the GRANT statement.

Question 65

You want to display 5 percent of the rows from the SALEStable for products with the lowest AMOUNT_SOLD and also want to include the rows that have the same AMOUNT_SOLDeven if this causes the output to exceed 5 percent of the rows.
Which query will provide the required result?

A.SELECT prod_id, cust_id, amount_sold
FROM sales
ORDER BY amount_sold
FETCH FIRST 5 PERCENT ROWS WITH TIES;

B.SELECT prod_id, cust_id, amount_sold
FROM sales
ORDER BY amount_sold
FETCH FIRST 5 PERCENT ROWS ONLY;

C.SELECT prod_id, cust_id, amount_sold
FROM sales
ORDER BY amount_sold
FETCH FIRST 5 PERCENT ROWS ONLY WITH TIES;

D.SELECT prod_id, cust_id, amount_sold
FROM sales
ORDER BY amount_sold
FETCH FIRST 5 PERCENT ROWS WITH TIES ONLY;

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

Latest Upload: 200PaloAltoNetworks.NGFW-Engineer.v2026-05-01.q43; 292Nokia.4A0-113.v2026-05-01.q69; 250EC-COUNCIL.312-49v11.v2026-04-30.q214; 227Microsoft.MB-820.v2026-04-30.q101; 207Salesforce.MC-202.v2026-04-30.q57; 203BICSI.INSTC_V8.v2026-04-29.q53; 332NMLS.MLO.v2026-04-28.q82; 241NCARB.Project-Management.v2026-04-28.q27; 454EMC.D-AV-DY-23.v2026-04-27.q184; 1107ServiceNow.CSA.v2026-04-27.q483

Question 61

Question 62

Question 63

Question 64

Question 65

Download PDF File