Oracle 1Z0-060 : Upgrade to Oracle Database 12c

An application accesses a small lookup table frequently.
You notice that the required data blocks are getting aged out of the default buffer cache.
How would you guarantee that the blocks for the table never age out?

• A. Configure the RECYCLE bufferpool and alter the table with the corresponding storage clause.
• B. Configure Automatic Memory Management-
• C. Configure Automata Shared Memory Management.
• D. Configure the KEEP buffer pool and alter the table with the corresponding storage clause.
• E. Increase the database buffer cache size.

In your Oracle 12c database, you create two roles: AUDITORand AUDIT_ADMIN. You then execute the following commands:

To create a privilege analysis policy for the AUDIT_ADMINrole, you execute the following PL/SQLblock:

Which statement is correct about the procedure?

• A. It always captures the use of the CREATE VIEW and CREATE TABLE privileges.
• B. It captures the use of the privileges used through the AUDIT_ADMIN and AUDITOR roles when the module is used.
  ACCOUNT PAYABLE
• C. It always captures the use of the privileges exercised through the AUDITOR and AUDIT_ADMIN roles.
• D. It only captures the use of the privileges used through the AUDIT_ADMIN role when the ACCOUNT module is used.
  PAYABLE

You use a recovery catalog for maintaining your database backups.
You execute the following command:

Which two statements are true? (Choose two.)

• A. Checks are performed for logical corruptions.
• B. Backup sets containing both data files and archive logs are created.
• C. Checks are performed to confirm whether all database files exist in correct locations
• D. Checks are performed for physical corruptions.
• E. Corrupted blocks, if any, are repaired.

Which two statements are true about the use of the procedures listed in the v$sysaux_occupants.move_procedure column?

• A. All the components may be moved from the SYSAUX tablespace.
• B. The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.
• C. The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.
• D. All the components may be moved into SYSAUX tablespace.

Your multitenant container (CDB) contains two pluggable databases (PDB), HR_PDB and ACCOUNTS_PDB, both of which use the CDB tablespace. The temp file is called temp01.tmp.
A user issues a query on a table on one of the PDBs and receives the following error:
ERROR at line 1:
ORA-01565: error in identifying file
`/u01/app/oracle/oradata/CDB1/temp01.tmp'
ORA-27037: unable to obtain file status
Identify two ways to rectify the error.

• A. Shutdown the database instance, restore and recover the temp file from the backup, and then open the database with RESETLOGS.
• B. Shut down the database instance, restore the temp01.tmp file from the backup, and then restart the database.
• C. Shut down the database instance and then restart the CDB and PDBs.
• D. Take the temporary tablespace offline, recover the missing temp file by applying redo logs, and then bring the temporary tablespace online.
• E. Add a new temp file to the temporary tablespace and drop the temp file that that produced the error.