更多"[不定项选择题]Which two are true about du"的相关试题:
[不定项选择题]Which four are true about duplicating a database using Recovery
Manager (RMAN)? (Choose four.)
A. Duplication can be done by having the auxiliary database instance pull backup
Sets from the target database instance.
B. A connection to an auxiliary instance is always required.
C. A subset of the target database can be duplicated.
D. A new DBID is always created for the duplicated database.
E. A connection to the recovery catalog instance is always required.
F. A backup of the target database is always required.
G. Duplication can be done by having the target database instance push copies
To the auxiliary database instance.
H. A connection to the target database instance is always required.
[不定项选择题]choose two Which two are true about RMAN image copies?
A.
) They can only be written to disk.
B.
) They can be encrypted using Transparent Data Encryption (TDE).
C.
) They can be used as a level 0 incremental backup.
D.
) They can be used as a level 1 incremental backup.
E.) They are the only backup option available for databases in NOARCHIVELOG
Mode.
[不定项选择题]Choose two. Which two are true about various Oracle security and
Auditing capabilities?
A.
Application-common Transparent Security Data Protection (TSDP) policies can
Be created only if all the PDBs in the application container are closed.
B.
Application-common TSDP policies are always container specific.
C.
Application-common OLS policies can be created only if all the PDBs in the
Application container are closed.
D.
Unified auditing can be automatically synchronized to all application PDBs in
An application container.
E. Fine-grained auditing (FGA) policies in an application root are automatically
Synchronized to all application PDBs contained in the application container when
They are updated.
[不定项选择题]Choose two. Which two are true about memory advisors?
A.
If Automatic Memory Management is enabled, no memory advisors are
Available.
B.
If Automatic Memory Management is enabled, the Shared Pool Advisor and
Buffer Cache Advisor are available to set the maximum size for these individual
System Global Area components.
C.
All memory advisors use data from Automatic Workload Repository.
D.
If Automatic Shared Memory Management is enabled, both the SGA Advisor
And PGA Advisor are always available.
E. If Manual Shared Memory Management is enabled, only the Shared Pool
Advisor and Buffer Cache Advisor are available.
[不定项选择题]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 diagnosing Oracle Database failure situations
Using Data Recovery Advisor? (Choose two.)
A.
Using the Data Recovery Advisor LIST FAILURE command always requires that
The database for Which failures are to be listed is in MOUNT state.
B.
A failure can be closed only when it has been repaired.
C.
Data Recovery Advisor can be used if a database is closed.
D.
The Data Recovery Advisor CHANGE FAILURE command can be used only to
Change failure priorities.
E. Data Recovery Advisor can proactively check for failures.
[不定项选择题]Which two statements are true about recovering logically corrupted
Tables or table partitions from an RMAN backup?
A. Tables or table partitions can be recovered by using an auxiliary instance only.
B. Tables or table partitions with a foreign key cannot be recovered.
C. Tables or table partitions can be recovered only when the database is in
Mount state.
D. Tables or table partitions from the system and sysaux tablespaces cannot be
Recovered.
E. Tables with not null constraints cannot be recovered.
[不定项选择题]Choose two. Which two are true about PDB archive files?
A. DBMS_PDB.CHECK_PLUG_COMPATIBILITY can be run against a PDB archive.
B. They contain a PDB manifest file and all the data files in uncompressed form
For a PDB.
C. They contain all the data files only in uncompressed form for a PDB.
D. They must be created using the DBMS_PDB package.
E. They contain a PDB manifest file and all the data files in compressed form for a
PDB.
F. They contain all the data files only in compressed form for a PDB.
[不定项选择题]Choose two.
Which two are true about the Optimizer Statistics Advisor?
A.
It always analyzes all schemas in the database.
B.
It can recommend changes to improve the statistics gathering process.
C.
It can be run only manually.
D.
It runs automatically every night by default.
E. It can be run only automatically.
[不定项选择题]Choose two. Which two are true about the Program Global Area (PGA)
And its management in an Oracle database instance?
A.
The entire PGA is located in the System Global Area (SGA) when using shared
Servers.
B.
PGA_AGGREGATE_LIMIT is a hard limit on the PGA size for any one session.
C.
The private SQL area (UGA) is located in the System Global Area (SGA) when
Using dedicated servers.
D.
The private SQL area (UGA) is located in the System Global Area (SGA) when
Using shared servers.
E. Sorts and Hash Joins use PGA memory.
[不定项选择题]Which two are true about RMAN duplexed backup sets? (Choose two.)
A. A duplexed backup set uses the same number of SBT channels as a
Non-duplexed backup set for the same number of files.
B. A non-duplexed backup set written to disk can be duplexed to disk by backing
Up the backup set that is already on disk.
C. A non-duplexed backup set written to SBT can be duplexed to tape by
Backing up the backup set that is already on tape.
D. A non-duplexed backup set written to disk can be duplexed to tape by
Backing up the backup set that is already on disk.
E. A non-duplexed backup set written to SBT can be duplexed to disk by backing
Up the backup set that is already on tape.
F. A duplexed backup set always uses twice as many SBT channels as a
Non-duplexed backup set for the same number of files.
[不定项选择题]Which two are true about backup set compression using RMAN default
Compression? (Choose two.)
A.
Compressed backups can be written only to media.
B.
Binary compression adds CPU overhead to backup operations.
C.
Unused blocks below the high water mark are backed up.
D.
Compressed backups cannot have a section size defined.
E. Compression can be done only for locally managed tablespaces.
[不定项选择题]Which two are true about changing the LOCAL_UNDO_ENABLED
Property to false in a CDB? (Choose two.)
A. After the change, only a common user with the required privilege can create
An undo tablespace in CDB&ROOT.
B. Any new PDB and existing PDBs are automatically configured to use the
Default undo tablespace in CDB$ROOT.
C. After the change, only one undo tablespace can exist in CDB$ROOT.
D. After the change, any user with the required privilege can create an undo
Tablespace in the PDBs.
E. Undo tablespaces existing in PDBs must be dropped before the change.
F. After the change, each existing PDB has to be reopened for the new undo
Mode to take effect.
[不定项选择题]Which two statements are true about RMAN duplexed backups?
A. It is not supported for image copies.
B. It is only supported for backups to tape via the media management interface.
C. Duplex backups can be performed on either disk or media, but cannot be
Performed on media and disk simultaneously.
D. Duplex backups can contain only data files and control files.
E. For performing duplexed backups, the parallelism for the device must be set
Equal to the number of copies.
[不定项选择题]Choose two. Which two are true about Oracle Database Configuration
Assistant (DBCA)?
A. It can only be launched from the command line interface.
B. It can be launched from both the command line and the Universal Installer
(OUI) interfaces.
C. It can be used to create container databases and non-container databases.
D. It can be used to change the character set of an existing database.
E. It can be used to convert a non-container database to a container database.
[不定项选择题]Choose two. Which two are true about RMAN duplexed backup sets?
A. They must be written to media.
B. They can be written only to disk.
C. They can be created only by using the COPIES option of a BACKUP command.
D. They can be created by using the RMAN CONFIGURE command to specify
Duplexing before taking a backup.
E. They can be written to media.
[不定项选择题]Choose two. Which two are true about backup set compression using
RMAN default compression?
A. Compressed backups cannot have a section size defined.
B. Compressed backups can be written only to media.
C. Binary compression adds CPU overhead to backup operations.
D. Unused blocks below the high water mark are backed up.
E. Compression can be done only for locally managed tablespaces.
[不定项选择题]Choose two. Which two are true about Optimizer Statistics?
A. They can be gathered by the DBMS_STATS package.
B. They provide real-time data about schema objects.
C. They are gathered by the SQL Tuning Advisor.
D. They are ignored by Optimizer if they are stale.
E. By default, they are automatically gathered by a maintenance job.
[不定项选择题]Choose two. Which two are true about Rapid Home Provisioning of
Oracle software?
A. It can be used for applications and middleware.
B. It can be used only for Oracle Grid Infrastructure, including Oracle Restart.
C. It can be used for both Oracle Database and Oracle Grid Infrastructure,
Including Oracle Restart.
D. It can be used for both Oracle Database and Oracle Grid Infrastructure,
Excluding Oracle Restart.
E. It can be used only for Oracle Grid Infrastructure, excluding Oracle Restart.
