更多"[多选题] Which two are true about RMAN"的相关试题:
[多选题]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 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 three are true about using an RMAN Recovery Catalog with a pluggable
Database(PDB.target connection in Oracle Database 19c and later releases?
A. The target PDB must be registered in a Virtual Private Catalog
B. The base catalog must be used by RMAN when performing point-in-time recovery for the PDB
Registered in the Virtual Private Catalog
C. The target PDB must be registered in both the base catalog and the Virtual Private Catalog
D. The target PDB must be registered in a base catalog
E. The base catalog owner must give the Virtual Private Catalog access to metadata for one or
More PDBS
F.The base catalog must be enabled for Virtual Private Catalog use
[多选题]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 RMAN backups when using a media manager?
A. A media manager is required to create RMAN proxy copies.
B. A media manager always writes RMAN requested backups to tape
C. The media manager layer(MML) routines provided by Oracle support any vendors media
Management products
D. A media manager is required to create RMAN image copies
E. By default, a request for a proxy copy may result in a backup set being created
[多选题]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 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 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 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 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 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 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 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
[多选题]Which two are true about server-generated alerts?
A.Stateless alerts can be cleared manually
B.Stateless alerts are automatically cleared after one day.
C.Stateful alerts are purged automatically from the alert history after one day
D.Stateless alerts can be purged manually from the alert history.
E. Stateful alerts must be cleared by a DBA to resolve the problem identified in the alert.
[多选题]Which two are true about PDB archive files?
A. DBMS_PDB_ CHECK.PLUG_COMPATIBILITY can be run against a PDB archive
B. They contain a PDB manifest file and all the data files in uncompressed form for a PDB
C. They contain all the data files only in uncompressed form for a PDB.
D.
They contain a PDB manifest file and all the data files in compressed form for a PDB.
E. They must be created using the DBMS PDB package
F. They contain all the data files only in compressed form for a 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
