Oracle Upgrade Oracle DBA 11g or 12c to 12c R2 - 1z1-074 Exam Questions [2026]

QUESTION NO: 1
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 SALES1_PDB and SALES2_PDB application containers. B. BEGIN/END INSTALL statements should be executed in the application root and the SYNC statement in SALES1_PDB and SALES2_PDB. C. All the statements should be executed in the application seed. D. BEGIN/END INSTALL statements should be executed in the CDB root and the SYNC statement in the application root. E. All the statements should be executed in the application root.

Correct Answer: B,E

QUESTION NO: 2
Which two operations is the opc user authorized to perform in an Oracle Database Cloud environment?
(Choose two.)

A. Run all commands as root. B. Log in to the database deployment compute node. C. Only run some commands as oracle. D. Only run all commands as oracle. E. Run some commands as root.

Correct Answer: A,B

QUESTION NO: 3
Which two statements are true about a PDB lockdown profile? (Choose two.)

A. It is enabled in PDBs only after the CDB to which the PDBs belong is restarted. B. It is enabled by using the PDB_LOCKDOWN parameter in each PDBs where it needs to be applied. C. It is created by a common user with the SYSDBA privilege in CDB$ROOT. D. It is created by a local user with the SYSDBA privilege in each PDB where it needs to be applied. E. It is enabled by default on creation. F. It is created by a common user with the SYSDBA privilege in each PDB where it needs to be applied.

Correct Answer: B,C

QUESTION NO: 4
Identify two types of files that are generated by the Pre-Upgrade Information tool as part of the database upgrade prerequisite checks? (Choose two.)

A. expdp scripts to export database objects belonging to the SYS schema B. RMAN database backup scripts C. pre- and post-upgrade fixup scripts D. a log file with tool recommendations and requirements E. a log file containing a list of pre-upgrade patches to be applied

Correct Answer: C,D

QUESTION NO: 5
Which two are true about the ADR retention advisor in Oracle Database 12c Release 2? (Choose two.)

A. ESTIMATE (SIZEP_POLICY = 209715200) estimates the value of LONGP_POLICY. B. ESTIMATE (SHORTP_POLICY = 192, LONGP_POLICY = 2160) estimates the space requirement based on current ADR diagnostics file space usage. C. ESTIMATE (SIZEP_POLICY = 209715200) estimates only the long retention policy. D. ESTIMATE (SHORTP_POLICY = 192, LONGP_POLICY = 8760) provides estimates that users can use to set SIZEP_POLICY. E. ESTIMATE (SHORTP_POLICY = 192) estimates the space requirement based on the SHORTP_POLICY value of 192 minutes.

Correct Answer: A,D

QUESTION NO: 6
You plan to use Information Lifecycle Management (ILM) for the ORDERS table.
Which is true about Heat Map statistics when HEAT_MAP is ON?

A. They are collected for all segments and are stored in the SYSTEM tablespace. B. They are collected for all segments and are stored in the SYSAUX tablespace. C. They are collected only for the ORDERS table if it has an associated ADO policy. D. They are collected for all segments except for those in the SYSTEM and SYSAUX tablespaces, and are stored in the SYSTEM tablespace. E. They are collected for all segments except for those in the SYSTEM and SYSAUX tablespaces, and are stored in the SYSAUX tablespace.

Correct Answer: A

QUESTION NO: 7
You plan to execute this command:

Which statement is true and why?

A. It returns an error because only a single column key can be used for a list-partitioned table. B. It creates partitions P1 and P2 where COUNTRY is a single column partition key and CHANNEL is a subpartition key. C. It returns an error because the AUTOMATIC option must be specified. D. It creates partitions P1 and P2 where COUNTRY and CHANNEL are multi-column partition keys. E. It returns an error because only one set of multiple values can be specified for each partition.

Correct Answer: D

QUESTION NO: 8
Which three types of database objects can have their columns stored in the In-Memory column store? (Choose two.)

A. index-organized tables stored in system-defined tablespaces B. heap tables with dependent materialized views C. clustered tables with dependent materialized views D. sys-owned objects stored in sysaux-defined tablespaces E. heap tables with composite primary key constraints

Correct Answer: B,E