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

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

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

Correct answer: DE

Explanation:

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

From which two failure scenarios can a database be restored and recovered with the REPAIR DATABASE command? (Choose two.)

loss of ARCHIVELOGS
loss of a redo log member
loss of a noncritical data file
loss of all copies of the control file
loss of a critical data file such as SYSTEM, SYSAUX or UNDO
loss of SPFILE

Correct answer: DE

Explanation:

Reference: https://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta033.htm#RCMRF199

Identify two types of files that are generated by the Pre-Upgrade Information tool as part of the database upgrade prerequisite checks? (Choose two.)

expdp scripts to export database objects belonging to the SYS schema
a log file containing a list of pre-upgrade patches to be applied
RMAN database backup scripts
a log file with tool recommendations and requirements
pre- and post-upgrade fixup scripts

Correct answer: DE

Explanation:

Reference: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/upgrd/using-preupgrade-information-tool-for-oracle-database.html#GUID-C0219AF1-AD43-4097-B358-E53E48958647

Which two statements are true about clean restore points in a regular PDB? (Choose two.)

They require a clone instance to be created when used in a PDB flashback operation
They can be created for a PDB when connected to either the PDB or to the root
They require backups to be restored when used in a PDB flashback operation
They are created as guaranteed restore points
They can be created only if shared undo is enabled
They can be created only for a PDB in the mount state

Correct answer: EF

Explanation:

Reference: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/bradv/using-flasback-database-restore-points.html

Which statement is true about transportable tablespaces?

The tablespace data file or data files to be plugged in to the target database cannot have a different block size than any of the source database’s data file or files.
The cannot be dictionary-managed tablespaces
The source tablespace can be encrypted
They can be administrative tablespaces such as SYSTEM or SYSAUX

Correct answer: A

In your database, DEFERRED_SEGMENT_CREATION is set to TRUE.

You successfully execute this command:

Which statement is true about the space allocated to the SALES_2016 table?

Two subpartitions are allocated to the q1_2016 partition when the first row is inserted into q1_2016.
A single subpartition is allocated to the q1_2016 partition when the first row is inserted into q1_2016.
Separate segments are allocated to the q1_2016 partition and each of its subpartitions when the first row is inserted into q1_2016.
A segment is allocated to the q1_2016 partition but not its subpartitions at table creation.
A single segment is allocated to the q1_2016 partition and its subpartitions at table creation.

Correct answer: A

Which two are true about the ADR retention advisor in Oracle Database 12c Release 2? (Choose two.)

ESTIMATE (SHORTP_POLICY = 192) estimates the space requirement based on the SHORTP_POLICY value of 192 minutes.
ESTIMATE (SHORTP_POLICY = 192, LONGP_POLICY = 2160) estimates the space requirement based on current ADR diagnostics file space usage.
ESTIMATE (SIZEP_POLICY = 209715200) estimates only the long retention policy.
ESTIMATE (SHORTP_POLICY = 192, LONGP_POLICY = 8760) provides estimates that users can use to set SIZEP_POLICY.
ESTIMATE (SIZEP_POLICY = 209715200) estimates the value of LONGP_POLICY.

Correct answer: DE

The TESTDB container database (CDB) contains two pluggable databases (PDBs), PDB1 and PDB2.

USER1 is a local user in PDB1 and has the SYSBACKUP privilege.

Connect descriptors for PDB1 and PDB2 are mapped to TNS aliases pdb1 and PDB2 in tnsnames.ora.

Examine these commands executed by USER1 when all PDBs are open:

What is the outcome and why?

An error is returned because the user is connected to a pluggable database.
The current date is displayed.
An error is returned because SQL commands cannot be executed from RMAN without using the SQL shell syntax: SQL”<command>”.
An error is returned because the user is not SYS.
An error is returned because the user is not a common user.

Correct answer: C

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

number of network interface cards (NICs)
number of database instances
number of CPUs
amount of RAM
number of storage LUNs

Correct answer: CD

Explanation:

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

Examine these statements executed in the PROD1 database:

Which statements are audited?

only the CREATE USER statement
only the ALTER SYSTEM statements
only the CREATE USER statement and the first change to JOB_QUEUE_PROCESSES
only the changes to JOB_QUEUE_PROCESSES and the CREATE USER statement
all the statements

Correct answer: D

Vendor:	Oracle
Exam Code:	1z0-074
Exam Name:	Upgrade Oracle DBA 11g or 12c to 12c R2
Date:	Jun 10, 2019
File Size:	771 KB

Download Upgrade Oracle DBA 11g or 12c to 12c R2.1z0-074.TestKing.2019-06-10.45q.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