Examine the current value for the following parameters in your database instance:
SGA_MAX_SIZE = 1024M
SGA_TARGET = 700M
DB_8K_CACHE_SIZE = 124M
LOG_BUFFER = 200M You issue the following command to increase the value of DB_8K_CACHE_SIZE:
SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M;
Which statement is true?

• A.It fails because the DB_8K_CACHE_SIZE parameter cannot be changed dynamically.
• B.It succeeds only if memory is available from the autotuned components if SGA.
• C.It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET.
• D.It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE.

Comment: *

Name: *

Email: *

Verification: *

You want to capture column group usage and gather extended statistics for better cardinality estimates for the CUSTOMERS table in the SH schema.
Examine the following steps:
1. Issue the SELECT DBMS_STATS.CREATE_EXTENDED_STATS (‘SH’, ‘CUSTOMERS’) FROM dual statement.
2. Execute the DBMS_STATS.SEED_COL_USAGE (null, ‘SH’, 500) procedure.
3. Execute the required queries on the CUSTOMERS table.
4. Issue the SELECT DBMS_STATS.REPORT_COL_USAGE (‘SH’, ‘CUSTOMERS’) FROM dual statement.
Identify the correct sequence of steps.

• A.3, 2, 1, 4
• B.2, 3, 4, 1
• C.4, 1, 3, 2
• D.3, 2, 4, 1

Comment: *

Name: *

Email: *

Verification: *

In your multitenant container database (CDB) containing same pluggable databases (PDBs), you execute the following commands in the root container:

Which two statements are true? (Choose two.)

• A.The C # # ROLE1 role is created in the root database and all the PDBs.
• B.The C # # ROLE1 role is created only in the root database because the container clause is not used.
• C.Privileges are granted to the C##A_ADMIN user only in the root database.
• D.Privileges are granted to the C##A_ADMIN user in the root database and all PDBs.
• E.The statement for granting a role to a user fails because the CONTAINER clause is not used.

Comment: *

Name: *

Email: *

Verification: *

What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated
Maintenance Task?

• A.creation of materialized views to improve query performance
• B.SQL profile recommendations
• C.statistics recommendations
• D.SQL statement restructure recommendations

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true concerning unplugging a pluggable database (PDB)?

• A.The PDB must be open in read only mode.
• B.The PDB must be dosed.
• C.The unplugged PDB becomes a non-CDB.
• D.The unplugged PDB can be plugged into the same multitenant container database (CDB)
• E.The unplugged PDB can be plugged into another CDB.
• F.The PDB data files are automatically removed from disk.

Comment: *

Name: *

Email: *

Verification: *