Free Oracle 1Z0-072 Exam Dumps Questions & Answers


Exam Code/Number:	1Z0-072Join the discussion
Exam Name:	Oracle Database 12cR2 Administration
Certification:	Oracle
Free Question Number:	88
Publish Date:	Oct 03, 2026
# of views:	3213
Rating 100%

Page: 1 / 18
Total 88 questions

Question 1

Which two backup configurations are set by default when you choose Cloud Storage Only as the backup destination? (Choose two.)

A.encryption for all backups
B.on-demand backups that need to be scheduled
C.encryption of backups only for Enterprise Edition databases
D.RMAN incremental backups in a seven-day cycle
E.encryption of backups only for High Performance and Extreme Performance database versions
F.automatic daily full database backups

Question 2

Which is true about roles?

A.A role can be password-protected only if it has been granted system privileges.
B.All roles belong to the SYSTEM schema.
C.Roles containing object privileges can be created only by the object owner.
D.Roles can be created only by SYS or SYSTEM.
E.A role can be granted to other roles.

Question 3

Examine this command:
CREATE TEMPORARY TABLESPACE temp_tbs
TEMPFILE 'temp01.dbf' SIZE 10M AUTOEXTEND ON
ONLINE
SEGMENT MANAGEMENT AUTO;
Which two changes must you make so that TEMP_TBS is created? (Choose two.)

A.Remove the AUTOEXTEND ON clause.
B.Remove the ONLINE clause.
C.Remove the SEGMENT MANAGEMENT AUTO clause.
D.Add MAXSIZE for the AUTOEXTEND ON clause.
E.Add the NOLOGGING clause.
F.Add the EXTENT MANAGEMENT LOCAL UNIFORM clause.

Question 4

Which two are true about roles? (Choose two.)

A.A role must be disabled before it can be revoked from a user.
B.The SET ROLE statement enables as well as disables roles in a session.
C.All privileges and roles granted to a user are enabled by default when the user logs in.
D.The SET ROLE statement can be used once per session.
E.The ALTER USER statement must be used to set specific default roles for a user.

Question 5

Which three actions are required to manually upgrade a database to Oracle Database 12c Release 2? (Choose three.)

A.Run the Parallel Upgrade utility from the new Oracle home.
B.Copy the network configuration files from the existing database home to the new Oracle home location.
C.Start the existing database in upgrade mode.
D.Run Oracle Net Configuration Assistant (NETCA) to configure the listening protocol address and service information for the new release of Oracle Database.
E.Make all user tablespaces "read only" before starting the upgrade.
F.Run the Pre-Upgrade information tool on the source database.
G.Take all user tablespaces offline before starting the upgrade.