VCEdump

1Z0-072 Oracle Database 12cR2 Administration

PDF question preview Back to product

Reading controls

Reader tools

Free demo

14 of 87 questions

Purchase the full version to unlock every question and answer.

View the full question set

Preview tools

Try Web TestEngine

Question formats

Single choice5

Multiple choice9

Oracle · 1Z0-072

Free 1Z0-072 Exam Dumps Preview

Preview real exam questions, verified answers and available explanations before choosing a study plan.

Question 1

Multiple choice

DATADIR1 and DATADIR2 are database directory objects.

Examine this command:

Which two are true about the expdp operation? (Choose two.)

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

Reveal answer details Close answer details

Correct answersA, E

Explanation

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

Question 2

Single choice

In the ORCL database, DEFERRED_SEGMENT_CREATION is FALSE.

Examine this command:

Which table segments are created?

A
T1 and an index segment created for the primary key only
B
T1, an index segment for the primary key, a LOB segment, and lobindex segment
C
T1 only
D
T1, an index segment for the primary key, and a LOB segment only

Reveal answer details Close answer details

Correct answerD

Question 3

Multiple choice

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

Which three actions can HR perform? (Choose three.)

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

Reveal answer details Close answer details

Correct answersB, D, E

Explanation

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

Question 4

Multiple choice

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

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

Reveal answer details Close answer details

Correct answersA, D

Question 5

Single choice

The DATA tablespace uses Automatic Segment Space Management.

Examine this query and its output:

A block in EMP is 90% full.

At what percentage of free space will INSERT operations into the block again be possible?

A
10%
B
25%
C
50%
D
75%
E
90%

Reveal answer details Close answer details

Correct answerA

Explanation

References:
https://docs.oracle.com/cd/A57673_01/DOC/server/doc/SCN73/ch3.htm

Question 6

Multiple choice

Which two types of files are opened by a database instance in the NOMOUNT state?

A
control files
B
the alert log
C
the initialization parameter file
D
data files
E
online redo logs

Reveal answer details Close answer details

Correct answersC, D

Explanation

References:
http://www.dba-oracle.com/concepts/starting_database.htm

Question 7

Multiple choice

For which three purposes is UNDO used? (Choose three.)

A
flashback queries
B
B. FLASHBACK TABLE <tablename> TO BEFORE DROP operations
C
the roll forward phase of instance recovery
D
RESTORE DATABASE operations
E
ROLLBACK operations
F
read consistency

Reveal answer details Close answer details

Correct answersA, E, F

Explanation

References:
https://docs.oracle.com/cd/B28359_01/server.111/b28310/undo001.htm#ADMIN11460

Question 8

Single choice

Which is always true about privileges?

A
Connections as SYSTEM can use only the SYSOPER privilege.
B
Connections as SYS must be made using the SYSDBA privilege
C
System privileges can be granted only to users.
D
The owner of a schema is granted all object privileges within the schema by default.
E
The SYSDBA privilege can be granted to a user or role.

Reveal answer details Close answer details

Correct answerD

Explanation

A user automatically has all object privileges for schema objects contained in his or her schema. A user can grant any object privilege on any schema object he or she owns to any other user or role. A user with the GRANT ANY OBJECT PRIVILEGE can grant or revoke any specified object privilege to another user with or without the GRANT OPTION of the GRANT statement. Otherwise, the grantee can use the privilege, but cannot grant it to other users.

References:
https://docs.oracle.com/cd/B19306_01/network.102/b14266/authoriz.htm#i1010570

Question 9

Multiple choice

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

A
The ALTER USER statement must be used to set specific default roles for a user.
B
A role must be disabled before it can be revoked from a user.
C
The SET ROLE statement can be used once per session.
D
The SET ROLE statement enables as well as disables roles in a session.
E
All privileges and roles granted to a user are enabled by default when the user logs in.

Reveal answer details Close answer details

Correct answersD, E

Question 10

Multiple choice

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

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

Which two are true? (Choose two.)

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

Reveal answer details Close answer details

Correct answersD, E

Question 11

Multiple choice

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

A
FLASHBACK TRANSACTION can be used to undo the changes made by a committed transaction.
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 QUERY can be used to view committed data at any given point in time.

Reveal answer details Close answer details

Correct answersA, C, D

Question 12

Multiple choice

A user complains about poor database performance. You suspect that the user's session is waiting for an
event to complete.

You want to verify this.

Which two views may reveal for what the user's session is currently waiting? (Choose two.)

A
V$SYSTEM_EVENT
B
V$SESSION_EVENT
C
V$SESSION_WAIT_CLASS
D
V$SESSION_WAIT
E
V$SESSION

Reveal answer details Close answer details

Correct answersB, D

Explanation

References:
https://blogs.oracle.com/oraclemagazine/beginning-performance-tuning-diagnose-the-past

Question 13

Single choice

Which is true about revoking roles?

A
Only users who are granted the DBA role can revoke a role.
B
Only users who are granted SYSDBA can revoke a role.
C
Users who have the GRANT ANY ROLE privilege can revoke any role.
D
Users who are granted a role with ADMIN OPTION can revoke that role only from users to whom they have granted the role.
E
Users can revoke a role that is granted to them through other roles.

Reveal answer details Close answer details

Correct answerD

Explanation

References:
https://docs.oracle.com/cd/B28359_01/network.111/b28531/authorization.htm#DBSEG97970

Question 14

Single choice

Your client application and Oracle database are located on different hosts.

Which statement is true about establishing a connection between them?

A
Oracle Connection Manager must be installed on the client.
B
Net service names must be configured on both the client and database servers.
C
The Listener Control utility must be installed on the client if you are using the default listener on the server.
D
Only Oracle Net can be used.
E
Oracle Net Listener is required.

Reveal answer details Close answer details

Correct answerD

Explanation

References:
https://docs.oracle.com/cd/E25178_01/server.1111/e25789/dist_pro.htm

VOL	TYPE	QUESTIONS
1	Single choice	5
2	Multiple choice	9

Free 1Z0-072 Exam Dumps Preview

Oracle Database 12cR2 Administration

PREVIEW CONTENTS · 2 VOLUMES

QUESTION 1

QUESTION 2

QUESTION 3

QUESTION 4

QUESTION 5

QUESTION 6

QUESTION 7

QUESTION 8

QUESTION 9

QUESTION 10

QUESTION 11

QUESTION 12

QUESTION 13

QUESTION 14