Free Access Oracle.1z0-071.v2025-03-22.q314 Practice Test (Page 4)

View the exhibit and examine the structure of the CUSTOMERS table.

Which two tasks would require subqueries or joins to be executed in a single statement?

A.listing of customers who do not have a credit limit and were born before 1980

B.listing of those customers, whose credit limit is the same as the credit limit of customers residing in the city 'Tokyo'.

C.finding the number of customers, in each city, who's marital status is 'married'.

D.finding the number of customers, in each city, whose credit limit is more than the average credit limit of all the customers

E.finding the average credit limit of male customers residing in 'Tokyo' or 'Sydney'

Which two tasks require subqueries?

A.Display suppliers whose PROD_LIST_PRICE is less than 1000.

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

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

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

E.Display the minimum PROD_LIST_PRICE for each product status.

which three statements are true about indexes and their administration in an Oracle database?

A.IF a query filters on an indexed column then it will always be used during execution of query

B.A DROP INDEX statement always prevents updates to the table during the drop operation

C.AN INVISIBLE INDEX is not maintained when DML is performed on its underlying table.

D.The same table column can be part of a unique and non-unique index

E.AN INDEX CAN BE CREATED AS part of a CREATE TABLE statement

F.A DESCENDING INDEX IS A type of function-based index

Which statement correctly grants a system privilege?

A.GRANT ALTER TABLETO PUBLIC;

B.GRANT CREATE VIEWON table1 TOuser1;

C.GRANT CREATE SESSIONTO ALL;

D.GRANT CREATE TABLETO user1, user2;

Which three are true about the MERGE statement?

A.It can merge rows only from tables.

B.It can use views to produce source rows.

C.It can combine rows from multiple tables conditionally to insert into a single table.

D.It can use subqueries to produce source rows.

E.It can update the same row of the target table multiple times.

F.It can update, insert, or delete rows conditionally in multiple tables.

Other Version: 7352Oracle.1z0-071.v2024-10-24.q196; 3577Oracle.1z0-071.v2023-10-02.q276; 2936Oracle.1z0-071.v2023-05-08.q154; 7363Oracle.1z0-071.v2022-09-21.q298; 6088Oracle.1z0-071.v2022-08-30.q239; 25794Oracle.1z0-071.v2022-02-20.q161; 85Oracle.Prepawaypdf.1z0-071.v2022-01-02.by.miles.211q.pdf

Latest Upload: 175NAHQ.CPHQ.v2026-09-03.q481; 113SAP.C-S4CPB-2602.v2026-09-02.q7; 109Cisco.700-805.v2026-09-02.q86; 161MSSC.CLT-4.0.v2026-09-02.q43; 126Fitness.NCSF-CPT.v2026-09-02.q18; 174Google.Generative-AI-Leader.v2026-09-02.q77; 139PECB.ISO-14001-Lead-Auditor.v2026-09-01.q39; 126Google.GCP-DE.v2026-09-01.q27; 161Cisco.300-820.v2026-09-01.q105; 154Cisco.500-220.v2026-09-01.q72

Download PDF File