Oracle认证考试多项选择题每日一练(2020.01.15)

A. The ADR base keeps all diagnostic information in binary format
B. SQL*Plus provides the ADRI script， which can be used to work with ADR
C. The ADR can be used for problem diagnosis only when the database is open
D. The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to null
E. The ADR can be used for problem diagnosis even when the database instance is down
F. The ADR base is shared across multiple instances

A. The database must be started in the MOUNT EXCLUSIVE state.
B. The database must have multiplexed control files.
C. The database must be opened by using a text-based parameter file instead of a server parameter file （SPFILE）.
D. The database must be in ARCHIVELOG mode.
E. The database must be in the NOMOUNT state.
F. The database must be opened in RESTRICTED mode.

A.Disable automatic checkpoint tuning.
B.Check the size of the redo log file size and increase the size if it is small.
C.Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor.
D.Decrease the number of redo log members if there are more than one redo log members available in eachredo log group.

A. You can use this feature to identify the committed versions of the rows， but not the uncommitted versions.
B. You can use this feature to identify the versions of V$ views.
C. You can use this feature to identify the inserts， deletes， and updates performed on a particular row but not the data definition language （DDL） operations performed on the table.
D. You can use this feature for a table only if row movement is enabled for the table.
E. You can use this feature to identify the versions of external and fixed tables.

A. Open the database in read-only mode.
B. Set the retention target with the DB_FLASHBACK_RETENTION_TARGET initialization parameter.
C. Enable the block change tracking feature.
D. Execute the ALTER DATABASE FLASHBACK ON statement.