[多选题]Which two are true about the Program Global Area(PGA、and its management in an Oracle
Database instance?
A.PGAAGGREGATE LIMII is a hard limit on the PGA size for any one session
B.The entire PGA is located in the System Global Area(SGA、when using shared servers
C.The private SQL area(UGA、is located in the System Global Area(SGA、when using shared
Servers
D.Sorts and Hash Joins use PGA memory.
E. The private SQL area(UGA、is located in the System Global Area(SGA、when using dedicated
Servers

[多选题]Which two are true about Optimizer Statistics?
A. They are ignored by Optimizer if they are stale.
B. They provide real-time data about schema objects
C. By default, they are automatically gathered by a maintenance job
D. They are gathered by the SQL Tuning Advisor
E. They can be gathered by the DBMS_STATS package

[多选题]Which two are true about duplicating pluggable databases(PDBS) with RMAN?
A. CDB$ROOT and PDBSSEED are automatically duplicated if a PDB is duplicated
B. A user with SYSDBA or SYSBKUP must use RMAN logged in to a PDB in order to duplicate
It.
C. Two or more PDBS can be duplicated with the same RMAN DUPLICATE command
D.The auxiliary instance is automatically created with ENABLE PLUGGABLE DATABASE
TRUE
E. All tablespaces belonging to a PDB must be duplicated when duplicating the PDB

[多选题]Which two are true about the automatic execution of operating system scripts when performing
Silent mode installation starting from Oracle Database 19c?
A. The installer will prompt for the root or sudo password
B.Silent install always runs operating scripts automatically.
C. The response file can specify the root or sudo password
D.The response file must contain the root or sudo password
E. The response file can specify the path of the sudo program

[多选题]Which two are true about reclaiming space used by Flashback logs in Oracle Database 19c and
Later releases?
A.Space is only reclaimed when there is space pressure in the Fast Recovery Area(FRA、
B.Space is always reclaimed automatically when the retention period for Flashback logs is
Lowered
C.Space might be reclaimed proactively before space pressure occurs
D.Space is always reclaimed proactively before space pressure occurs
E. Space might be reclaimed automatically when the retention period for Flashback logs is
Lowered

[多选题] Which two are true about RMAN duplexed backup sets?
A. They can be written to media
B. They can be created only by using the copies option of a BACKUP command
C. They can be created by using the RMAN CONFIGURE command to specify duplexing before
Taking a backup
D. They can be written only to disk.
E. They must be written to media

[多选题]Which two are true about creating pluggable databases(PDBS)in Oracle 19c and later releases?
A. A PDB snapshot depends on an existing storage snapshot of the source PDB
B. A PDB snapshot can be a full copy of a source PDB
C. A PDB snapshot can be a sparse copy of a source PDB
D. A snapshot copy PDB does not depend on an existing storage snapshot of the source PDB
E. A snapshot copy PDB can be a full copy of a source PDB

[多选题] Which two are true about Oracle instance recovery?
A. Recovery begins from the beginning of the CURRENT redo log group.
B. Recovery begins from the start of any ACTIVE redo log group or the start of the CURRENT
Log group if no other group is ACTIVE
C. Recovery begins from the last checkpoint position that was recorded in the control file by the
Checkpoint process (ckpt)
D. Recovery begins from the last checkpoint position that was calculated by the Database Writer
Before instance failure
E. Recovery reads redo until the end of the redo thread, and then opens the database. SMON then
Rolls back any dead transactions
F. Recovery reads redo until the end of the redo thread. SMON rolls back any dead transactions,
And then the database is opened

[多选题]Which two are true about creating RMAN backups for an Oracle container database?
A. Control file backups can be created while connected to cdb$root
B. The BACKUP TABLESPACE command can back up a PDB tablespace even if RMAN is
Connected to CDB$ROOT
C. Online Redo Log backups can be created while connected to CDB$ROOT.
D. Control file backups can not be created while connected to a PPB.
E. Archived Redo Log backups can be created while connected to PDB

[多选题]Which two are true about backup set compression using RMAN default compression?
A. Compressed backups cannot have a section size defined
B. Unused blocks below the high water mark are backed up
C. Binary compression adds CPU overhead to backup operations
D. Compressed backups can be written only to media
E. Compression can be done only for locally managed tablespaces

[多选题]Which two are true about various Oracle security and auditing capabilities
A. Application-common Transparent Security Data Protection(TSDP)policies can be created only
If all the PDBS in the application container are closed
B. Unified auditing can be automatically synchronized to all application PDBS in an application
Container
C. Application-common OLS policies can be created only if all the PDBS in the application
Container are closed
D. Fine-grained auditing (FGA )policies in an application root are automatically synchronized to
All application PDBS contained in the application container when they are updated
E. Application-common TSDP policies are always container specific.

[多选题]Which two are true about RMAN Multisection backups when a very large data file is divided
Into four sections?
A. Each of the file sections must be processed serially.
B. The four sections must be image copies
C. The four sections can be created serially
D. The four sections can be created in parallel
E. The four sections must be contained in backup sets

[多选题]Which two are true about instance recovery?
A. It is not possible if an archived log is missing
B.Setting Fasr START Mrrr TARGER to a higher value reduces instance recovery time by causing
The log writer to write more frequently, thereby reducing the number of I/Os needed during
Instance recovery
C.It is performed automatically after the database is opened; however, blocks requiring recovery
Are not available until they are recovered
D.Setting FAST START MTTR TARGET to a lower value reduces instance recovery time by
Causing dirty buffers to be written to disk more frequently, thereby reducing the number of I/Os
Needed during instance recovery.
E. It is performed automatically while the database remains in MOUNT state. Then the database is
Opened
F. It is performed by the Recovery Writer (RVWR)background process

[多选题]Which two are true about RMAN virtual private catalogs(VPCS)?
A. Each VPC is owned by the recovery catalog schema owner.
B. VPC functionality is enabled by default.
C. Only one target database can be registered in a VPC
D. The RMAN catalog owner can grant access for an already registered database to a new virtual
Catalog owner
E. RMAN uses Oracle Virtual Private Database(VPD. to implement VPCS

[多选题]Which two are true about Oracle Grid Infrastructure for a Standalone Server?
A. It requires Oracle Automatic Storage Management(ASM)components to be installed separately
B. The CSS daemon runs from the Grid Infrastructure home
C. It can manage database resources on the server where it is installed or on a different server.
D. It supports volume management, file system, and automatic restart capabilitiesE. It must be installed before the Oracle database software is installed

[多选题]Which two are true about Lockdown profiles in a container database(CDB.and its pluggable
Databases(PDBS)?
A. A PDB Lockdown profile can be created in an application root
B. A PDB Lockdown profile can be created in a regular PDB
C. A Lockdown profile created from a base Lockdown profile is never automatically modified if
The profile on which it is based is modified
D. A PDB Lockdown profile can be created in CDB$ROOT
E. A Lockdown profile created from a base Lockdown profile is always automatically modified if
The profile on which it is based is modified

[多选题]Which two are true about memory advisors?
A. If Automatic Memory Management is enabled, the Shared Pool Advisor and Buffer Cache
Advisor are available to set the maximum size for these individual System Global Area
Components
B. If Manual Shared Memory Management is enabled, only the Shared Pool Advisor and Buffer
Cache Advisor are available
C.If Automatic Shared Memory Management is enabled, both the SGA Advisor and PGA Advisor
Are always available.
D. If Automatic Memory Management is enabled, no memory advisors are available.
E. All memory advisors use data from Automatic Workload Repository

[多选题]Which two are true about SQL Performance Analyzer(SPA.?
A. It offers fine-grained analysis of all the SQL statements in the analysis task as a group
B. It provides before and after execution statistics for each SQL statement in the analysis task.
C. It is integrated with the SQL Access Advisor.
D. SQL statements that were originally run concurrently are run concurrently by SPA
E. It predicts the impact of system changes on SQL workload response time

[多选题]Which two are true about unplugging an application container from a container database and
Plugging it into a different container database?
A. It requires local UNDO mode in both container databases
B. Application PDBS in the application container must be unplugged before the application root is
Unplugged.
C. The application root of an application container should be plugged into the other CDB before
Its application PDBS are plugged in.
D. Unplugging the application root from a CDB unplugs all its application PDBS.
E. Plugging the application root into a different CDB plugs in all its application PDBS.
F. IT requires only local UNDO mode in the database where the application container will be
Unplugged

[多选题]Which two are true about backup encryption?
A. The BACKUP BACKUPSET command can encrypt and decrypt backup sets
B. Image copies can be encrypted
C. Backup encryption can be enabled selectively for specific tablespaces
D. The Transparent Data Encryption (TDE. keystore is backed up using RMAN
E. Vendor-specific media management software can be used for making encrypted RMAN
Backups to media
F. Keystore-based encryption is the default mode for RMAN backup encryption