Which three are true? (Choose three.) Virtual Private Database (VPD) policies on objects in an application root are automatically
synchronized with all application PDBs contained in the application container. Application-common TSDP policies are always container specific. Application-common Transparent Security Data Protection (TSDP) policies can be created only within
an application install/patch BEGIN-END block. Application-common Oracle Label Security (OLS) policies cannot be created in an application root
outside an install/patch BEGIN-END block. Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all
application PDBs contained in the application container. Application-common OLS policies can be created in an application root inside an install/patch BEGINEND block. Unified auditing can be automatically synchronized to all application PDBs in an application container.
Which three are true about Automatic Workload Repository (AWR)? (Choose three.) By default, AWR snapshots are taken every 60 minutes. Its collection level is determined by the value of the STATISTICS_LEVEL database parameter By default, AWR snapshots are retained for 7 days. The taking of AWR snapshots can be disabled. AWR data is stored in the SYSTEM tablespace.
Which two are true about automatic block repair? (Choose two.) Automatic block repair can repair blocks with no standby database if DB_BLOCK_CHECKING = TRUE Real-Time Query must be enabled on a physical standby database for automatic block repair to be
done on that physical standby database. Real-Time Query must be enabled on a primary database for automatic block repair to be done on any
of its physical standby databases. It is not possible for media corrupt blocks. Real-Time Query must be enabled on a physical standby database for automatic block repair to be
done on its primary database.
Oracle Managed Files (OMF) is enabled in a CDB and this command is successfully executed:
CREATE PLUGGABLE DATABASE app1 AS APPLICATION CONTAINER ADMIN USER admin1IDENTIFIED BY app_123 ROLES=(CONNECT);
Which three are true? (Choose three.) Application PDBs that are subsequently created in the APP1 application container will be cloned from
APP1$SEED. An application seed PDB is created for APP1. An application root PDB is created for APP1. A default service is created for the application root APP1 Application PDBs that are subsequently created in the APP1 application container will be cloned from
PDB$SEED. APP1 can never be unplugged.
Which two are true about RMAN encryption? (Choose two.) RMAN encryption keys are stored in a database keystore. RMAN can encrypt the Oracle Database password file Dual-mode encrypted backups can be restored only if both the password and the keystore used for
encryption are available. The SET ENCRYPTION command overrides encryption settings specified by the CONFIGURE
ENCRYPTION command. Password encryption can be persistently configured using the CONFIGURE ENCRYPTION command.
Which three are true about performing an Oracle Database install on Linux? (Choose three.) The runfixup.sh script can install missing RPMs. The Oracle Preinstallation RPM must be used to configure the Oracle database installation owner, the
Oracle Inventory group, and an Oracle administrative privileges group. It allows you to select the languages supported by the Oracle database server It can be done before installing Grid Infrastructure for a Standalone Server. The Oracle Preinstallation RPM can be used to configure the Oracle database installation owner, the
Oracle Inventory group, and an Oracle administrative privileges group. It can be done after installing Grid Infrastructure for a Standalone Server The Oracle database administrator must be granted access to the root operating system account to tun
root privileged scripts.
Which three are true about Recovery Manager (RMAN) in Oracle Database 19c and later releases?
(Choose three.) It is only possible for RMAN to connect to a pluggable database as a target if an RMAN Virtual Private
Catalog is used. It is always possible for RMAN to connect to a pluggable database as a target if any RMAN Catalog is
used. A Virtual Private Catalog used to register a container database must be created in a pluggable
database. A Virtual Private Catalog used to register a container database can be created in a pluggable
database. It is always possible for RMAN to connect to a pluggable database as a target. A Virtual Private Catalog used to register a container database can be created in a non-container
database.
Which three are true in Oracle 19c and later releases? (Choose three.) If the password file location changes, then the new location is used automatically by the Oracle Server Schema Only accounts can be granted administrator privileges. All the Oracle-supplied accounts are Schema Only accounts. Privilege Analysis is included in Oracle Enterprise Edition and no longer requires Database Vault Unified Auditing can be configured to audit only events that are issued indirectly by an audited user. Unified Auditing can be configured to audit only events that are issued directly by an audited user.
You have configured RMAN SBT channels to write backups to media.
You then take an RMAN backup by using this command:
RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE KEEP UNTIL TIME ' SYSDATE+730' RESTORE POINT 'OLD_CONFIGURATION';
Which three are true? (Choose three.) The restore point is a label for the system change number (SCN) that will be saved two years after the
archival backup was taken. The data file backups in the self-contained archive backup are not considered obsolete for two years
regardless of the retention policy All archive logs created after this backup are kept for two years. The SPFILE is included in the self-contaied archival backup. The control file is included in the self-contained archival backup. The restore point is a label for the system change number (SCN) before the archival backup was taken.
The USERS tablespace consists of data files 3 and 4 and must always be online in read/write mode.
Which two are true about using RMAN to perform an open database back up of this tablespace? (Choose
two.) Backups must be done incrementally Backups must be contained in backup sets. Backups can be taken only if the database is in ARCHIVELOG mode. Backups can be done incrementally The database must be registered in an RMAN catalog. Only consistent backups can be created.
|
