Oracle Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP - 1z0-067 FREE EXAM DUMPS QUESTIONS & ANSWERS

You wish to enable an audit policy for all database users, except sys, system, and scott. You issue the following statements:
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;
For which database users is the audit policy now active?

You want to create a database and you have the following:
Oracle Grid Infrastructure is installed and configured
Oracle Database Vault is installed in ORACLE_HOME to be used for this database Oracle Enterprise Manager Cloud Control is available and an agent is deployed on the database server Examine the requirements:
Configuring the database instance to support shared server mode
Using Automatic Storage Management (ASM) for storing database files
Configuring a naming method to help a remote user connect to a database instance Configuring the Fast Recovery Area Configuring Database Vault Configuring Enterprise Manager (EM) Database Express Registering with EM Cloud Control Configuring remote log archive destinations Enabling daily incremental backups Configuring a nondefault block size for nondefault block size tablespaces Which of these requirements can be met while creating a database by using the Database Configuration Assistant (DBCA)?

You execute the RMAN commands:
RMAN> BACKUP VALIDATE DATABASE;
RMAN> RECOVER CORRUPTION LIST;
Which task is performed by these commands?

In which three situations must you use a recovery catalog? (Choose three.)

Which two statements are true about tablespaces in multitenant container databases (CDBs)?

Examine the statements that use flashback technologies:
1. FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP ('2013-02-04 09:30:00','YYYY-MM-DD HH:MI:SS');
2. SELECT * FROM customers AS OF SCN 123456;
3. FLASHBACK TABLE customers TO BEFORE DROP;
4. FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP ('2013-02-04 09:30:00','YYYY-MM-DD HH:MI:SS');
5. SELECT * FROM customers VERSIONS BETWEEN SCN 123456 AND 123999;
6. ALTER TABLE customers FLASHBACK ARCHIVE;
Which set of statements depends on the availability of relevant undo data in the undo tablespace? (Choose the best answer.)

You want to reduce fragmentation and reclaim unused space for the sales table but not its dependent objects.
During this operation, you want to ensure the following:
i.Long-running queries are not affected.
ii.No extra space is used.
iii.Data manipulation language (DML) operations on the table succeed at all times throughout the process.
iv.Unused space is reclaimed both above and below the high water mark.
Which alter TABLE option would you recommend?

You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux.
You have set the db_smart_flash_file parameter:
DB_FLASH_CACHE_FILE= ' /dev/f lash_device_1',' /dev/f lash_device_2'
How should the D3_flash_cache_size be configured to use both devices?

For your database, an incremental level 1 backup is taken every week day. On Tuesday, before the backup is performed, you add a new tablespace.
You execute the command:
RMAN> BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG WEEKLY
DATABASE;
Which statement is true about the execution of the command?