Oracle 1z1-074 Actual Free Exam Questions & Community Discussion

Exam Code/Number: 1z1-074
Exam Name/Title: Upgrade Oracle DBA 11g or 12c to 12c R2
Certification Provider: Oracle
Corresponding Certification: Oracle Database 12c R2

Exam Questions: 75
Updated On: Jul 05, 2026

Question #17

In which four situations does the RMAN DUPLICATE command use the "pull" method? (Choose four.)

A. when the USING BACKUPSET clause is used

B. when no auxiliary channels are allocated

C. when the number of auxiliary channels allocated is less than the number of target channels allocated

D. when IMAGE COPIES are used for the DUPLICATE operation

E. when the SET ENCRYPTION clause is added before the DUPLICATE command

F. when the USING COMPRESSED BACKUPSET clause is used

G. when the SECTION SIZE clause is used

Discussion 0

Correct Answer: A,C,F,G Vote an answer

Question #18

You create a new application container, SALES_APP, with application PDBs, SALES1_PDB, and SALES2_PDB.
You want to install the NEW_APP application in SALES1_PDB and SALES2_PDB by using:

Where should you execute these statements?

A. All the statements should be executed in the application seed.

B. All the statements should be executed in the application root.

C. All the statements should be executed in the SALES1_PDB and SALES2_PDB application containers.

D. BEGIN/END INSTALL statements should be executed in the CDB root and the SYNC statement in the application root.

E. BEGIN/END INSTALL statements should be executed in the application root and the SYNC statement in SALES1_PDB and SALES2_PDB.

Discussion 0

Correct Answer: B,E Vote an answer

Question #19

Which statement is true about policy expressions?

A. A named policy expression is stored in the Data Masking format library.

B. A policy expression can be applied to columns in different redacted tables.

C. A named policy expression applied to a column in a redacted table overrides the default expression of its redaction policy.

D. A named policy expression is stored in the Enterprise Manager Database Express repository.

E. A redacted table can have only one policy expression defined on it.

Discussion 0

Correct Answer: E Vote an answer

Question #20

One of your databases supports an OLTP workload.
If a better plan is discovered for a statement, then you want that plan to be used.
Which two can cause better plans to be used for a statement? (Choose two.)

A. SQL Performance Analyzer

B. using literals in SQL statements

C. adaptive cursor sharing

D. adaptive execution plans

E. SQL Access Advisor

Discussion 0

Correct Answer: D,E Vote an answer

Question #21

A multi-tenant container database (CDB) contains three PDBs.
Which three are prerequisites for performing a cross-platform transport of any of the PDBs? (Choose three.)

A. The CDB should be in MOUNT state.

B. Flashback database must be enabled for the CDB.

C. The COMPATIBLE parameter must be set to 12.2 or greater in the CDB.

D. The source PDBs must be closed for a cross-platform PDB backup.

E. The source and target platforms must have the same endianness.

F. The CDB must use Automatic Memory Management.

Discussion 0

Correct Answer: C,D,E Vote an answer

Question #22

Which three statements are true about the SQL Performance Analyzer? (Choose three.)

A. It generates execution plans for each SQL statement in an STS.

B. It always executes triggers that are fired recursively in FULLDML mode.

C. It compares and analyzes execution plans for the SQL statements in a SQL Tuning Set (STS).

D. It recommends the creation of indexes for regressed SQL statements.

E. It recommends the use of SQL Tuning Advisor for regressed SQL statements.

Discussion 0

Correct Answer: A,C,E Vote an answer

Question #23

Which statement is true about the Automatic Diagnostic Repository (ADR)?

A. Space used by the ADR can be limited to a user-specified value.

B. Space used by the ADR is limited based only on the retention period.

C. The retention period for the ADR is set based on the space limit specified.

D. When the ADR reaches the space limit, it deletes incident dumps and metadata before deleting old core dumps.

E. Manual purging of all types of ADR files is allowed.

Discussion 0

Correct Answer: E Vote an answer

Question #24

APP1 is an application container that has an application seed and two application PDBs, APP_PDB1 and APP_PDB2.
1.0 is the current version of the application.
You execute this block in the application root:

What is the outcome?

A. A common role is created only in the application root.

B. A common role is created in the application root, application seed, APP_PDB1, and APP_PDB2.

C. A common role is created only in the application root and application seed.

D. An error is thrown because the CONTAINER=ALL clause is missing.

E. An error is thrown because the c## prefix is missing in the role name.

F. An error is thrown because the version number should be sequential, either 1.1 or 2.0.

Discussion 0

Correct Answer: A Vote an answer

Download Free Oracle 1z1-074 Demo

Simply submit your e-mail address below to get started with our free demo of your Oracle 1z1-074 exam.