[多选题]Which three are true about interpreting Recovery Manager(RMAN)error stacks returned to
Standard output?
A. If an RMAN command fails, the output will only identify the command that failed
B. If an RMAN command fails, the output will identify the channel ID where the failure occurred.
C. Media Management errors appear as a line with"sbtio
D. Some messages in the error stack are not errors
E. Media Management errors appear as a line with"Additional information and a number.
F. Media Management errors appear as a line with"sbtio and a number.

[多选题]Which three are true about recovering tables using RMAN?
A. RMAN can recover tables in the SYSAUX tablespace
B. RMAN always uses an auxiliary instance
C. RMAN can recover a table after a DDL operation has altered the table structure.
D. RMAN can recover tables owned by the sys user.
E. RMAN can recover tables in the SYSTEM tablespace
F. RMAN can recover tables in a standby database
G. RMAN can recover tables owned by the SYSTEM user.

[多选题]Which three are true about patchsets?
A. They are only released quarterly
B. They are installed via Opatch or Opatchauto.
C. A base release is not needed to install patchsets.
D. They can introduce new features
E. They can be applied in a rolling fashion for Clusterware and the databases
F. Installing a patchset is considered an upgrade.

[多选题]Which three are true about transporting databases across platforms using Recovery Manager
(RMAN) image copies?
A. A new DBID is automatically created for the transported database
B. By default, the transported database will use Oracle Managed Files(OMF.
C. Data files can be converted on the source system
D. Databases can be transported between systems with different endian formats
E. Data files can be converted on the destination system
F. The password file is automatically converted by RMAN.

[多选题]Which three are true about cloning databases into an existing CDB with RMAN?
A. The target and auxiliary instance passwords must be the same.
B. Only one PDB can be cloned at a time
C. Two or more PDBS can be cloned with the same command A NON-CDB can be cloned into a PDB
D. A user with SYSDBA or SYSBKUP must be logged in with RMAN to CDB$ROOT when
Cloning a PDB
E. A user with SYSDBA or SYSBKUP must be logged in with RMAN to the NON-CDB being
Cloned when cloning a NON-CDB

[多选题]Which three are true about upgrading Oracle Grid Infrastructure?
A.The newer version is installed in a separate Oracle Grid Infrastructure home on the same server
As the existing version
B.A direct upgrade can be performed only from the immediately preceding Oracle Grid
Infrastructure version
C. The upgrade process will automatically install all mandatory patches for the current version of
Oracle Grid Infrastructure
D. Only the grid user can perform the upgrade
E. Existing Oracle Database instances must be shut down before starting the upgrade
F.An existing Oracle base can be used.

[多选题]Which three are true about block media recovery?
A. The target database for which one or more blocks are to be recovered must be in the OPEN
State
B. The data file containing the block being recovered remains online
C. It cannot repair logical corruption
D. It can be performed on noncorrupt blocks
E. A block being recovered is not accessible
F. To use it, Flashback Database must be enabled

[多选题]Which three are true about using Database Resource Manager in an Oracle multitenant
Environment?
A. A Pdb-level resource plan can limit session PGA memory
B. A Cdb-level resource plan is mandatory when using Pdb-level resource plans
C. A Cdb-level resource plan can limit session CPU utilization.
D. A Cdb-level resource plan can limit PDB UNDO use
E. Pdb-level resource plans can limit uncommitted UNDO per consumer group
F. A Cdb-level resource plan can limit PDB CPU utilization.

[多选题]Which three are true about the FLASHBACK DATABASE feature?
A. It always generates REDO and UNDO
B. It requires that the target database be in ARCHIVELOG mode
C. FLASHBACK DATABASE only uses FLASHBACK Logs to get the database to the desired
Flashback time
D. FLASHBACK LOGS are archived after a log switch
E. A database can be flashedback using SQL*PLUS
F. Queries and DML have the same FLASHBACK LOG overhead when flashback is enabled for
A database

[多选题]Which three are true about using Database Upgrade Assistant(DBUA.to upgrade a database?
A. Multiple databases with the same ORACLE HOME can be upgraded simultaneously
B. All pluggable databases are automatically upgraded as part of a container database upgrade.
C. DBUA must be launched from the target Oracle Home
D. The Pre-upgrade Information Tool script is executed by DBUA
E. A whole database backup must exist before upgrade
F. The database must be opened in read-only mode.

[多选题]Which three are true about RMAN archival backups with the RESTORE POINT clause?
A. Archive logs are retained if they are necessary to allow the database to be recovered to a
Consistent state when an archival backup is restored
B. The SPFILE is included in the archival backup.
C. The ARCHIVAI attribute for a backup overrides the RMAN retention policy
D. They are never considered obsolete by RMAN
E. They can optionally be written to a fast recovery area(FRA..
F. All archive logs are retained after an archival backup is taken, until the next archival backup is
Taken of the same database
G)Use of a recovery catalog is always required to support the creation and use of archival backups

[多选题]Which three are true about Rapid Home Provisioning of Oracle software?
A. It can be used only on nodes with Oracle Grid Infrastructure installed
B. It can be used to patch existing Oracle software installations
C. It can be used to deploy new homes without disrupting active databases.
D. It can be used to upgrade only single-instance databases running on Oracle Restart.
E. It can be used to create templates of Oracle homes as gold images of only Oracle databases
F. It can be used to create a single-instance Oracle Database in an already-installed Oracle home.

[多选题]Which three are true about upgrading an application in an application container?
A. The upgrade can be performed when connected either to cdb$root or to PDB$SEED
B. An application name and version number must be specified to upgrade the application
C. After an application upgrade, the application containers pdbs remain synchronized with the
Existing application root
D. The upgrade must be performed when connected to CDB$ROOT
E. An application root clone gets created automatically
F. After an application upgrade, the application containers PDBS are automatically synchronized
With the application root clone

[多选题] Which three are true about Oracle Grid Infrastructure for a Standalone Server?
A. It includes both Oracle Restart and Oracle Automatic Storage Management(ASM) software.
B. It creates one disk group during installation.
C. It requires the operating system ORACLE_BASE environment variable to be predefined before
Installation.
D. It requires Oracle ASMLib to manage Automatic Storge Management(ASM) disks.
E. It requires Oracle ASM Filter Driver(ASMFD. to manage Automatic Storge
Management(ASM) disks.
F. Automatic Storge Management(ASM) requires that O/S groups OSASM and OSDBA be
Assigned as secondary groups for its installation owner.

[多选题]which three are true about the tools for diagnosing Oracle Database failure situations?
A.The Automatic Diagnostic Repository (ADR) has a separate home directory for each instance of
Each Oracle product that is installed and uses it
B. The ADR command-line utility (ADRCI)can package incident information to send to Oracle
Support.
C. The ADR can store metadata in an Oracle Database repository.
D. Flashback commands help with repairing physical errors.
E. The Data Recovery Advisor uses the ADR
F RMAN can always repair corrupt blocks

[多选题]Which three are true about a whole database backup?
A. It can be created only by using RMAN
B. It is the only possible backup type for a database in NOARCHIVELOG mode
C. It can be consistent.
D. It can consist of either backup sets or image copies.
E. It can be inconsistent
F. It always includes all data files, the current control file, the server parameter file, and archived
Redo logs.

[多选题]Which three are true about backing up the control file?
A. It gets backed up automatically by RMAN when the BACKUP SPFILE command is used
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 get backed up automatically as a binary copy.
D. It can be backed up manually as a binary copy.
E. It cannot be backed up manually as a binary copy.
F. It can be backed up manually as a trace file containing SQL statements for control file
Re-creation

[多选题]Which three are true about Automatic Workload Repository (AR)and Automatic Database
Diagnostic Monitor(ADDM)in an Oracle multitenant environment?
A. AWR snapshots can be created in CDB$ROOT
B. No AWR data is stored in the CDBSROOT SYSAUX tablespace
C. ADDM can run in a nonroot container
D. All AWR data is stored in the CDBSROOR SYSAUX tablespace
E. AWR snapshots can be created in a PDB
F. AWR reports can be generated while connected to any container

[多选题] Which three are true about Automatic Workload Repository (AWR), Automatic Database
Diagnostic Monitor(ADDM), and the Manageability Monitor(MMON)background process?
A. AWR snapshots must be deleted when no longer required by ADDM
B. By default, MMON creates an AWR snapshot every 30 minutes.
C. ADDM can recommend extending the buffer cache
D. ADDM can recommend shrinking the buffer cache
E. By default, AWR snapshots are automatically purged after eight days
F ADDM performs its analysis only when a DBA requests it.