|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.) 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
You plan to install Oracle Grid Infrastructure for a Standalone Server and Oracle Database for the first time
on a server.
Examine this command and its outcome:
Which two are true? (Choose two.) oracle will be an owner of the Oracle Inventory oracle must be the owner of every Oracle Database installation. oracle can own an Oracle Database installation but not an Oracle Grid Infrastructure installation. oracle will be granted the SYSASM privilege when installing the Oracle Database software. The user account, oracle, and group, oinstall, can be used for all Oracle software installations.
While CDB1 is open, `/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl' is accidentally
To recover from this critical failure, you execute these commands:
What will be the outcome? It will create `$ORACLE_HOME/dbs/cdb1/CDB1/controlfile02.ctl' It will create `/u01/app/oralce/oradata/CDB1/controlfile/controlfile02.ctl'. It will re-create `/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl' It will create `/u01/app/oracle/product/188.8.131.52/db_1/dbs/snapcf_cdb1control02.ctl'. It will fail because there is no autobackup of the controlfiles.
Examine these actions:
1. Create a new database for a recovery catalog.
2. Create a tablespace with sufficient space in the catalog database for the recovery catalog.
3. Configure ARCHIVELOG mode for the catalog database.
4. Create a user to own the recovery catalog schema with quota on the tablespace that will contain the
5. Grant the RECOVERY_CATALOG_OWNER role to the recovery catalog schema owner.
6. Grant the SYSBACKUP privilege to the recovery catalog schema owner.
Which are the minimum actions that must be performed before executing the CREATE CATALOG
command? 2, 4, 5, 6 1, 2, 3, 4, 5, 6 1, 2, 4, 5 2, 4, 5 1, 3, 4, 5.
Which two are true about creating pluggable databases (PDBs) using snapshots in Oracle 19c and later
releases? (Choose two.) A PDB snapshot is always a full copy of the source PDB. A PDB snapshot is always a sparse copy of the source PDB A snapshot copy PDB depends on a storage snapshot which can only be stored on specific file
systems A PDB snapshot depends on a storage snapshot which can be stored on any file system A PDB snapshot depends on a storage snapshot which can only be stored on specific file systems A snapshot copy PDB depends on a storage snapshot which can be stored on any file system. A snapshot copy PDB can be created from a stand-alone clone PDB.
Which two are true about Oracle Database Configuration Assistant (DBCA) templates? (Choose two.) The General Purpose of Transaction Processing templates are most suitable when concurrency and
recoverability are key criteria. Oracle DBCA templates can store only logical structure and not database files. New templates can only be created by modifying an existing user-created template. The Data Warehouse template is most suitable when transaction response time is the key criterion Oracle DBCA templates can be used to create new databases and duplicate existing databases.
Your SALES_ROOT application container has two application PDBs.
The SALES_APP application has a common table, FIN.REVENUE, in the two PDBs.
Examine this query and its output:
Which two are true? (Choose two.) The CONTAINERS clause cannot be used in queries on the REVENUE table The REVENUE table must be a list-partitioned table. The MAPTABLE tables defines a logical partition key on a commonly used column for the REVENUE
table. The MAPTABLE table is a metadata-linked table. A container map exists for the REVENUE table, but is not enabled. The REVENUE table partitions are not pruned across the PDBs automatically.
Your container database, CDB1, has an application container, HR_ROOT, with an application PDB,
You have the required privilege to clone HR_PDB1 to container database CDB2, which does not contain
Which two are always true? (Choose two.) CDB1 and CDB2 must be in shared undo mode. A common user must exist in CDB2 with the CREATE PLUGGABLE DATABASE privilege. All transactions in HR_PDB1 of CDB1 must commit before the cloning process starts. Cloning HR_ROOT automatically clones HR_PDB1 The HR_PDB1 clone created in CDB2 will be in mount state when cloning ends.
Which three are true about backup, restore, and recovery operations done without using Recovery
Manager (RMAN)? (Choose three.) Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database
instance be started and the dataabse be in the MOUNT state. Backing up a database in ARCHIVELOG mode using O/S utilities requires that the database instance
be started and the database be in MOUNT state. An Oracle database can be restored from backup files copied using O/S utilities. Oracle data file backups, copied using an O/S utility, can be added to the RMAN catalog as IMAGE
COPIES. Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database
instance be shut down. Oracle archive log backups, copied using an O/S utility, can be added to the RMAN catalog as a
backup set. Backing up a database in ARCHIVELOG mode using O/S utilities requires that the database instance
be started and the database be in OPEN state.
Examine this configuration:
1. CDB1 is a container database.
2. PDB1 and PDB2 are pluggable databases in CDB1.
You execute these commands successfully:
Which two are true? (Choose two.) PDB1 and PDB2 are in MOUNT state. Redo logs are opened. PDB1 and PDB2 are in READ ONLY state. CDB$ROOT is in MOUNT state. PDB$SEED is in READ ONLY state.