Black Friday Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

New Release 1z0-083 Oracle Database 19c Questions

Page: 7 / 21
Total 286 questions

Oracle Database Administration II Questions and Answers

Question 25

Which three are true about performing an Oracle Database install on Linux? (Choose three.)

Options:

A.

The runfixup.sh script can install missing RPMs.

B.

The Oracle Preinstallation RPM must be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group

C.

It allows you to select the languages supported by the Oracle database server.

D.

It can be done before installing Grid Infrastructure for a Standalone Server

E.

The Oracle Preinstallation RPM can be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group

F.

It can be done after installing Grid Infrastructure for a Standalone Server.

G.

The Oracle database administrator must be granted access to the root operating system account to run root privileged scripts.

Question 26

Choose three. Which three are true about backing up the control file?

Options:

A.

It cannot be backed up manually as a binary copy.

B.

It gets backed up automatically by RMAN as a trace file containing SQL statements for control file re¬creation when a database backup occurs.

C.

It can be backed up manually as a binary copy.

D.

It can get backed up automatically as a binary copy.

E.

It gets backed up automatically by RMAN when the BACKUP SPFILE command is used.

F.

It can be backed up manually as a trace file containing SQL statements for control file recreation.

Question 27

Which three are true about Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) in an Oracle multitenant environment?

Options:

A.

AWR snapshots can be created in CDB$ROOT.

B.

ADDM can run in a nonroot container.

C.

AWR reports can be generated while connected to any container.

D.

All AWR data is stored in the CDB$ROOT SYSAUX tablespace.

E.

AWR snapshots can be created in a PDB.

F.

No AWR data is stored in the CDB$ROOT SYSAUX tablespace.

Question 28

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:

A.

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

B.

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

C.

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

D.

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

E.

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

Page: 7 / 21
Total 286 questions