In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy
waits. The database consists of locally managed tablespaces with free list managed segments.
On further investigation, you find that buffer busy waits is caused by contention on data blocks.
Which option would you consider first to decrease the wait event immediately?

• A.Decreasing PCTUSED
• B.Decreasing PCTFREE
• C.Increasing the number of DBWN process
• D.Using Automatic Segment Space Management (ASSM)
• E.Increasing db_buffer_cache based on the V$DB_CACHE_ADVICE recommendation

Comment: *

Name: *

Email: *

Verification: *

You notice a performance change in your production Oracle database and you want to know which change has made this performance difference.
You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation.
Which three findings would you get from the report? (Choose three.)

• A.It detects any configuration change that caused a performance difference in both time periods.
• B.It identifies any workload change that caused a performance difference in both time periods.
• C.It detects the top wait events causing performance degradation.
• D.It shows the resource usage for CPU, memory, and I/O in both time periods.
• E.It shows the difference in the size of memory pools in both time periods.
• F.It gives information about statistics collection in both time periods.

Comment: *

Name: *

Email: *

Verification: *

Examine the command to perform a data pump export operation on a source database:
$> expdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp
VIEWS_AS_TABLE=emp_dept
On the target database, you execute the data pump import command:
$> impdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp
VIEWS_AS_TABLE=emp_dept
Which three statements are true? (Choose three.)

• A.Objects dependent on the EMP_DEPT view are exported.
• B.The expdpoperation exports data that satisfies the condition of the defining query used to create the EMP_DEPT view.
• C.All rows from the dependent objects, along with the metadata required to create the
  EMP_DEPT view, are exported.
• D.The impdp operation creates EMP_DEPT as table and populates it with the data from the export dump file.
• E.The impdp operation creates the view and dependent objects.

Comment: *

Name: *

Email: *

Verification: *

You execute the commands:

Which two statements are true?

• A.The create usercommand fails if any role with the name Sidney exists in the database.
• B.The user Sidneycan connect to the database instance but cannot perform sort operations because no space quota is specified for the temptablespace.
• C.The user Sidneyis created but cannot connect to the database instance because no profile is default.
• D.The user Sidneycan connect to the database instance but requires relevant privileges to create objects in the userstablespace.
• E.The user Sidneyis created and authenticated by the operating system.

Comment: *

Name: *

Email: *

Verification: *

You enabled an audit policy by issuing the following statements:
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM;
For which database users and for which executions is the audit policy now active? Select two.

• A.SYS, SYSTEM
• B.SCOTT
• C.Only for successful executions
• D.Only for failed executions
• E.Both successful and failed executions

Comment: *

Name: *

Email: *

Verification: *