Automatic Shared Memory Management is enabled for your database instance. You notice that there are SQL statements performing poorly because of repeated parsing activity.
Which action generates recommendations to overcome the performance issues?

• A. running the Memory Advisor for the SGA
• B. running the Memory Advisor for the buffer cache
• C. running the Memory Advisor for the PGA
• D. running the Memory Advisor for the library cache

Which two would you recommend to an application developer for reducing locking conflicts on tables in an Oracle database? (Choose two.)

• A. Create objects in locally managed tablespaces with Automatic Segment Space Management (ASSM) enabled.
• B. Allow the database to handle locks ln default locking mode.
• C. Create objects in locally managed tablespaces with manual segment space management enabled.
• D. Avoid coding long-running transactions.
• E. Enable undo retention guarantee.

Your database is running in ARCHIVELOG mode.
You want to take a consistent whole database backup.
Which two statements are true in this scenario? (Choose two.)

• A. Consistent RMAN backups can be taken while the database is open.
• B. User-managed backups only contain formatted data blocks.
• C. The database must be in MOUNT state to take consistent RMAN backups.
• D. The database instance must be shut down to take a user-managed consistent backup.
• E. RMAN backups contain only data files.

Your database instance has the following parameter setting:
OS_AUTHENT_PREFIX = OPS$
You execute the following command:

And then grant OPS$GUEST_USER the CREATE SESSION privilege.
Which two statements are true? (Choose two.)

• A. GUEST_USER can query the tables created in the USERS tablespace by default.
• B. GUEST_USER can log on to the database without specifying a username and password.
• C. GUEST_USER is forced to change the password at the first login.
• D. The authentication details for GUEST_USER are stored in the database password file.
• E. A local GUEST_USER OS account should exist before GUEST_USER can log on to the database.

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 an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET.
• B. It fails because the DB_8K_CACHE_SIZE parameter cannot be changed dynamically.
• C. It succeeds only if memory is available from the autotuned components if SGA.
• D. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE.