Oracle 1z1-072 Actual Free Exam Questions & Community Discussion

Exam Code/Number: 1z1-072
Exam Name/Title: Oracle Database 12cR2 Administration
Certification Provider: Oracle
Corresponding Certification: Oracle Database 12c R2

Exam Questions: 88
Updated On: Oct 07, 2026

Question #1

You execute this command to connect to an instance from a client on a different machine:
CONNECT username/password@net_service_name
No name servers are configured.
Which two are true about net_service_name? (Choose two.)

A. It must contain the address protocol for only one listener.

B. It must contain only one address protocol for one listener.

C. It must have the same name as the SERVICE_NAME defined in it.

D. It must be defined in the tnsnames.ora file on the client side.

E. It must be defined in the tnsnames.ora file on the server side.

Discussion 0

Correct Answer: C,E Vote an answer

Question #2

Which three failures require intervention for recovery? (Choose three.)

A. media failure

B. statement failure

C. network interface card (NIC) failure

D. user process failure

E. a user error such as dropping the wrong table

Discussion 0

Correct Answer: A,D,E Vote an answer

Question #3

Which is true about unexpired undo?

A. It is the first type of undo overwritten when trying to avoid out-of-space errors.

B. It is required when a transaction rolls back.

C. It may be used to support flashback queries.

D. It consists of undo only for uncommitted transactions.

E. It is always retained for the time specified in UNDO__RETENTION.

Discussion 0

Correct Answer: E Vote an answer

Question #4

Which two are true about incomplete recovery? (Choose two.)

A. The database must have FLASHBACK enabled in order to perform it.

B. Only RMAN backupsets can be used to restore a database as part of it.

C. Incremental backups cannot be used to roll forward the database while performing it.

D. It is possible only when the database is in MOUNT state.

E. Uncommitted transactions will be rolled back after it completes.

Discussion 0

Correct Answer: A,B Vote an answer

Question #5

Examine these commands:

What is the expected result?

A. It fails because EMP.DAT has some records with more than three characters corresponding to U1.EMP.ENAME.

B. All rows in EMP.DAT are inserted into U1.EMP but ENAME is set to ### for the second and third rows.

C. Only the first and fourth rows in EMP.DAT are inserted into U1.EMP.

D. Only the first row in EMP.DAT is inserted into U1.EMP.

E. All rows in EMP.DAT are inserted into U1.EMP but ENAME is set to NULL for the second and third rows.

Discussion 0

Correct Answer: B Vote an answer

Question #6

Which is true about the UNLIMITED TABLESPACE SYSTEM privilege?

A. It is overridden by any specified user space quota.

B. It can be revoked from a user and replaced with a specific space quota only if no user schema objects exist.

C. It can be granted to any user and any role.

D. It allows a user to have unlimited space in any tablespace in the database.

E. It allows a user to have unlimited space only in his or her default permanent tablespace.

Discussion 0

Correct Answer: D Vote an answer

Question #7

What three are true about Oracle Flashback technology? (Choose three.)

A. FLASHBACK QUERY can be used to view committed data at any given point in time.

B. FLASHBACK TABLE can be used to rewind a table back in time.

C. FLASHBACK DATABASE can be used to rewind a database back and forth in time.

D. FLASHBACK TABLE can be used to undo dropping a column from a table.

E. FLASHBACK TRANSACTION can be used to undo the changes made by a committed transaction.

Discussion 0

Correct Answer: C,D,E Vote an answer

Question #8

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

A. The SET ROLE statement enables as well as disables roles in a session.

B. All privileges and roles granted to a user are enabled by default when the user logs in.

C. The SET ROLE statement can be used once per session.

D. A role must be disabled before it can be revoked from a user.

E. The ALTER USER statement must be used to set specific default roles for a user.

Discussion 0

Correct Answer: A,B Vote an answer

Question #9

In the ORCL database, USER1 has unlimited quota on TBS1 and TBS2.
The USER1.EMP table with primary key EMP_ENO_PK resides in TBS1.
USER1.EMP_IDX residing in TBS2 is an index on U1.EMP.ENAME.
TBS1 is exported from ORCL by using this command:
[oracle@host01 ~]$ expdp system/oracle tablespace=tbs1 directory=exp_dir dumpfile=tbs1.dmp The TESTDB database has a TBS1 tablespace but no TBS2.
The SYSTEM user in TESTDB executes this command:
[oracle@host01 ~]$ impdp system/oracle directory=exp_dir dumpfile=u1.dmp tablespace=tbs1 What is the result and why?

A. It imports only EMP, EMP_ENO_PK, and the unique index associated with EMP_ENO_PK.

B. It imports only EMP.

C. It fails because TESTDB does not have TBS2 to create EMP_IDX.

D. It imports EMP, EMP_ENO_PK, and the unique index associated with EMP_ENO_PK and EMP_IDX.

E. It fails because TESTDB has TBS1.

Discussion 0

Correct Answer: A Vote an answer

Download Free Oracle 1z1-072 Demo

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