更多"[不定项选择题]Which three are true about "的相关试题:
[不定项选择题]Which three are true about Database Point-in-Time Recovery? (Choose
Three.)
A.
The database must have FLASHBACK DATABASE ON to perform Database
Point-in-Time Recovery.
B.
The database must be in MOUNT state when performing Database
Point-in-Time Recovery.
C.
Database Point-in-Time Recovery is performed by the Managed Recovery Process (MRP)
D.
The Database must be in ARCHIVELOG mode.
E. The target point for the recovery must be specified as a stime or System
Change Number (SCN).
F.
The database must be open RESETLOGS after Database Point-in-Time Recovery.
[不定项选择题]Which three are true about using an RMAN Recovery Catalog with a
Pluggable database (PDB) target connection in Oracle Database 19c and
Later releases?(Choose three.)
A.
The base catalog owner must give the Virtual Private Catalog access to
Metadata for one or more PDBs.
B.
The base catalog must be enabled for Virtual Private Catalog use.
C.
The target PDB must be registered in a base catalog.
D.
The base catalog must be used by RMAN when performing point-in-time
Recovery for the PDB registered in the Virtual Private Catalog.
E. The target PDB must be registered in a Virtual Private Catalog.
F.
The target PDB must be registered in both the base catalog and the Virtual Private Catalog.
[不定项选择题]Which two are true about Oracle Database Configuration Assistant
(DBCA) templates? (Choose two.)
A. The General Purpose of Transaction Processing templates are most suitable
When concurrency and recoverability are key criteria.
B. Oracle DBCA templates can store only logical structure and not database files.
C. New templates can only be created by modifying an existing user-created
Template.
D. The Data Warehouse template is most suitable when transaction response
Time is the key criterion.
E. Oracle DBCA templates can be used to create new databases and duplicate
Existing databases.
[不定项选择题]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.
[不定项选择题]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 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 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 recovery operations done
Without using Recovery Manager (RMAN)?
A. A lost PFILE can be re-created from alert.log using SQL*PLUS.
B. A lost index tablespace can be re-created without performing any recovery.
C. A lost password file can be manually re-created with the orapwd utility.
D. A lost password file can be re-created with SQL*PLUS.
E. A lost SPFILE can be recovered from memory using SQL*PLUS.
F. A lost TEMPFILE must always be re-created manually.
[不定项选择题]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 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 actions that can or cannot be performed by users
With the SYSBACKUP privilege?
A.
They can view data from any data dictionary view or dynamic performance
View.
B.
They can drop any tablespace.
C.
They can view data from any user-defined tables.
D.
They can create any table.
E.
They cannot create restore points.
F.
They cannot drop tablespaces.
[不定项选择题]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.
[不定项选择题]Choose three. Which three are true about the FLASHBACK DATABASE
Feature?
A. FLASHBACK DATABASE only uses FLASHBACK LOGS to get the database to
The desired flashback time.
B. It requires that the target database be in ARCHIVELOG mode.
C. FLASHBACK LOGS are archived after a log switch.
D. A database can be flashed back using SQL*PLUS.
E. It always generates REDO and UNDO.
F. Queries and DML have the same FLASHBACK LOG overhead when flashback is
Enabled for a database.
[不定项选择题]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.
