Online Access Free 1z0-067 Exam Questions

Consider the following scenario for your database:
-Backup optimization is enabled in RMAN.
-The recovery window is set to seven days in RMAN.
-The most recent backup to disk for the tools tablespace was taken on March 1, 2015.
-The tools tablespace is read-only since March 2, 2015.
On March 15, 2015, you issue the RMAN command to back up the database via the Media Manager Interface.
Which statement is true about the backup of the tools tablespace?

• A.The RMAN backup fails because the tools tablespace is read-only.
• B.RMAN creates a backup of the tools tablespace because backup optimization is applicable only for the backups written to media.
• C.RMAN skips the backup of the tools tablespace because backup optimization is enabled.
• D.RMAN creates a backup of the tools tablespace because no backup of the tablespace exists within the seven-day recovery window.

Which statements are true regarding system-partitioned tables? (Choose all that apply.)

• A.All DML statements must use partition-extended syntax.
• B.Unique local indexes cannot be created on a system-partitioned table.
• C.Only a single partitioning key column can be specified.
• D.Traditional partition pruning and partitionwise joins are not supported on these tables.
• E.The same physical attributes must be specified for each partition.

You created a database with DBCA by using one of the Oracle supplied templates.
Which is the default permanent tablespace for all users except DBSNMP and OUTLN?

• A.SYSAUX
• B.SYSTEM
• C.EXAMPLE
• D.USERS

After implementing full Oracle Data Redaction, you change the default value for the number data type as follows:
SQL> SELECT NUMBER_VALUE FROM REDACTION_VALUES_FOR_TYPE_FULL;
NUMBER_VALUE
-------------------------
0
SQL> EXEC DBMS_REDACT.UPDATE_FULL_REDACTI0N_VALUES(-1)
PL/SQL procedure successfully completed.
SQL> select number_value from redaction_values_for_type_full;
NUMBER VALUE
------------------------
-1
After changing the value, you notice that FULL redaction continues to redact numeric data with a zero.
What must you do to activate the new default value for numeric full redaction?

• A.Restart the database instance.
• B.Re-create redaction policies that use FULL data redaction.
• C.Re-connect the sessions that access objects with redaction policies defined on them.
• D.Re-enable redaction policies that use FULL data redaction.
• E.Flush the shared pool.

Your production database is running in archivelog mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recovery catalog.
You want to create a test database from the production database and allow the production database to remain open during the duplicate process. You restore the database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host.
How would you achieve this?

• A.by creating a new database in the new host, and then using the RMAN recover command
• B.by using the RMAN duplicate command with dbid and set newname for tablespace to recover the database to the new host
• C.by using the RMAN duplicate command with no filename check to recover the database to the new host
• D.by using the RMAN switch command to set the new location for the data files