单选题 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?

单选题 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

单选题 choose one you enable Flashback Data Archive for a table for which you want to track and save all transactions for four years. After some time, the requirement changes for keeping transactions from four to two years. you execute the following command to change the requirement: SQL> ALTER FLASHBACK ARCHIVE fdal MODIFY RETENTION 2 YEAR; what is the outcome?

单选题 Examine the statements that use flashback technologies:
1,FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYYMM-DD HH:MI:SS');
2,SELECT * FROM customers AS OF SCN 123456;
3,FLASHBACK TABLE customers TO BEFORE DROP;
4,FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYY-MM-DD
HH:MI:SS');
5,SELECT * FROM customers VERSIONS BETWEEN SCN 123456 AND 123999;
6,ALTER TABLE customers FLASHBACK ARCHIVE;
Which set of statements depends on the availability of relevant undo data in the undo tablespace?

单选题 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?

单选题 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 files 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?

单选题 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?

单选题 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?