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:	Aug 09, 2026
# of views:	3035
Rating 100%

Page: 1 / 18
Total 88 questions

Question 1

In your database, you create a user, HR, and then execute this command:
GRANT CREATE SESSION TO hr WITH ADMIN OPTION;
Which three actions can HR perform? (Choose three.)

A.Execute DDL statements in the HR schema.
B.Revoke the CREATE SESSION privilege from other users.
C.Grant the CREATE SESSION privilege without ADMIN OPTION to other users.
D.Log in to the database instance.
E.Execute DML statements in the HR schema.
F.Grant the CREATE SESSION privilege with ADMIN OPTION to other users.

Question 2

Which two are true about conventional path SQL load? (Choose two.)

A.It locks objects being processed.
B.It does not generate UNDO.
C.It cannot load data into clustered tables.
D.It always generates redo.
E.It enforces referential integrity constraints.

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.Add the NOLOGGING clause.
B.Remove the ONLINE clause.
C.Add the EXTENT MANAGEMENT LOCAL UNIFORM clause.
D.Add MAXSIZE for the AUTOEXTEND ON clause.
E.Remove the AUTOEXTEND ON clause.
F.Remove the SEGMENT MANAGEMENT AUTO clause.

Question 4

DATADIR1 and DATADIR2 are database directory objects.
Examine this command:
[oracle@host01 ~] expdp system/oracle \
> FULL=y \
> DUMPFILE=datadir1:full%U.dmp, datadir2: full2%U.dmp \
> FILESIZE=2G \
> PARALLEL=4 \
> LOGFILE= datadir1:/expfull.log
> JOB_NAME= expfull
Which two are true about the expdp operation? (Choose two.)

A.It creates a master table to store details of the export operation.
B.It creates a dump file only for objects in the SYSTEM schema.
C.It creates a dump file for the entire database.
D.It starts only when four worker processes are available.
E.It fails if the total size of the dump file is more than 2 GB.

Question 5

Which three are true about Oracle Database backup taken with RMAN?

A.RMAN always includes the control file in a backup.
B.A full backup contains all data blocks from one or more data files.
C.An RMAN image copy can be written only to disk.
D.RMAN cannot backup REDO logs.
E.Only offline backup are consistent.
F.A whole backup contains all data blocks of all data files.