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

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

单选题 Examine the statements that use flashback technologies:
1。 FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00',
'YYYY-MM-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 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?

单选题 Choose the best answer. You want to transport the UNIVERSITY tablespace from one
Database to another. The UNIVERSITY tablespace is currently open read/write. The source
And destination platforms have the same endian Examine this list of steps:. 1. Make the
UNIVERSITY tablespace read-only on the source 2. Export the UNIVERSITY tablespace
Metadata using EXPDP. 3. Create a cross-platform backup set from the UNIVERSITY source
System, using an RMAN command that includes the DATAPUMP 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 DATAPUMP clause. 7. Import
The UNIVERSITY tablespace metadata using IMPDP. 8. Make the UNIVERSITY tablespace
Read/write on the destination system. Which are the minimum number of steps required, in the
Correct order, to transport the UNIVERSITY tablespace?

单选题 choose one Examine the RMAN commands:
RMAN> CONNECT TARGET "sbu@prod AS SYSBACKUP";
RMAN> CONNECT AUXILIARY "sbu@dup_db AS SYSBACKUP";
RMAN> DUPLICATE TARGET DATABASE TO dup_db
FROM ACTIVE DATABASE
PASSWORD FILE
SECTION SIZE 400M;
Which statement is true about the DUPLICATE command?

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