Free Oracle 1z0-074 Practice Test & Real Exam Questions

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: Jun 12, 2026

Question #1

In which two situations does the INHERIT ANY PRIVILIGES privilege regulate the privileges used?

A. when a user runs a procedure created with definer's right

B. when a user creates a new user

C. when a user runs a procedure created with invoker's right

D. when a user performs a GRANT or REVOKE operation

E. when a user queries a BEQUEATH CURRENT_USER view that references an invoker's right procedure

Discussion 0

Correct Answer: C,E Vote an answer

Question #2

Users BIXBY, RLAYTON, and MURDOK each have a table named CUST_RECORDS in their schema.
BIXBY has created a procedure, UPDATE_CUST, which updates the CUST_RECORDS table with invoker's right.
BIXBY grants the execute permission on UPDATE_CUST to the RLAYTON user.
When RLAYTON executes the UPDATE_CUST procedure, which table does the procedure attempt to update?

A. CUST_RECORDS table in Bixby's schema

B. CUST_RECORDS table in the schema of Bixby and Rlayton

C. CUST_RECORDS table in Rlayton's schema

D. CUST_RECORDS table in the schema of Bixby, Rlayton, and Murdok

E. CUST_RECORDS table in Murdok's schema

Discussion 0

Correct Answer: C Vote an answer

Question #3

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 except for those in the SYSTEM and SYSAUX tablespaces, and are stored in the SYSTEM tablespace.

B. They are collected only for the ORDERS table if it has an associated ADO policy.

C. They are collected for all segments and are stored in the SYSTEM tablespace.

D. They are collected for all segments and are stored in the SYSAUX tablespace.

E. They are collected for all segments except for those in the SYSTEM and SYSAUX tablespaces, and are stored in the SYSAUX tablespace.

Discussion 0

Correct Answer: C Vote an answer

Question #4

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. 1, 2, 4, 3, 5

B. 2, 5, 1, 3, 4

C. 1, 2, 3, 4, 5

D. 2, 1, 5, 3, 4

E. 2, 1, 4, 5, 3

Discussion 0

Correct Answer: B Vote an answer

Question #5

Which statement is true about policy expressions?

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

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

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

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

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

Discussion 0

Correct Answer: B Vote an answer

Question #6

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. BEGIN/END INSTALL statements should be executed in the CDB root and the SYNC statement in the application root.

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

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

D. All the statements should be executed 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: D,E Vote an answer

Question #7

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. a log file with tool recommendations and requirements

B. expdp scripts to export database objects belonging to the SYS schema

C. a log file containing a list of pre-upgrade patches to be applied

D. RMAN database backup scripts

E. pre- and post-upgrade fixup scripts

Discussion 0

Correct Answer: A,E Vote an answer

Question #8

While performing a cross-platform PDB transport in an Oracle Database 12c Release 2 database, by using XTTS from a Linux (x86-64) server to a Solaris (x86-64) server, this command is executed to back up the files in a compatible format:

What will be the outcome?

A. It creates the /tmp/pdb_orcl.xml file, which contains the metadata and data of the source database.

B. The backup fails because the UNPLUG operation for cross-endian platforms is not supported.

C. It successfully takes a backup but the UNPLUG operation of PDB_ORCL fails.

D. It successfully completes.

E. It creates a backupset of the source database in the /home/oracle/backup directory

Discussion 0

Correct Answer: E Vote an answer

Download Free Oracle 1z0-074 Demo

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