You issue the command to open ACCOUNTS_PDB and find that the USERDATA.DBF data file for the default permanent tablespace USERDATA belonging to ACCOUNTS_PDB is corrupted. 

What should you do before executing the commands to restore and recover the data file in ACCOUNTS_PDB?

1. Mount the CDB. 

2. Close all the PDBs. 

3. Open the database. 

4. Apply the archive redo logs.

5. Restore the data file. 

6. Take the SYSAUX tablespace offline. 

7. Place the SYSAUX tablespace online. 

8. Open all the PDBs with RESETLOGS. 

9. Open the database with RESETLOGS. 

10. Execute the command SHUTDOWN ABORT.

Which option identifies the correct sequence to recover the SYSAUX tablespace?  

How can you detect the cause of the degraded performance?  

How does real-time Automatic database Diagnostic Monitor (ADDM) check performance degradation and provide solutions?

The TNS pina command executes successfully when tested with ORCL: however, from the same OS uselsession, you are not able to connect to the database instance with the following command:

SOL>CONNECT scott/tiger@orcl 

What could be the reason for this?

1. Create a policy to capture the privilege used by a user for privilege analysis2. Generate a report with the data captured for a specified privilege capture.

3.Start analyzing the data captured by the policy.

4.Revoke the unused privileges.

5. Compare the used and unused privileges' lists.

6.Stop analyzing the data.

ldentify the correct sequence of steps.

The following parameter are set in your database instance:

LOG ARCHIVE FORMAT=arch+%t %r.arc

LOG ARCHIVE DEST 1='LOCATION = /disk1/archive'

DB RECOVERY FILE DEST SIZE=50G

DB RECOVERY FILE='u01/oradata’

Which statement is true about the archived redo log files?

Examine the following command and its output:

You execute the following command:

RMAN>BACKUP DATABASE PLUS ARCHIVELOG;:Which data files will be backed up?

the DATA disk group. You execute the following command:

SQL> ALTER DISKGROUP data ADD ALIAS '+data/prod/myfile.dbf' FOR '+data.231.45678'

What is the result?

ALTER SYSTEM SET enable_ddl logging=FALSE:

Which statement is true?

For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and the CONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING. 

What should you do to accomplish this task?

What must you do to receive recommendations about the efficient use of indexes and materialized views to improve query performance?

OPTIMIZER CAPTURE SOL PLAN BASELINES=FALSE

OPTIMIZER USE SOL PLAN BASELINES=TRUE

You want to manage the SOL plan evolution task manually. Examine the following steps:

1. Set the evolve task parameters. 

2. Create the evolve task by using the DBMS_SPM.CREATE_EVOLVE_TASK function. 

3. Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASK function. 

4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function.

5. Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function. 

Identify the correct sequence of steps: 

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?

SGA MAXSIZE=1024M

SGA TARGET=700MDB 8KCACHESIZE=124M

LOG BUFFER=200M

You issue the following command to increase the value of DB_8K_CACHE _SIZE: SQL> ALTERSYSTEM

SET DB 8K CACHE SIZE=140M;

Which statement is true?

You issue the following statements:

 SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS; 

SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM; 

SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT; 

For which database users is the audit policy now active?

After changing the value, you notice that FULL redaction continues to redact numeric data with zero. 

What must you do to activate the new default value for numeric full redaction?

The table does not have a primary key and is used by an OLTP application. 

Which technique will move the table and indexes while maintaining the highest level of availability to the application?