Free Download 1z0-072 Examp Dump: Oracle.1z0-072.RealTests.2019-10-15.48q.vcex

Question 1

The ORCL database has DEFERRED_SEGMENT_CREATION set to TRUE.

UNDOTBS2 is the active undo tablespace.

Examine these commands:

USER1 executes DML, which generates more than 2 MB of UNDO.

What is the result and why?

It suspends the transaction, which can be resumed by increasing the size of UNDOTBS2.
It returns an error because UNDOTBS2 is fixed size and has RETENTION GUARANTEE.
It suspends the transaction, which can be resumed by increasing USER1’s quota on UNDOTBS2.
It returns an error because UNDOTBS2 has RETENTION GUARANTEE.
It suspends the transaction, which can be resumed by setting UNDOTBS1 as the active undo tablespace.
It returns an error because UNDOTBS2 is fixed size.

Correct answer: F

Question 2

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

Question 3

Which three are true about Oracle Managed Files (OMF)? (Choose three.)

If DB_CREATE_FILE_DEST is specified but DB_CREATE_ONLINE_LOG_DEST_n is not, the redo logs and control files are placed in DB_CREATE_FILE_DEST by default.
If DB_RECOVERY_FILE_DEST is specified, at least two different locations must be specified for DB_CREATE_ONLINE_LOG_DEST_n.
If only DB_CREATE_FILE_DEST is specified, only the data files and temp files are OMF.
If DB_RECOVERY_FILE_DEST is specified but DB_CREATE_ONLINE_LOG_DEST_n is not, the redo logs and control files are placed in DB_RECOVERY_FILE_DEST by default.
If DB_CREATE_ONLINE_LOG_DEST_1 is specified but DB_CREATE_FILE_DEST is not, the data files and temp files are placed in DB_CREATE_ONLINE_LOG_DEST_1 by default.
If only DB_CREATE_ONLINE_LOG_DEST_n is specified, only the redo logs and control files are OMF.

Correct answer: ABF

Question 4

In your database, you create a user, HR, and then execute this command:

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

Question 5

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

Examine this command:

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

Question 6

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

Question 7

Which statement is true about smallfile tablespaces?

Extent location metadata is stored in the data dictionary by default.
The number of data files is constrained only by the size of the storage array.
Maximum file size can be set to unlimited only if the logical volume manager supports striping.
Segments can span multiple tablespaces.
Segments can span multiple data files.

Correct answer: E

Explanation:

Reference: https://docs.oracle.com/database/121/CNCPT/logical.htm

Question 8

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

Question 9

Examine this command:

Which two changes must you make so that TEMP_TBS is created? (Choose two.)

Add the EXTENT MANAGEMENT LOCAL UNIFORM clause.
Add the NOLOGGING clause.
Remove the SEGMENT MANAGEMENT AUTO clause.
Remove the AUTOEXTEND ON clause.
Remove the ONLINE clause.
Add MAXSIZE for the AUTOEXTEND ON clause.

Correct answer: AF

Explanation:

Reference: https://asktom.oracle.com/pls/asktom/f?p=100:11:::::P11_QUESTION_ID:374218170986

Question 10

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

FLASHBACK TRANSACTION can be used to undo the changes made by a committed transaction.
FLASHBACK TABLE can be used to rewind a table back in time.
FLASHBACK DATABASE can be used to rewind a database back and forth in time.
FLASHBACK TABLE can be used to undo dropping a column from a table.
FLASHBACK QUERY can be used to view committed data at any given point in time.

Correct answer: ACD

Exam	Oracle Database 12cR2 Administration
Number	1z0-072
File Name	Oracle.1z0-072.RealTests.2019-10-15.48q.vcex
Size	833 KB
Posted	Oct 15, 2019
Download	Oracle.1z0-072.RealTests.2019-10-15.48q.vcex

Download Oracle.1z0-072.RealTests.2019-10-15.48q.vcex

File Info

How to open VCEX & EXAM Files?

Demo Questions