更多"[不定项选择题]Which three are true about "的相关试题:
[不定项选择题]Which three are true about Automatic Workload Repository (AWR),
Automatic Database Diagnostic Monitor (ADDM), and the Manageability
Monitor (MMON) background process? (Choose three.)
A. ADDM can recommend shrinking the buffer cache.
B. ADDM can recommend extending the buffer cache.
C. By default, MMON creates an AWR snapshot every 30 minutes.
D. ADDM performs its analysis only when a DBA requests it.
E. By default, AWR snapshots are automatically purged after eight days.
F. AWR snapshots must be deleted when no longer required by ADDM.
[不定项选择题]Which two are true about automatic block repair? (Choose two.)
A.
Automatic block repair can repair blocks with no standby database if
DB_BLOCK_CHECKING = TRUE.
B.
Real-Time Query must be enabled on a physical standby database for
Automatic block repair to be done on that physical standby database.
C.
Real-Time Query must be enabled on a primary database for automatic block
Repair to be done on any of its physical standby databases.
D.
It is not possible for media corrupt blocks.
E. Real-Time Query must be enabled on a physical standby database for
Automatic block repair to be done on its primary database.
[不定项选择题]Which two are true about the Automatic Database Diasnostic Monitor
(ADDM)? (Choose two.)
A. It analyzes a period of time corresponding to the 12 hours of activity.
B. It runs automatically after each AWR snapshot.
C. A DBA can run it manually.
D. Results are written to the alert log.
E. It analyzes a period of time corresponding to the last day of activity.
[不定项选择题]choose three Which three are true about RMAN duplexed backup sets or image copies?
A.
A backup set may be duplexed with both copies written to disk.
B.
An image copy on disk can be copied to disk.
C.
A backup set may be duplexed with both copies written to sbt.
D.
A backup set may be duplexed so that one copy is written to sbt and the other
To disk.
E. An image copy on disk can be copied to sbt.
F. An image copy on sbt can be copied to disk.
[不定项选择题]choose three Which three are true about Transparent Data Encryption
(TDE)?
A. It uses a single master key for a database.
B. It replaces secure application roles.
C. It encrypts only data on the client.
D. It stores the current and all past master keys in the keystore.
E. Master encryption keys are managed by Oracle Database Vault.
F. It can encrypt data at the column level.
[不定项选择题]Which three statements are true about Automatic Workload
Repository (AWR)?
A.
All AWR tables belong to the SYSTEM schema.
B.
The AWR data is stored in memory and in the database.
C.
The snapshots collected by AWR are used by the self-tuning components in the database
D.
AWR computes time model statistics based on time usage for activities, which
Are displayed in t he v$SYS time model and V$SESS_TIME_MODEL views.
E. AWR contains system wide tracing and logging information.
[不定项选择题]Which three statements are true about Flashback Data Archive?
A. To use Flashback Data Archive, users must have unlimited quota on the
Flashback Data Archive tablespace.
B. To enable Flashback Data Archive for a table, it is mandatory to have a default
Flashback Data Archive for a database.
C. While enabling Flashback Data Archive for a table, if no name is provided for
Flashback Data Archive, it is enabled using the default Flashback Data Archive.
D. A table enabled for Flashback Data Archive cannot be dropped unless
Flashback Data Archive is disabled or disassociated first.
E. Flashback Data Archive prevents flashback queries from getting a
Snapshot-too-old error.
[不定项选择题]Which three statements are true about the keystore storage framework
For transparent data encryption?
A. It facilitates and helps to enforce keystore backup requirements.
B. It handles encrypted data without modifying applications.
C. It enables a keystore to be stored only in a file on a file system.
D. It enables separation of duties between the database administrator and the
Security administrator.
E. It transparently decrypts data for the database users and applications that
Access this data.
F. It helps to track encryption keys and implement requirements such as keystore
Password rotation and master encryption key reset or re-key operations.
[不定项选择题]Choose three. Which three are true about Data Pump in an Oracle
Multitenant environment?
A. It can be used to transport data from a non-CDB to a PDB.
B. It can be used to clone a CDB.
C. It can be used to transport data between PDBs.
D. It can be used to transport data from a PDB to a non-CDB.
E. It can be used to create a new PDB.
[不定项选择题]Choose three.
Which three are true about creating container databases (CDBs) and
Pluggable databases (PDBs) in Oracle 19c and later releases?
A.
A snapshot copy PDB can be a full copy of a source PDB.
B.
A snapshot copy PDB does not depend on an existing storage snapshot of the
Source PDB.
C.
A PDB snapshot depends on an existing storage snapshot of the source PDB.
D.
A PDB snapshot can be a full copy of a source PDB.
E. A CDB can be duplicated using the Database Configuration Assistant (DBCA) in
Silent mode with no configuration required before starting the duplication.
F. A CDB can be duplicated using Recovery Manager (RMAN) with no
Configuration required before starting the duplication.
G. A PDB snapshot can be a sparse copy of a source PDB.
[不定项选择题]Choose three. Which three are true about cloning databases into an
Existing CDB with RMAN?
A. A non-CDB can be cloned into a PDB.
B. A user with SYSDBA or SYSBKUP must be logged in with RMAN to CDB$ROOT
When cloning a PDB.
C. Only one PDB can be cloned at a time.
D. Two or more PDBs can be cloned with the same command.
E. A user with SYSDBA or SYSBKUP must be logged in with RMAN to the
Non-CDB being cloned when cloning a non-CDB.
F. The target and auxiliary instance passwords must be the same.
[不定项选择题]Choose three. Which three are true about OPatch ?
A. It requires installation of Oracle Universal Installer.
B. It supports Rolling Patching.
C. It must be invoked as the user that owns the software being patched.
D. It is a Java-based utility for applying patchsets.
E. It is platform independent.
F. It can be used to apply interim patches to the Grid Infrastructure and Database
Home combination.
[不定项选择题]Choose three. Which three are true about Recovery Manager (RMAN)
Active database duplication?
A. Pre-existing backups of the database to be duplicated are required for the
"push" method of duplication.
B. Pre-existing backups of the database to be duplicated are required for the
"pull" method of duplication.
C. Pre-existing backups of the database to be duplicated are always used if they
Exist.
D. Image copies can be used to duplicate the active database.
E. The active database must be duplicated while in OPEN state.
F. No connection to the recovery catalog is required for active database
Duplication.
G. Backup sets can be used to duplicate the active database.
[不定项选择题]Choose three. Which three are true about the tools for diagnosing
Oracle Database failure situations?
A. RMAN can always repair corrupt blocks.
B. Flashback commands help with repairing physical errors.
C. The ADR can store metadata in an Oracle Database repository.
D. The Automatic Diagnostic Repository (ADR) has a separate home directory for
Each instance of each Oracle product that is installed and uses it.
E. The ADR command-line utility (ADRCI) can package incident information to
Send to Oracle Support.
F. The Data Recovery Advisor uses the ADR.
[不定项选择题]Choose three. Which three are true about patchsets?
A.
They are installed via OPatch or OPatchAuto.
B.
A base release is not needed to install patchsets.
C.
They can be applied in a rolling fashion for Clusterware and the databases.
D.
Installing a patchset is considered an "upgrade."
E.
They can introduce new features.
F.
They are only released quarterly.
[不定项选择题]Choose three. Which three are true about block media recovery?
A. To use it, Flashback Database must be enabled.
B. A block being recovered is not accessible.
C. It cannot repair logical corruption.
D. It can be performed on noncorrupt blocks.
E. The target database for which one or more blocks are to be recovered must be
In the OPEN state.
F. The data file containing the block being recovered remains online.
