1z0-072: Oracle Database 12cR2 Administration - Free download from Exam Files

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

a user error such as dropping the wrong table
network interface card (NIC) failure
user process failure
statement failure
media failure

Correct answer: ACE

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?

It imports EMP, EMP_ENO_PK, and the unique index associated with EMP_ENO_PK and EMP_IDX.
It imports only EMP, EMP_ENO_PK, and the unique index associated with EMP_ENO_PK.
It fails because TESTDB has TBS1.
It imports only EMP.
It fails because TESTDB does not have TBS2 to create EMP_IDX.

Correct answer: B

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.)

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

Correct answer: BDE

Explanation:

Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9013.htm

TBS1 is a permanent user-defined tablespace created with Oracle Managed Files (OMF).

Examine this command:

DROP TABLESPACE tbs1;

Which is required to ensure that TBS1 is dropped and its datafiles are deleted from their file system?

The INCLUDING CONTENTS AND DATAFILES clause must be added to the command.
TBS1 must be placed in READ ONLY state.
Objects in TBS1 must not be in use when the command is executed.
TBS1 must not contain any temp files.
DB_CREATE_FILE_DEST must refer to an Oracle Automatic Storage Management (ASM)disk group.

Correct answer: A

Explanation:

Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9004.htm

Which three types of files are created by expdp operations? (Choose three.)

SQL files
dump files
reject files
log files
input data files
bad files
control files

Correct answer: ABD

Explanation:

Reference: https://docs.oracle.com/cd/B28359_01/server.111/b28319/dp_export.htm#g1022624

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.)

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

Correct answer: AE

Explanation:

Reference: https://docs.oracle.com/database/121/SUTIL/GUID-1E134053-692A-4386-BB77-153CB4A6071A.htm#SUTIL887

Which two are true about RETENTION GUARANTEE? (Choose two.)

It is a tablespace attribute.
It prevents FLASHBACK DATABASE operation failure.
It prevents out-of-space errors.
It prevents “Snapshot too old” errors.
It is a static parameter.

Correct answer: AB

Which two can you use to recover a dropped table? (Choose two.)

FLASHBACK QUERY
FLASHBACK DATABASE
FLASHBACK TRANSACTION
FLASHBACK TABLE TO SCN
FLASHBACK DROP

Correct answer: DE

Explanation:

Reference: https://docs.oracle.com/database/121/ADMQS/GUID-1DE547D1-3AF0-4269-8BAA-4C298EC05905.htm#GUID-1DE547D1-3AF0-4269-8BAA-4C298EC05905

orcl.dmp contains a full export of the ORCL database.

This command is executed to load data from orcl.dmp into the TESTDB database:

[oracle@host01 ~] impdp system/oracle \

> SHEMAS=sh,oe \

> REMAP_SCHEMA=sh:hr \

> DUMPFILE=orcl.dmp \

> EXCLUDE=index \

> TABLE_EXISTS_ACTION=replace \

> LOGFILE=impdp.log

Which two are true? (Choose two.)

It skips only tables that exist in both ORCL:SH and TESTDB:HR.
It drops and recreates tables that exist in both ORCL:SH and TESTDB:HR.
It skips all indexes of ORCL:SH and ORCL:OE.
It skips only indexes that exist in both ORCL:SH and TESTDB:HR.
It drops and re-creates indexes that exist in both ORCL:SH and TESTDB:HR.

Correct answer: DE

Which is true about roles?

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

Correct answer: E

Vendor:	Oracle
Exam Code:	1z0-072
Exam Name:	Oracle Database 12cR2 Administration
Date:	Jun 04, 2019
File Size:	449 KB

Download Oracle Database 12cR2 Administration.1z0-072.CertKiller.2019-06-04.33q.vcex

How to open VCEX files?

Demo Questions

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

ProfExam at a 20% markdown