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?

• A.Database Replay
• B.Automatic Database Diagnostic Monitor (ADDM) Compare Period report
• C.Active Session History (ASH) report
• D.SQL Performance Analyzer

Comment: *

Name: *

Email: *

Verification: *

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

Comment: *

Name: *

Email: *

Verification: *

Which three actions are performed by Database Upgrade Assistant (DBUA)? (Choose three.)

• A.It recompiles all stored PL/SQLcode by using utlrp.sql.
• B.It empties the RECYCLE BIN.
• C.It performs prerequisite checks to verify if the Oracle database is ready for upgrade.
• D.It sets all user tablespaces to "read-only" before starting the upgrade.
• E.It removes the AUDSYS schema and the AUDIT_ADMINand AUDIT_VIEWERroles
• F.It increases tablespace size, if required, to meet upgrade requirements.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about Oracle Grid Infrastructure for a Standalone Server? (Choose two.)

• A.It requires Oracle Automatic Storage Management (ASM) components to be installed separately.
• B.It can manage database resources on the server where it is installed or on a different server.
• C.It must be installed before the Oracle database software is installed.
• D.It supports volume management, file system, and automatic restart capabilities.
• E.The CSS daemon runs from the Grid Infrastructure home.

Comment: *

Name: *

Email: *

Verification: *

Examine this command:
$ rhpctl move database -sourcehome Oracle_home_path -destinationhome Oracle_home_path For which two purposes can you use this command? (Choose two.)

• A.to switch an existing Oracle Database home to a newer release of Oracle software on the same server
• B.to switch to a read-only Oracle home
• C.to switch back to the previous Oracle home as part of a rollback operation
• D.to switch the Oracle Database home when using a centralized Rapid Home Provisioning server
• E.to switch to a patched Oracle Database home

Comment: *

Name: *

Email: *

Verification: *