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

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

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

Correct answer: AE

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

While performing a cross-platform PDB transport in an Oracle Database 12c Release 2 database, by using XTTS from a Linux (x86-64) server to a Solaris (x86-64) server, this command is executed to back up the files in a compatible format:

What will be the outcome?

It creates the /tmp/pdb_orcl.xml file, which contains the metadata and data of the source database.
The backup fails because the UNPLUG operation for cross-endian platforms is not supported.
It successfully takes a backup but the UNPLUG operation of PDB_ORCL fails.
It successfully completes.
It creates a backupset of the source database in the /home/oracle/backup directory

Correct answer: E

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

APP1 is an application container that has an application seed and two application PDBs, APP_PDB1 and APP_PDB2.

1.0 is the current version of the application.

You execute this block in the application root:

What is the outcome?

An error is thrown because the version number should be sequential, either 1.1 or 2.0.
An error is thrown because the CONTAINER=ALL clause is missing.
An error is thrown because the c## prefix is missing in the role name.
A common role is created only in the application root.
A common role is created only in the application root and application seed.
A common role is created in the application root, application seed, APP_PDB1, and APP_PDB2.

Correct answer: D

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?

CUST_RECORDS table in Bixby’s schema
CUST_RECORDS table in Murdok’s schema
CUST_RECORDS table in Rlayton’s schema
CUST_RECORDS table in the schema of Bixby and Rlayton
CUST_RECORDS table in the schema of Bixby, Rlayton, and Murdok

Correct answer: C

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

You want to restrict PGA usage to 200 MB for a set of database users’ sessions as part of your organization’s security requirements for combating denial of service (DOS) attacks.

Which statement is true about limiting PGA usage for those users’ sessions?

You can limit their PGA usage by setting SORT_AREA_SIZE to 200 MB.
You cannot limit PGA for a set of database user sessions.
You can limit their PGA usage by setting PGA_AGGREGATE_LIMIT to 200 MB.
You can limit their PGA usage by setting PGA_AGGREGATE_TARGET to 200 MB.
You can limit their PGA usage by setting the SESSION_PGA_LIMIT directive by using Database Resource Manager

Correct answer: C

Explanation:

Reference: https://oracle-base.com/articles/12c/pga_aggregate_limit_12cR1

Vendor:	Oracle
Exam Code:	1z0-074
Exam Name:	Upgrade Oracle DBA 11g or 12c to 12c R2
Date:	Mar 25, 2019
File Size:	1 MB

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