Free 1z0-074 Questions for Oracle Upgrade Oracle DBA 11g or 12c to 12c R2 1z0-074 Exam as PDF & Practice Test Engine

Exam Code/Number: 1z0-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: May 30, 2026

Question #1

Identify a situation where performance profiles can be used for application containers.

A. to specify the maximum percentage of the parallel execution server pool that a particular application container can use

B. to enforce a limit on the number of I/OS issued per second

C. to specify the total number of parallel execution servers available

D. to specify the maximum time, in seconds, that a parallel statement can wait in the parallel statement queue before it is timed out

E. to enforce a limit on I/O throughput per second

Discussion 0

Correct Answer: C Vote an answer

Question #2

Which three resources can be controlled or managed by using Oracle Database Resource Manager? (Choose three.)

A. maximum number of DML operations performed by a consumer group

B. UNDO quota for a consumer group

C. sessions that are blocking other sessions

D. sessions that are not blocking other sessions

E. number of parallel queries issued by a consumer group

Discussion 0

Correct Answer: B,C,E Vote an answer

Question #3

Which two statements are true about clean restore points in a regular PDB? (Choose two.)

A. They can be created only if shared undo is enabled

B. They are created as guaranteed restore points

C. They require backups to be restored when used in a PDB flashback operation

D. They require a clone instance to be created when used in a PDB flashback operation

E. They can be created for a PDB when connected to either the PDB or to the root

F. They can be created only for a PDB in the mount state

Discussion 0

Correct Answer: A,F Vote an answer

Question #4

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

A. clustered tables with dependent materialized views

B. heap tables with composite primary key constraints

C. index-organized tables stored in system-defined tablespaces

D. sys-owned objects stored in sysaux-defined tablespaces

E. heap tables with dependent materialized views

Discussion 0

Correct Answer: B,E Vote an answer

Question #5

Examine these steps to create a Transparent Sensitive Data Protection (TSDP) policy with unified auditing to protect sensitive data in certain table columns:
* Create a TSDP policy and define the audit parameter for the audited columns.
* Create a TSDP sensitive type using DBMS_TSDP_MANAGE.ADD_SENSITIVE_TYPE.
* Associate the TSDP policy with the sensitive type by using
DBMS_TSDP_PROTECT.ASSOCIATE_POLICY.
* Enable the TSDP policy at the sensitive type level.
* Associate the column to be audited to the sensitive type by using
DBMS_TSDP_MANAGE.ADD_SENSITIVE_COLUMN.
Identify the steps in the correct sequence.

A. 2, 5, 1, 3, 4

B. 1, 2, 3, 4, 5

C. 2, 1, 5, 3, 4

D. 1, 2, 4, 3, 5

E. 2, 1, 4, 5, 3

Discussion 0

Correct Answer: A Vote an answer

Question #6

Examine these parameters in a PFILE used to start database instance.

Which two statements are true after an instance restart is attempted and why? (Choose two.)

A. PGA_AGGREGATE_TARGET and SGA_TARGET remain 1G and 2G respectively.

B. The MEMORY_MAX_TARGET parameter is set to zero for the instance.

C. The instance does not start because AMM is enabled but PGA_AGGREGATE_TARGET and SGA_TARGET are set to nonzero values.

D. PGA_AGGREGATE_TARGET and SGA_TARGET are set to zero for the instance.

E. MEMORY_MAX_TARGET is automatically set to 4G for the instance.

Discussion 0

Correct Answer: B,E Vote an answer

Question #7

Which three database objects can have columns stored in the In-Memory (IM) column store? (Choose three.)

A. any SYS owned objects

B. materialized views

C. clustered tables

D. index-organized tables

E. heap tables

F. subpartitions

Discussion 0

Correct Answer: B,E,F Vote an answer

Question #8

The In-Memory compression level is set to MEMCOMPRESS FOR QUERY HIGH.
For what purpose is this optimized?

A. for query performance and space saving with greater bias toward space saving

B. for query performance and space saving

C. for query performance only

D. for space saving only

E. for parallel query performance only

Discussion 0

Correct Answer: B Vote an answer

Free 1z0-074 Questions for Oracle Upgrade Oracle DBA 11g or 12c to 12c R2 1z0-074 Exam as PDF & Practice Test Engine

Download Free Oracle 1z0-074 Demo