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?

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 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?( )

Applications will connect to the database via a middle tier. 

The number of concurrent user connections will be high. 

The database will have mixed workload, with the execution of complex BI queries scheduled at night.

Which DBCA option must you choose to create the database?( )

RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;

RMAN> BACKUP DATABASE PLUS ARCHIVELOG;

Which prerequisite must be met before accomplishing the backup? ( )

（含图）

After changing the value, you notice that FULL redaction continues to redact numeric data with zero.

What must you do to activate the new default value for numeric full redaction?

You are connected to pdb2 as a common user with DBA privileges.

The statistics_level parameter is PDB modifiable.

As the user sys, execute the following command on pdb2:

SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID='∗' SCOPE=SPFILE;

Which statement is true about the result of this command?( )

RMAN> RUN 

{ALLOCATE CHANNEL c1 DEVICE TYPE sbt;

ALLOCATE CHANNEL c2 DEVICE TYPE sbt; 

ALLOCATE CHANNEL c3 DEVICE TYPE sbt;

BACKUP INCREMENTAL LEVEL = 0 

(DATAFILE 1,4,5 CHANNEL c1)

(DATAFILE 2,3,9 CHANNEL c2)

(DATAFILE 6,7,8 CHANNEL c3);

SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT'; }

Which statement is true about the command? ( )

Which action could help in the performance management of these regressed SQL statements?

Which method would you use?( )