While backing up to the Oracle Fast Recovery Area (FRA), you determined the backup is taking too long and suspect a performance bottleneck.
Which three are true about diagnosing and tuning these problems? (Choose three.)

• A.If an RMAN BACKUP VALIDATE command takes roughly the same time as an actual backup, then read I/O is a likely bottleneck.
• B.Data files with a high value in V$BACKUP_ASYNC_IO.SHORT_WAITS are a potential performance bottleneck when asynchronous I/O is used.
• C.Setting DBWR_IO_SLAVESto a non zero value can improve backup performance when using asynchronous I/O/
• D.Setting DBWR_IO_SLAVES to a non zero value can improve backup performance when using synchronous I/O.
• E.Data files with a high value in V$BACKUP_SYNC_IO.DISCRETE_BYTES_PER_SECOND are a potential performance bottleneck when synchronous I/O is used.
• F.If an RMAN BACKUP VALIDATE command takes noticeably less than an actual backup, then write I/O is a likely bottleneck.
• G.If an RMAN BACKUP VALIDATE command takes roughly the same time as an actual backup, then both read and write I/O are likely bottlenecks.

Comment: *

Name: *

Email: *

Verification: *

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?

• A.It fails because no parallel channels are allocated for the auxiliary database.
• B.It succeeds only if the target database is in MOUNT state.
• C.It succeeds and creates multisection backup sets that are used for active database duplication.
• D.It fails because there is no connection to a recovery catalog.

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

Examine this configuration:
1. CDB1 is a container database.
2. APP_ROOT is an application root in CDB1.
3. APP_PDB1 is an application PDB in APP_ROOT.
4. FLASHBACK DATABASE is ON.
You execute these commands:
Which table or set of tables will exist after the Flashback operation has completed?

• A.CDB1_TAB and APP_PDB1_TAB
• B.CDB1_TAB and APP_ROOT_TAB
• C.CDB1_TAB only
• D.CDB1_TAB, APP_ROOT_TAB, and APP_PDB1_TAB
• E.none of the tables, because all three tables will be dropped

Comment: *

Name: *

Email: *

Verification: *

Choose three. Which three are performed by Oracle Automatic Storage Management (ASM) instances?

• A.acting as an I/O server to read data file blocks from ASM disks on behalf of database server processes
• B.managing extent allocation for Oracle database segments
• C.managing space allocation for Oracle ASM files
• D.mounting disk groups
• E.acting as an I/O server to write data file blocks to ASM disks on behalf of Database Writer processes (DBWn)
• F.managing Allocation Units (AUs) for disk group content

Comment: *

Name: *

Email: *

Verification: *