Oracle Database Administration II (1z0-083) Practice Test

Questions # 81:

Which three are true about thresholds, metrics, and server-generated alerts? (Choose three.)

Options:

All metrics are instance related.

Cleared stateful alerts are displayed by querying DBA_ALERT_HISTORY.

A space usage management alert is automatically cleared after the underlying problem is resolved

They are generated by SMON when a tablespace is 97% full.

Metrics are statistical counts for a specific unit.

STATISTICS_LEVEL must be set to ALL to generate alerts.

Questions # 82:

HR_ROOT is an application container with the HR_APP application installed. No application PDBs and no application seed have yet been created in HR_ROOT. An application PDB, PDB1,must be created so that the HR_APP application's common objects are accessible to it. Which two methods can be used?

Options:

Create the PDB1 application PDB and synchronize it with poB$SEED.

Create the PDB1 application PDB and synchronize it with HR_ROOT.

Create the PDB1 application PDB and install HR_APP in it.

Create an application seed, and install HR_APP in it.

Create an application seed, synchronize it with HR_ROOT, and then create the PDB1.application PDB.

Questions # 83:

While backing up to an SBT channel, you determine that the read phase of your compressed Recovery Manager (RMAN) incremental level 0 backup is a bottleneck. FORCE LOGGING is enabled for the database. Which two could improve read performance? (Choose two.)

Options:

Increase the size of tape I/O buffers.

Disable FORCE LOGGING for the database.

Increase the size of the database buffer cache.

Enable asynchronous disk I/O.

Increase the level of RMAN multiplexing.

Questions # 84:

Which two are true about RMAN backups when using a media manager to write backups to tape when there are only two tape drives? (Choose two.)

Options:

SBT tape compression can be used even if no RMAN compression is configured.

Any backup set written to the SBT device in this configuration can contain a maximum of two backup pieces.

Any backup written to the SBT device in this configuration can contain a maximum of two backup sets.

SBT tape compression and RMAN backup compression should be used in parallel.

The SBT device should be configured to use PARALLELISM 2 to allow both tape drive to be used simultaneously.

Questions # 85:

choose two Examine the command to duplicate a database: RMAN> DUPLICATE TARGET DATABASE TCddb PLUGGABLE DATABASE pdbl,pdb5; Which two statements are true about the DUPLICATE command?

Options:

The root and the seed database in the container database (CDB) are also duplicated.

A backup of PDB1 and PDB5 must exist before executing the command.

The SPFILE is copied along with the data files of the pluggable databases (PDBs).

An auxiliary instance must be started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE. E) The DUPLICATE command first creates a backup, and then duplicates the

PDBs by using the backup.

Viewing page 9 out of 9 pages

Viewing questions 81-90 out of questions

Summer Certification Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

Pass the Oracle Database 19c 1z0-083 Questions and answers with ExamsMirror

Exam 1z0-083 Premium Access

Options:

Options:

Options:

Options:

Options:

TOP CODES