Free Oracle 1z1-074 Exam Dumps Questions & Answers


Exam Code/Number:	1z1-074Join the discussion
Exam Name:	Upgrade Oracle DBA 11g or 12c to 12c R2
Certification:	Oracle
Free Question Number:	75
Publish Date:	Aug 14, 2026
# of views:	2380
Rating 100%

Page: 1 / 15
Total 75 questions

Question 1

In a Database Cloud Service (DBCS) environment, which pre-created user has sudo privileges to run certain root commands?

A.oracle
B.opc
C.grid
D.nobody
E.oinstall

Question 2

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, 1, 5, 3, 4
B.2, 5, 1, 3, 4
C.2, 1, 4, 5, 3
D.1, 2, 3, 4, 5
E.1, 2, 4, 3, 5

Question 3

Which two are true about tables recovered by using the RMAN RECOVER TABLE command or the command itself, starting from Oracle Database 12c Release 2? (Choose two.)

A.They may be recovered to a different schema in the same pluggable database (PDB)
B.An AUXILIARY instance is started only if there is sufficient disk space
C.They may be recovered to a schema in a different PDB
D.They can be recovered by RMAN without an AUXILIARY instance
E.They must be un-partitioned tables

Question 4

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

A.to enforce a limit on the number of I/OS issued per second
B.to specify the maximum time, in seconds, that a parallel statement can wait in the parallel statement queue before it is timed out
C.to specify the total number of parallel execution servers available
D.to specify the maximum percentage of the parallel execution server pool that a particular application container can use
E.to enforce a limit on I/O throughput per second

Question 5

Identify two operations for which the bkup_api utility can be used. (Choose two.)

A.to define which system files are backed up
B.to define the retention period for backups
C.to define the cycle period for backups
D.to define the frequency of automatic backups
E.to define which database configuration files are backed up