更多"[不定项选择题]Which three are true about "的相关试题:
[不定项选择题]Which two are true about Optimizer Statistics? (Choose two.)
A. They can be gathered by the DBMS_STATS package.
B. They are gathered by the SQL Tuning Advisor.
C. They provide real-time data about schema objects.
D. They are ignored by Optimizer if they are stale.
E. By default, they are automatically gathered by a maintenance job.
[不定项选择题]Which two are true about Oracle Optimizer Statistics, their use, and
Their collection? (Choose two.)
A. The number of table rows is considered when evaluating the cost of accessing
A table using an index.
B. Index balanced B*Tree height is considered when evaluating the cost of using
An index.
C. The Statistics Advisor can help recommend the best way to gather statistics.
D. Statistics collected using DBMS_STATS always yield the best optimizer result.
E. The Statistics Advisor generates actions for all recommendations.
[不定项选择题]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 a whole database backup?
A. It can be created only by using RMAN.
B. It always includes all data files, the current control file, the server parameter file,
And archived redo logs.
C. It can be consistent.
D. It is the only possible backup type for a database in NOARCHIVELOG mode.
E. It can consist of either backup sets or image copies.
F. It can be inconsistent.
[不定项选择题]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 using Database Upgrade
Assistant (DBUA) to upgrade a database?
A. DBUA must be launched from the target Oracle Home.
B. Multiple databases with the same ORACLE_HOME can be upgraded
Simultaneously.
C. A whole database backup must exist before upgrade.
D. The Pre-Upgrade Information Tool script is executed by DBUA.
E. All pluggable databases are automatically upgraded as part of a container
Database upgrade.
F. The database must be opened in read-only mode.
[不定项选择题]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 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 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 the Oracle Optimizer?
A.
It considers the filters in WHERE clauses when generating execution plans for SQL statements.
B.
It obeys all hints.
C.
It considers object statistics when generating execution plans for SQL statements.
D.
It updates stale object statistics in the Data Dictionary.
E. It can only use SQL Plan Directives tied to the SQL statement for which a plan
Is being generated.
F.
It can re-optimize execution plans after previous executions detect suboptimal plans.
[不定项选择题]Choose three. Which three are true about Rapid Home Provisioning
(RHP), which has been available since Oracle 18c?
A. It can be used to deploy Grid Infrastructure homes, including Oracle Restart.
B. It can be used to deploy Oracle Database homes.
C. It is an Oracle Database service.
D. It cannot be used to provision applications.
E. It cannot be used to provision middleware.
F. It is an Oracle Grid Infrastructure service.
