choose one You enable Flashback Data Archive for a table for which youwant to track and save all transactions for four years. After some time, therequirement 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', '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-0409: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 theundo tablespace?

Choose the best answer You want to create a duplicate database DUP_DB from your production database PROD on the same host. The PRODdatabase 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

Automatic Shared Memory Management is disabled for one of yourdatabase instances. Some SQL statements perform poorly due to excessivehard parse activity, thereby degrading performance. What would be yournext step?

A user complains about poor database performance. You want to verifyif the user’s session has waited for certain types of I/O activity. Which viewdisplays all waits waited on by a session at least once?

Your production database is running in archivelog mode. You useRMAN with a recovery catalog to back up your database to media and thedatabase is uniquely identified in the recovery catalog. You want to create atest database from the production database and allow the productiondatabase to remain open during the duplicate process. You restore thedatabase backups to a new host with the same directory structure as theproduction database and want to use the recovery catalog for futurebackups after the database is successfully restored to the new host. Howwould you achieve this?

You plan to create a database by using the Database Configuration Assistant (DBCA), with the following specifications: Applications will connectto the database via a middle tier. The number of concurrent userconnections will be high. The database will have mixed workload, with theexecution of complex BI queries scheduled at night. Which DBCA option must you choose to create the database?

Examine the RMAN command:RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;RMAN> BACKUP DATABASE PLUS ARCHIVELOG;Which prerequisite must be met before accomplishing the backup?

Unified auditing is enabled in your database. The HR_ADMIN andOE_ADMIN roles exist and are granted system privileges. You execute thecommand: SQL>CREATE AUDIT POLICY table_aud PRIVILEGES CREATE ANYTABLE, DROP ANY TABLE ROLES hr_admin,oe_admin; Which statement istrue?

In one of your databases, unified auditing is enabled and an SH.SALEStable exists. You successfully execute these commands: SQL> CREATE AUDIT POLICY sales_pol ACTIONS select on sh.sales; SQL> AUDIT POLICYsales_pol; Which statement is true about SALES_POL?

After implementing full Oracle Data Redaction, you change the defaultvalue for the NUMBER data type as follows:SQL> select number_value from REDACTION_VALUES_FOR_TYPE_FULL;NUMBER_VALUE------------ 0SQL> exec DBMS_REDACT.UPDATE_FULL_REDACTION_VALUES(-1);SQL> select number_value from REDACTION_VALUES_FOR_TYPE_FULL;NUMBER_VALUE-------------1 After changing the value, you notice that FULL redaction continues to redactnumeric data with zero.(您注意到 FULL 编校继续以零编校数值数据)也就是上面的修改还没有生效,该命令是把 number 的数据类型编辑以后默认值为-1)。What must you do to activate the new default value for numeric fullredaction?

You are administering a multitenant container database (COB) thatcontains two pluggable databases (PDBs), pdb1 and pdb2. You areconnected to pdb2 as a common user with DBA privileges. Thestatistics_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?

What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE" statement?

Examine the RMAN command:RMAN> RUN { ALLOCATE CHANNEL c1 DEVICE TYPE sbt; ALLOCATE CHANNEL c2 DEVICE TYPE sbt; ALLOCATE CHANNEL c3 DEVICE TYPE sbt; BACKUPINCREMENTAL 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?

Choose the best answer. SQL Performance Analyzer (SPA) has reported several regressed SQLstatements for one of your databases. Which action could help in the performance management of these regressedSQL statements?