Free Access Oracle.1z0-071.v2022-08-30.q239 Practice Test (Page 32)

Question 151

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

CUSTOMER_VU is a view based on CUSTOMERS_BR1 table which has the same structure as CUSTOMERS table.
CUSTOMERS need to be updated to reflect the latest information about the customers.
What is the error in the following MERGE statement?

A.The INTO clause is misplaced in the command.

B.The CUSTOMER_ID column cannot be updated.

C.The WHERE clause cannot be used with INSERT.

D.CUSTOMER_VU cannot be used as a data source.

Question 152

Examine the description of the EMPLOYEEStable:

Which two queries return all the rows for employees whose salary is greater than the average salary in their department? (Choose two.)

Question 153

Which two statements are true regarding single row functions? (Choose two.)

A.MOD : returns the quotient of a division.

B.TRUNC : can be used with NUMBER and DATE values.

C.CONCAT : can be used to combine any number of values.

D.SYSDATE : returns the database server current date and time.

E.INSTR : can be used to find only the first occurrence of a character in a string.

F.TRIM : can be used to remove all the occurrences of a character from a string.

Question 154

Which three are true about system and object privileges? (Choose three.)

A.WITH GRANT OPTION can be used when granting an object privilege to both users and roles

B.Adding a primary key constraint to an existing table in another schema requires a system privilege

C.Adding a foreign key constraint pointing to a table in another schema requires the REFERENCES object privilege

D.Revoking a system privilege that was granted with WITH ADMIN OPTION has a cascading effect

E.Revoking an object privilege that was granted with the WITH GRANT OPTION clause has a cascading effect.

F.WITH GRANT OPTION cannot be used when granting an object privilege to PUBLIC

Question 155

Which three statements are true about GLOBAL TEMPORARY TABLES?

A.A GLOBAL TEMPORARY TABLE's definition is available to multiple sessions.

B.GLOBAL TEMPORARY TABLE space allocation occurs at session start.

C.Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.

D.GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.

E.A TRUNCATE command issued in a session causes all rows In a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.

F.A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.

Other Version: 4127Oracle.1z0-071.v2025-03-22.q314; 7455Oracle.1z0-071.v2024-10-24.q196; 3660Oracle.1z0-071.v2023-10-02.q276; 3039Oracle.1z0-071.v2023-05-08.q154; 7492Oracle.1z0-071.v2022-09-21.q298; 25889Oracle.1z0-071.v2022-02-20.q161; 85Oracle.Prepawaypdf.1z0-071.v2022-01-02.by.miles.211q.pdf

Latest Upload: 124Adobe.AD0-E911.v2026-09-12.q35; 117Google.ADP.v2026-09-11.q22; 131AIChE.CCPSC.v2026-09-11.q41; 131Scrum.PSPO-III.v2026-09-10.q23; 220Scrum.PSPO-I.v2026-09-09.q157; 188ScaledAgile.SAFe-SPC.v2026-09-08.q108; 147Oracle.1Z0-1033-26.v2026-09-08.q43; 220Pegasystems.PEGACPSSA25V1.v2026-09-08.q144; 168BCI.CBCI.v2026-09-07.q89; 212Salesforce.Plat-Admn-202.v2026-09-07.q170

Question 151

Question 152

Question 153

Question 154

Question 155

Download PDF File