更多"[不定项选择题]Which three are true about "的相关试题:
[不定项选择题]Which three are true about Automatic Workload Repository (AWR)
Snapshots?
A. They can be retained forever.
B. They are always created automatically.
C. They are always created manually.
D. They are generated if STATISTICS LEVEL is set to TYPICAL.
E. They are generated if STATISTICS LEVEL is set to BASIC.
F. They are generated if STATISTICS LEVEL is set to ALL.
[不定项选择题]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.
[不定项选择题]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.
[不定项选择题]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 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 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 upgrading an application in
An application container?
A.
An application root clone gets created automatically.
B.
The upgrade can be performed when connected either to CDB$ROOT or to
PDB$SEED.
C.
After an application upgrade, the application container's PDBs remain
Synchronized with the existing application root.
D.
The upgrade must be performed when connected to CDB$ROOT.
E. An application name and version number must be specified to upgrade the
Application.
F. After an application upgrade, the application container's PDBs are
Automatically synchronized with the application root clone.
[不定项选择题]Choose three. Which three are true about RMAN archival backups with
The RESTORE POINT clause?
A. They are never considered obsolete by RMAN.
B. They can optionally be written to a fast recovery area (FRA).
C. All archive logs are retained after an archival backup is taken, until the next
Archival backup is taken of the same database.
D. 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.
E. The SPFILE is included in the archival backup.
F. Use of a recovery catalog is always required to support the creation and use of
Archival backups.
G. The ARCHIVAL attribute for a backup overrides the RMAN retention policy.
[不定项选择题]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 configuring CONTROLFILE
AUTOBACKUP by using RMAN?
A. The control file is backed up whenever a new tablespace is created.
B. The server parameter file (SPFILE) is automatically backed up each time the
Control file is backed up.
C. The control file is backed up automatically each time the SPFILE is backed up
Manually.
D. The control file is backed up whenever a new table is created.
E. It requires the use of fast recovery area (FRA).
F. The control file is backed up whenever an RMAN backup is successfully
Recorded in the catalog.
[不定项选择题]Choose three. Which three are true about Audit policies in container
Databases (CDBs)?
A. All audit records are written to the audit trail in CDB$ROOT .
B. Application-common unified audit policies defined in an application root must
Be manually synchronized by each application PDB contained in the application
Root.
C. Fine-grained auditing policies defined in an application root must be manually
Synchronized by each application PDB contained in the application root.
D. A common unified audit policy can be created at the CDB level.
E. A common unified audit policy can be created at the application root level.
F. An application PDB cannot have a local audit policy.
[不定项选择题]Choose three.
Which three are true about SGA memory management in a multitenant
Database?
A. SGA_MIN_SIZE cannot be set for a PDB.
B. Setting SHARED_POOL_SIZE for a PDB guarantees a minimum amount of
Shared Pool memory for that PDB.
C. Setting SGA_TARGET for a PDB guarantees a minimum amount of SGA
Memory for that PDB.
D. The SHARED_POOL_SIZE setting for a PDB can be up to 80% of the
SHARED_POOL_SIZE setting of the root container.
E. Setting DB_CACHE_SIZE for a PDB guarantees a minimum amount of Database
Buffer Cache memory for that PDB.
F. The SGA_TARGET setting for a PDB cannot exceed 50% of the SGA_TARGET
Value of the root container.
[不定项选择题]Choose three.
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.
Some messages in the error stack are not errors.
C.
If an RMAN command fails, the output will identify the channel ID where the
Failure occurred.
D.
Media Management errors appear as a line with "Additional information" and
A number.
E. Media Management errors appear as a line with "sbtio" and a number.
F. Media Management errors appear as a line with "sbtio".
[不定项选择题]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.