Online Access Free 1Z0-052 Exam Questions

View Exhibit1 and Exhibit2 to examine the current memory allocation and parameter settings, respectively. Why are advisors not available for the shared pool and the buffer cache?
09 (exhibit):

10 (exhibit):

• A.because the values for the DB_CACHE_SIZE and SHARED_POOL_SIZE parameters were not set initially
• B.because Automatic Memory Management (AMM) is disabled for the database instance
• C.because the DB_CACHE_ADVICE parameter is set to OFF
• D.because Automatic Shared Memory Management (ASMM) is enabled for the database instance

You configured the Flash Recovery Area (FRA) for your database. The database instance is running in ARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area. Which two files are removed automatically if the space is required in the FRA as per the retention policy? (Choose two.)

• A.User managed backups of the data files and control files
• B.Flashback log files
• C.Backups that have become obsolete
• D.Archived redo log files that have multiple copies in a different archive location and not backed up

Examine the following output:

Which two statements about the above index are true? (Choose two.)

• A.It is not used while the index is being rebuilt.
• B.It is ignored by the query optimizer.
• C.The index is automatically rebuilt when used the next time.
• D.The index cannot be rebuilt, and has to be re-created.

Which two types of information can be found in the alert log? (Choose two.)

• A.instance recovery details
• B.a record of all actions performed by SYS and SYSTEM
• C.a record of all DDL statements performed by non-DBA users
• D.values of all initialization parameters whenever an instance is restarted
• E.critical errors encountered by background processes

You want to move all objects of the APPS user in the test database to the DB_USR schema of the production database. Which option of IMPDP would you use to accomplish this task?

• A.REMAP_TABLESPACE
• B.SCHEMAS
• C.TRANSFORM
• D.FULL
• E.REMAP_SCHEMA