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?

• A.All historical data older than two years, if any, is purged from the flashback archive FDA1.
• B.All historical data older than two years, if any, is archived to flashback logs and the flashback archive is set to new retention time.
• C.All the flashback data archives are purged and the subsequently created flashback archives are maintained for two years
• D.An error is returned because the retention period cannot be reduced.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about gathering optimizer statistics? (Choose two.)

• A.Executing DBMS_STATS.GATHER_DATABASE_STATSwhile connected to CDB$ROOTgathers object statistics in all open PDBs except PDB$SEED.
• B.Executing DBMS_STATS.GATHER_DATABASE_STATSwhile connected to a PDB opened in read/write mode gathers object statistics for that PDB.
• C.Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in CDB$ROOT.
• D.Executing DBMS_STATS.GATHER_DATABASE_STATSwhile connected to CDB$ROOTgathers object statistics only in CDB$ROOT.
• E.Executing DBMS_STATS.GATHER_DATABASE_STATSwhile connected to CDB$ROOTgathers object statistics in all open pluggable databases (PDBs)

Comment: *

Name: *

Email: *

Verification: *

Choose three. Which three are true about configuring CONTROLFILE AUTOBACKUP by using RMAN?

• A.The server parameter file (SPFILE) is automatically backed up each time the control file is backed up.
• B.It requires the use of fast recovery area (FRA).
• C.The control file is backed up automatically each time the SPFILE is backed up manually.
• D.The control file is backed up whenever a new table is created.
• E.The control file is backed up whenever a new tablespace is created.
• F.The control file is backed up whenever an RMAN backup is successfully recorded in the catalog.

Comment: *

Name: *

Email: *

Verification: *

Which three actions will add a resource to an Oracle Restart configuration? (Choose three.)

• A.creating a disk group using the CREATE DISKGROUP SQL statement
• B.creating a database service using Oracle Database Configuration Assistant (DBCA)
• C.creating a database using the CREATE DATABASE SQL statement
• D.creating a database service using DBMS_SERVICE.CREATE_SERVICE
• E.creating an Oracle Database service by modifying the SERVICE_NAMES parameter
• F.creating an Oracle Automatic Storage Management (ASM) instance with ASM Configuration Assistant (ASMCA)

Comment: *

Name: *

Email: *

Verification: *

Which two are facets of performance planning that should always be considered or implemented for an Oracle Database environment?

• A.using check constraints to speed up updates
• B.defining primary keys for all tables to speed up all queries
• C.defining foreign keys for all tables to speed up joins
• D.the physical data model
• E.the configuration of storage arrays

Comment: *

Name: *

Email: *

Verification: *