VCEdump

1Z0-074 Upgrade Oracle DBA 11g or 12c to 12c R2

PDF question preview Back to product

Reading controls

Reader tools

Free demo

12 of 75 questions

Purchase the full version to unlock every question and answer.

View the full question set

Preview tools

Try Web TestEngine

Question formats

Single choice7

Multiple choice5

Oracle · 1Z0-074

Free 1Z0-074 Exam Dumps Preview

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

Question 1

Single choice

You plan to execute this command:

Which statement is true and why?

A
It creates partitions P1 and P2 where COUNTRY is a single column partition key and CHANNEL is a subpartition key.
B
It returns an error because only one set of multiple values can be specified for each partition.
C
It returns an error because only a single column key can be used for a list-partitioned table.
D
It returns an error because the AUTOMATIC option must be specified.
E
It creates partitions P1 and P2 where COUNTRY and CHANNEL are multi-column partition keys.

Reveal answer details Close answer details

Correct answerE

Question 2

Single choice

You plan to use Information Lifecycle Management (ILM) for the ORDERS table.

Which is true about Heat Map statistics when HEAT_MAP is ON?

A
They are collected for all segments except for those in the SYSTEM and SYSAUX tablespaces, and are stored in the SYSTEM tablespace.
B
They are collected for all segments except for those in the SYSTEM and SYSAUX tablespaces, and are stored in the SYSAUX tablespace.
C
They are collected for all segments and are stored in the SYSAUX tablespace.
D
They are collected for all segments and are stored in the SYSTEM tablespace.
E
They are collected only for the ORDERS table if it has an associated ADO policy.

Reveal answer details Close answer details

Correct answerD

Question 3

Single choice

Examine these commands executed in the cdb1 container database:

Which statement is true about the c##USER1 account?

A
It is locked for two days after the password expires.
B
It is locked if the password is not changed within three weeks.
C
It is locked for 90 minutes after four failed login attempts.
D
It is locked after for consecutive failed login attempts.
E
It is not affected by the profile because the user has the SYSDBA privilege.

Reveal answer details Close answer details

Correct answerD

Question 4

Single choice

Examine this command:

Which statement is true?

A
Up to four worker processes are allocated to export data and metadata
B
Four worker processes are allocated to export only data
C
Four worker processes are active to export only metadata
D
Four worker processes are allocated to export data and metadata
E
Four worker processes are allocated when there is sufficient CPU available

Reveal answer details Close answer details

Correct answerD

Explanation

References:
https://oracle-base.com/articles/10g/oracle-data-pump-10g

Question 5

Multiple choice

Your CDB has a PDB, EMP_PDB.
You successfully execute these commands as the SYSTEM USER in CDB$ROOT:

Which two statements are true about C##USR1? (Choose two.)

A
It can connect to EMP_PDB and view the data only in tables created by common users.
B
It can connect to EMP_PDB but cannot view the data in any table in it.
C
It can connect only to the root.
D
It is a common user.
E
It is a local user.

Reveal answer details Close answer details

Correct answersA, E

Question 6

Multiple choice

Which two statements are true about FLEX ASM? (Choose two.)

A
A database instance on any node can connect to an ASM instance on any node.
B
A separate ASM network is required.
C
It is impossible to connect to a database instance on one node if the database password file for the same database is corrupt on another node in the cluster.
D
Database instances that depend on an ASM instance that is terminated fail over to a node that has a surviving ASM instance.
E
Database instances that depend on an ASM instance that is terminated connect to a surviving ASM instance.

Reveal answer details Close answer details

Correct answersD, E

Question 7

Single choice

Users BIXBY, RLAYTON, and MURDOK each have a table named CUST_RECORDS in their schema.
BIXBY has created a procedure, UPDATE_CUST, which updates the CUST_RECORDS table with invoker's right.
BIXBY grants the execute permission on UPDATE_CUST to the RLAYTON user.

When RLAYTON executes the UPDATE_CUST procedure, which table does the procedure attempt to update?

A
CUST_RECORDS table in Bixby's schema
B
CUST_RECORDS table in Murdok's schema
C
CUST_RECORDS table in Rlayton's schema
D
CUST_RECORDS table in the schema of Bixby and Rlayton
E
CUST_RECORDS table in the schema of Bixby, Rlayton, and Murdok

Reveal answer details Close answer details

Correct answerC

Question 8

Multiple choice

Which two statements are true about application containers? (Choose two.)

A
A regular PDB can be plugged in to an application container provided it is an Oracle Database 12c
Release 2 (12.2) PDB.
B
An application root can be unplugged from a CDB and plugged in to another CDB.
C
An application PDB can belong to multiple application containers.
D
User-created common objects are accessible from the CDB root.
E
The application root stores user-created common objects and Oracle-supplied common objects.
F
Multiple application roots can be created in one container database.

Reveal answer details Close answer details

Correct answersD, E

Explanation

References:
https://blogs.oracle.com/oraclemagazine/multitenant-database-management

Question 9

Single choice

Which method can be used to migrate from an on-premises Oracle Database 11g to Oracle Database 12c in the cloud if the on-premises platform is big-endian?

A
Oracle Loader-type external tables
B
remote cloning
C
RMAN Transportable Tablespace with Data Pump for all tablespaces
D
Data Pump Transportable Tablespace for all tablespaces
E
Data Pump Conventional Export/Import

Reveal answer details Close answer details

Correct answerC

Question 10

Multiple choice

To which two components does the term "shape" refer in Oracle Database Cloud Service (DBaaS)? (Choose two.)

A
number of network interface cards (NICs)
B
number of database instances
C
number of CPUs
D
amount of RAM
E
number of storage LUNs

Reveal answer details Close answer details

Correct answersC, D

Explanation

References:
https://cloud.oracle.com/database/faq

Question 11

Single choice

The In-Memory compression level is set to MEMCOMPRESS FOR QUERY HIGH.
For what purpose is this optimized?

A
for parallel query performance only
B
for query performance and space saving
C
for query performance and space saving with greater bias toward space saving
D
for query performance only
E
for space saving only

Reveal answer details Close answer details

Correct answerB

Explanation

References:
https://docs.oracle.com/database/121/REFRN/GUID-5772F775-2A3E-4BC8-AA03-B8FF383BEE52.htm#REFRN10350

Question 12

Multiple choice

Which three resources can be controlled or managed by using Oracle Database Resource Manager? (Choose three.)

A
number of parallel queries issued by a consumer group
B
maximum number of DML operations performed by a consumer group
C
sessions that are blocking other sessions
D
sessions that are not blocking other sessions
E
UNDO quota for a consumer group

Reveal answer details Close answer details

Correct answersA, C, E

VOL	TYPE	QUESTIONS
1	Single choice	7
2	Multiple choice	5

Free 1Z0-074 Exam Dumps Preview

Upgrade Oracle DBA 11g or 12c to 12c R2

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