Instant Access Oracle.1Z0-083.v2022-06-18.q213 Actual Practice Test Engine for Free (Page 37)

Which two are true about changing the LOCAL_UNDO_ENABLED property to false in a CDB? (Choose two.)

A.After the change, only a common user with the required privilege can create an undo tablespace in CDB&ROOT.
B.After the change, any user with the required privilege can create an undo tablespace in the PDBs.
C.After the change, only one undo tablespace can exist in CDB$ROOT.
D.Any new PDB and existing PDBs are automatically configured to use the default undo tablespace in CDB$ROOT.
E.Undo tablespaces existing in PDBs must be dropped before the change.
F.After the change, each existing PDB has to be reopened for the new undo mode to take effect.

Which three are true about using Database Upgrade Assistant (DBUA) to upgrade a database? (Choose three.)

A.DBUA must be launched from the target Oracle Home.
B.The database must be opened in read-only mode.
C.All pluggable databases are automatically upgraded as part of a container database upgrade.
D.The Pre-Upgrade Information Tool script is executed by DBUA.
E.A whole database backup must exist before upgrade
F.Multiple databases with the same ORACLE_HOME can be upgraded simultaneously.

Which three are true in Oracle 19c and later releases? (Choose three.)

A.If the password file location changes, then the new location is used automatically by the Oracle Server.
B.Schema Only accounts can be granted administrator privileges.
C.All the Oracle-supplied accounts are Schema Only accounts.
D.Privilege Analysis is included in Oracle Enterprise Edition and no longer requires Database Vault.
E.Unified Auditing can be configured to audit only events that are issued indirectly by an audited user.
F.Unified Auditing can be configured to audit only events that are issued directly by an audited user.

Which three are true about opatchauto? (Choose three.)

A.Users must always input patch plans to opatchauto.
B.Patches are applied via opatchauto.
C.It applies patches in nonrolling mode by default.
D.It requires the Oracle Grid Infrastructure and Oracle Database instances to be shut down before being invoked.
E.It performs a shutdown and then a restart of all processes in both Oracle Grid Infrastructure and Oracle Database home during the patching process.
F.It must be invoked by a user with root user privileges.
G.It is used to apply interim patches to Oracle Grid Infrastructure and Oracle Database home combinations.

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

A.The SBT device should be configured to use PARALLELISM 2 to allow both tape drive to be used simultaneously.
B.Any backup set written to the SBT device in this configuration can contain a maximum of two backup pieces.
C.SBT tape compression and RMAN backup compression should be used in parallel.
D.Any backup written to the SBT device in this configuration can contain a maximum of two backup sets.
E.SBT tape compression can be used even if no RMAN compression is configured.

Download PDF File