多选题 Which two are true about instance recovery?

A、 It is not possible if an archived log is missing

B、 Setting Fasr START Mrrr TARGER to a higher value reduces instance recovery time by causing
The log writer to write more frequently, thereby reducing the number of I/Os needed during
Instance recovery

C、 It is performed automatically after the database is opened; however, blocks requiring recovery
Are not available until they are recovered

D、 Setting FAST START MTTR TARGET to a lower value reduces instance recovery time by
Causing dirty buffers to be written to disk more frequently, thereby reducing the number of I/Os
Needed during instance recovery

E、 It is performed automatically while the database remains in MOUNT state Then the database is
Opened

F、 It is performed by the Recovery Writer (RVWR、background process

查看答案

由4l***18提供分享举报纠错

相关试题

单选题 Which statement correctly describes the SQL profiling performed by the SQL Tuning Advisor?

A、 It is a set of recommendations by the optimizer to create new indexes

B、 It is a set of recommendations by the optimizer to change the access methods used

C、 It is auxiliary information collected by the optimizer for a SQL statement to help use better
Joins orders

D、 It is a set of recommendations by the optimizer to restructure a SQL statement to avoid suboptimal execution plans

E、 It is auxiliary information collected by the optimizer for a SQL statement to eliminate
Estimation error

查看答案

单选题 Examine this configuration

Which table or set of tables will exist after the Flashback operation has completed?

A、 none of the tables, because all three tables will be dropped

B、 CDB1_TAB and APP_PDB1_TAB

C、 CDB1_TAB and APP ROOT_TAB

D、 CDB1_TAB only

E、 CDB1_TAB, APP_ROOT_TAB, and APP_PDB1_TAB

查看答案

单选题 On the 10th of August, you implement an incremental database backup strategy and configure
A recovery window of five days
Level 0 backups are taken on the 10th, 17th, and 24th of August
Differential level 1 incremental backups are taken daily between the level 0 backup
Today is the 26th of August
Which backups will be obsolete?

A、 all backups prior to 24th of August

B、 all backups prior to 17th of August

C、 all backups prior to 10th of August

D、 all backups prior to 22nd of August

E、 all backups prior to 20th of August

查看答案

单选题 A schema owner truncated a table in error and must recover the data
Which Oracle Flashback feature could be used to recover the data?

A、FLASHBACK VERSION QUERY

B、 FLASHBACK TABLE

C、FLASHBACK TRANSACTION

D、 FLASHBACK DATABASE

E、 FLASHBACK DATA ARCHIVE

查看答案

单选题 Which should be tuned first when doing a performance tuning exercise for an Oracle Database
Environment?

A、 log writer performance

B、 SQL statements

C、 database instance memory management and sizes

D、 general operating system health

E、 database writer performance

查看答案

单选题 You want to transport the UNIVERSIRY tablespace from one database to another
The universiry tablespace is currently open read/write
The source and destination platforms have the same endian format
Examine this list of steps:
1 Make the UNIVERSIRY tablespace read-only on the source system
2 Export the UNIVERSIRY tablespace metadata using EXPDP
3 Create a cross-platform backup set from the UNIVERSITY tablespace on the source system,
Using an
RMAN command that includes the DAMAPUMP clause
4 Copy the cross-platform backup sets to the destination system
5 Copy the Data Pump dump set from the source to the destination system
6 Restore the cross-platform backup set on the destination system using an RMAN command that
Includes the pamapump clause
7 Import the UNIVERSIRY tablespace metadata using IMPDP
8 Make the UNIVERSIRY tablespace read/write on the destination system
Which are the minimum number of steps required, in the correct order, to transport the
UNIVERSIRY tablespace?

A、3,4,6

B、1,3,4,6,8

C、1,2,3,4,5,6,7,8

D、2,3,4,5,6,7

查看答案

单选题 A user complains about poor database performance
You want to verify if the user's session has waited for certain types of I/O activity
Which view displays all waits waited on by a session at least once?

A、 V$SESSTAT

B、 V$SESSION WAIT

C、 V$SESSION EVENT

D、 V$SESSION

E、 V$SESSION WAIT CLASS

查看答案

单选题 Examine this configuration:
Which is true?

A、 It will return an error because creation of a local role is not allowed in CDB$ROOT

B、 ROLE1 will be created only in CDBSROOR and App1_ROOT

C、 ROLE1 will be created only in CDBSROOR

D、 It will return an error because common roles must start with c##

E、 ROLE1 will be created in CDBSROOR, PDB1, App1_ Root, and APP1 PDB1

查看答案