Exit demo 1Z0-074 Upgrade Oracle DBA 11g or 12c to 12c R2 PDF format · free preview

Oracle 1Z0-074 - Questions & Answers

Free preview · every answer includes a full explanation

Product page: https://prepkeys.com/1z0-074.html

Question 1
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.

Question 2
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.

Question 3
Single choice

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?

A.

It creates the /tmp/pdb_orcl.xml file, which contains the metadata and data of the source database.

B.

The backup fails because the UNPLUG operation for cross-endian platforms is not supported.

C.

It successfully takes a backup but the UNPLUG operation of PDB_ORCL fails.

D.

It successfully completes.

E.

It creates a backupset of the source database in the /home/oracle/backup directory

Question 4
Multiple choice

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

A.

loss of ARCHIVELOGS

B.

loss of a redo log member

C.

loss of a noncritical data file

D.

loss of all copies of the control file

E.

loss of a critical data file such as SYSTEM, SYSAUX or UNDO

F.

loss of SPFILE

Question 5
Single choice

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?

A.

An error is thrown because the version number should be sequential, either 1.1 or 2.0.

B.

An error is thrown because the CONTAINER=ALL clause is missing.

C.

An error is thrown because the c## prefix is missing in the role name.

D.

A common role is created only in the application root.

E.

A common role is created only in the application root and application seed.

F.

A common role is created in the application root, application seed, APP_PDB1, and APP_PDB2.

Question 6
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

Question 7
Multiple choice

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

A.

expdp scripts to export database objects belonging to the SYS schema

B.

a log file containing a list of pre-upgrade patches to be applied

C.

RMAN database backup scripts

D.

a log file with tool recommendations and requirements

E.

pre-and post-upgrade fixup scripts

Question 8
Multiple choice

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

A.

They require a clone instance to be created when used in a PDB flashback operation

B.

They can be created for a PDB when connected to either the PDB or to the root

C.

They require backups to be restored when used in a PDB flashback operation

D.

They are created as guaranteed restore points

E.

They can be created only if shared undo is enabled

F.

They can be created only for a PDB in the mount state

Question 9
Single choice

Which statement is true about transportable tablespaces?

A.

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.

B.

The cannot be dictionary-managed tablespaces

C.

The source tablespace can be encrypted

D.

They can be administrative tablespaces such as SYSTEM or SYSAUX

Question 10
Single choice

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?

A.

You can limit their PGA usage by setting SORT_AREA_SIZE to 200 MB.

B.

You cannot limit PGA for a set of database user sessions.

C.

You can limit their PGA usage by setting PGA_AGGREGATE_LIMIT to 200 MB.

D.

You can limit their PGA usage by setting PGA_AGGREGATE_TARGET to 200 MB.

E.

You can limit their PGA usage by setting the SESSION_PGA_LIMIT directive by using Database Resource Manager

Showing 10 of 75 questions · Unlock the full set