Which three statements are true abou

多选题
Which three statements are true about Flashback Database?

A、 Flashback logs are written sequentially, and are archived.

B、 Flashback Database uses a restored control file to recover a database.

C、 The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery
Area.

D、 Flashback Database can recover a database to the state that it was in before a reset logs operation.

E、 Flashback Database can recover a data file that was dropped during the span of time of the flashback.

F、 Flashback logs are used to restore to the blocks' before images, and then the redo data may be used
To roll forward to the desired flashback time.

查看答案

下载APP答题

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

相关试题

单选题 You notice that the performance of your production 24/7 Oracle 12c database has significantly degraded.
Sometimes you are not able to connect to the instance because it hangs. You do not want to restart the
Database instance.
How can you detect the cause of the degraded performance?

A、 Enable Memory Access Mode, which reads performance data from SGA.

B、 Use emergency monitoring to fetch data directly from SGA for analysis.

C、 Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic
Workload Repository (AWR) snapshots.

D、 Use Active Session History (ASH) data and hang analysis in regular performance monitoring,

E、 Run ADDM in diagnostic mode.

查看答案

单选题 You notice performance degradation in your production Oracle 12c database. You want to know what
Caused this performance difference.
Which method or feature should you use?

A、 Database Replay

B、 Automatic Database Diagnostic Monitor (ADDM) Compare Period report

C、 Active Session History (ASH) report

D、 SQL Performance Analyzer

查看答案

单选题
RMAN is connected to a target database instance and an auxilary instance.
You execute the command:
RMAN> DUPLICATE TARGET DATABASE TO dupdb FROM ACTIVE DATABASE SECTION SIZE 1G;
What is the outcome?

A、 RMAN uses the pull method to restore files using image copies

B、 RMAN uses the push method to transfer image copies

C、 RMAN uses the push method to transfer backup sets

D、 RMAN uses the pull method to restore files using backup sets

查看答案

单选题 Aplication PDBs, SALES_APP1 and SALES_APP2, must be created and they must access common
Tables of the SALES _APP application.
Examine these steps:
1 Install the SALES_APP application, induding the common tables, in the application root.
2 Install the SALES_APP application in the application root and the common tables in both the CDB root
And the application root.
3 Create an application seed.
4 Install the SALES_APP application in the application seed.
5 Create the SALES_APP1 and SALES_APP2 application PDBs.
6 Sync the SALES_APP1 and SALES_APP2 application PDBs with the application root.
7 Sync the SALES_APP1 and SALES_APP2 application PDBs with the application seed.
8 Sync the application seed with the application root.
Which are the minimum required steps in the correct sequence?

A、 1,3,5,7

B、 2,5,6

C、 1,5,6

D、 3,4,1.6,8

E、 1,3,5,6,7

查看答案

单选题
You must transport the UNIVERSITY tablespace from one database to another. The UNIVERSITY
Tablespace is currently open read/write.
The source and destination platforms have different endian formats. Examine this list of actions:
1 Make the UNIVERSITY tablespace read-only on the source system.
2 Export the UNIVERSITY tablespace metadata using EXPDP.
3 Convert the UNIVERSITY tablespace data fies to the destination platform format using RMAN on the
Source system.
4 Copy the UNIVERSITY tablespace data files to the destination system.
5 Copy the Data Pump dump set to the destination system.
6 Convert the UNIVERSITY tablespace data files to the destination platform format using RMAN on the
Destination system.
7 Import the UNIVERSITY tablespace metadata using IMPDP.
8 Make the UNIVERSITY tablespace read/write on the destination system.
Which is the minimum number of actions required, in the correct order, to transport the UNIVERSITY
Tablespace?

A、 1, 2, 4, 5, 7, 8

B、 1, 2, 4, 6, 7, 8

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

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

E、 2, 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$SESSION_EVENT

B、 V$SESSTAT

C、 V$SESSION_WAIT

D、 V$SESSION_WAIT_CLASS

E、 V$SESSION

查看答案

单选题 You notice that the performance of your production 24x7 Oracle 12c database has significantly degraded.
Sometimes, you are not able to connect to the database instance because it hangs.
How can you detect the cause of the degraded performance?

A、 by performing emergency monitoring using Real-Time Automatic Database Diagnostic Monitor (ADDM)to fetch data directly from SGA for analysis

B、 by running ADDM to fetch information from the latest Automatic Workload Repository (AWR)
Snapshots

C、 by using Active Session History (ASH) data and performing hang analysis

D、 by running ADDM in diagnostic mode

查看答案

单选题
Choose the best answer You want to create a duplicate database DUP_DB from your production database
PROD on the same host.
The PROD database uses Automatic Storage Management (ASM) for storage.
Regular backups are taken using RMAN connected to a recovery catalog.
You create an auxiliary instance and want to execute the command:
RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE;
What is a prerequisite for the successful execution of this command

A、 RMAN must be connected to the target database instance and the auxiliary instance.

B、 A most recent backup set of the PROD database must exist.

C、 Flashback must be enabled for the PROD database.

D、 The target database must be in MOUNT state.

查看答案