更多"[不定项选择题]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 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 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 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.
[不定项选择题]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.
[不定项选择题]Choose three. 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 base catalog owner must give the Virtual Private Catalog access to
Metadata for one or more PDBs.
B.
The target PDB must be registered in both the base catalog and the Virtual Private Catalog.
C.
The base catalog must be used by RMAN when performing point-in-time
Recovery for the PDB registered in the Virtual Private Catalog.
D.
The base catalog must be enabled for Virtual Private Catalog use.
E. The target PDB must be registered in a Virtual Private Catalog.
F. The target PDB must be registered in a base catalog.
[不定项选择题]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 post-upgrade activities
When upgrading an Oracle database using Database Upgrade Assistant?
A.
Any Recovery Manager (RMAN) recovery catalog must be upgraded manually.
B.
After a manual upgrade, TNSNAMES.ORA entries must be updated to reflect
The new ORACLE_HOME.
C.
Time zone files must be upgraded manually using the DBMS_DST PL/SQL
Package.
D.
The new extended data type capability must be enabled by running the
Utlrp.sql script
E. The Oracle Application Express configuration should be updated after
Upgrading Oracle Database.
[不定项选择题]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 an application container?
A. It must have an application root PDB.
B. Two application containers can share an application seed PDB.
C. It can contain multiple applications.
D. It can contain a single application.
E. It must have an application seed PDB.
F. An application PDB can belong to multiple application containers.
[不定项选择题]Choose three. Which three are true about Rapid Home Provisioning of
Oracle software?
A.
It can be used to patch existing Oracle software installations.
B.
It can be used only on nodes with Oracle Grid Infrastructure installed.
C.
It can be used to create a single-instance Oracle Database in an
Already-installed Oracle home.
D.
It can be used to deploy new homes without
Disrupting active databases.
E.
It can be used to create templates of Oracle homes as gold images of only
Oracle databases.
F.
It can be used to upgrade only single-instance databases running on Oracle
Restart.
[不定项选择题]Choose three. Which three are true about Automatic Workload Repository
(AWR) and Automatic Database Diagnostic Monitor (ADDM) in an Oracle
Multitenant environment?
A. AWR snapshots can be created in CDB$ROOT.
B. ADDM can run in a nonroot container.
C. AWR reports can be generated while connected to any container.
D. All AWR data is stored in the CDB$ROOT SYSAUX tablespace.
E. AWR snapshots can be created in a PDB.
F. No AWR data is stored in the CDB$ROOT SYSAUX tablespace.
