Which three statements are true about Automatic Workload Repository (AWR)?

• A.All AWR tables belong to the SYSTEM schema.
• B.The AWR data is stored in memory and in the database.
• C.The snapshots collected by AWR are used by the self-tuning components in the database
• D.AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.
• E.AWR contains systemwide tracing and logging information.

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true concerning the multitenant architecture?

• A.Each pluggable database (PDB) has its own set of background processes.
• B.A PDB can have a private temp tablespace.
• C.PDBs can share the sysaux tablespace.
• D.Log switches occur only at the multitenant container database (CDB) level.
• E.Different PDBs can have different default block sizes.
• F.PDBs share a common system tablespace.
• G.Instance recovery is always performed at the CDB level.

Comment: *

Name: *

Email: *

Verification: *

In your multitenant container database (CDB) containing pluggable databases (PDB), users complain about performance degradation.
How does real-time Automatic database Diagnostic Monitor (ADDM) check performance degradation and provide solutions?

• A.It collects data from SGA and compares it with a preserved snapshot.
• B.It collects data from SGA, analyzes it, and provides a report.
• C.It collects data from SGA and compares it with the latest snapshot.
• D.It collects data from both SGA and PGA, analyzes it, and provides a report.

Comment: *

Name: *

Email: *

Verification: *

Your multitenant container database (CDB) is running in ARCHIVELOGmode. You connect to the CDB RMAN.
Examine the following command and its output:

You execute the following command:
RMAN > BACKUP DATABASE PLUS ARCHIVELOG;
Which data files will be backed up?

• A.Data files that belong to only the root container
• B.Data files that belong to the root container and all the pluggable databases (PDBs)
• C.Data files that belong to only the root container and PDB$SEED
• D.Data files that belong to the root container and all the PDBs excluding PDB$SEED

Comment: *

Name: *

Email: *

Verification: *

You are connected to a pluggable database (PDB) as a common user with DBA privileges.
The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following:
SQL > ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = '*' SCOPE = SPFILE;
Which is true about the result of this command?

• A.The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.
• B.The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.
• C.The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted.
• D.Nothing happens; because there is no SPFILE for each PDB, the statement is ignored.

Comment: *

Name: *

Email: *

Verification: *