Free Download 1z0-072 Examp Dump: Oracle.1z0-072.PracticeTest.2019-06-19.34q.vcex

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

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 2

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

Question 3

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

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

Question 5

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

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 6

Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the MMON background process? (Choose three.)

AWR snapshots must be deleted when no longer required by ADDM.
ADDM can recommend shrinking the buffer cache.
By default, MMON creates an AWR snapshot every 30 minutes.
ADDM can recommend extending the buffer cache.
By default, AWR snapshots are automatically purged after eight days.
ADDM performs its analysis only whenever a DBA requests it.

Correct answer: BEF

Question 7

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

Question 8

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

Question 9

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

Question 10

Your database is configured for shared server and the SGA_TARGET parameter is set to a non-zero value.

Which three actions could help in handling a large number of concurrent users?

using Automatic SGA Memory Management (ASMM)
setting the LARGE_POOL_SIZE parameter to a non-zero value
increasing the size of the PGA
setting the SHARED_POOL_SIZE parameter to a non-zero value
increasing the number of dispatchers

Correct answer: BCD

Exam	Oracle Database 12cR2 Administration
Number	1z0-072
File Name	Oracle.1z0-072.PracticeTest.2019-06-19.34q.vcex
Size	25 KB
Posted	Jun 19, 2019
Download	Oracle.1z0-072.PracticeTest.2019-06-19.34q.vcex

Download Oracle.1z0-072.PracticeTest.2019-06-19.34q.vcex

File Info

How to open VCEX & EXAM Files?

Demo Questions