1z0-083 Practice Test

Examine this configuration:
1.The ORCL database data files are in Automatic Storage Management (Oracle ASM) disk group +DATA.
2.ORCL uses disk group +FRAfor the Fast Recovery Area.
3.LISTENER is the listener for ORCL.
4.The database, listener, ASM instance, and ASM disk groups are managed by Oracle Restart.
5.All components are currently shut down.
You execute this command:

What is the outcome?

A.

The ORCL database, the Oracle ASM instances, the +DATA and +FRA disk groups, and the
LISTENER
are started.

B.

Only the ORCL database instance is started.

C.

Only the ORCL database and the ASM instances are started

D.

Only the ORCL database instance, the Oracle ASM instance, and the +DATA and +FRA disk groups
are started.

E.

Only the ORCL database instance and the +DATA and +FRA disk groups are started.

Which two are true about Rapid Home Provisioning (RHP), which has been available since Orcale 18c?
(Choose two.)

A.

It is an Oracle Database service

B.

It cannot be usedto upgrade Oracle Database homes.

C.

It can be used to provision applications

D.

It can be used to patch Grid Infrastructure homes containing Oracle Restart.

E.

It can be used to provision middleware.

Which three are true about upgrading Oracle Grid Infrastructure? (Choose three.)

A.

A direct upgrade can be performed only from the immediately preceding Oracle Grid Infrastructure
version.

B.

The newer version is installed in a separate Oracle Grid Infrastructure home on the same server as the
existing version

C.

An existing Oracle base can be used.

D.

The upgrade process will automatically install all mandatory patches for the current version of Oracle
Grid Infrastructure.

E.

Existing Oracle Database instances must be shut down before starting the upgrade.

F.

Only the grid user can perform the upgrade.

Which three are true about Recovery Manager (RMAN) in Oracle Database 19c and later releases? (Choose three.)

A.

It is only possible for RMAN to connect to a pluggable database as a target if an RMAN Virtual Private
Catalog is used.

B.

It isalways possible for RMAN to connect to a pluggable database as a target if any RMAN Catalog is
used.

C.

A Virtual Private Catalog used to register a container database must be created in a pluggable database.

D.

A Virtual Private Catalog used to registera container database can be created in a pluggable database.

E.

It is always possible for RMAN to connect to a pluggable database as a target.

F.

A Virtual Private Catalog used to register a container database can be created in a non-container
database.

Which three are true about managing memory components in an Oracle database instance? (Choose three.)

A.

With Automatic Shared Memory Management, the database instance can increase the Large Pool size
byreducing the Shared Pool size

B.

With Automatic Memory Management, the database instance can increase the System Global Area size
by reducing the Program Global Area size.

C.

Automatically tuned and resized System Global Area components will always revertto their initial sizes
after an instance restart.

D.

Automatic Memory Management must be used together with locking the System Global Area into physical memory.

E.

With Automatic Shared Memory Management, the database instance can increase the Program Global
Area size by reducing the System Global Area size.

F.

On Line Transaction Processing systems often use less Program Global Area than Decision Support
Systems.