- (Exam Topic 1)
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> EXECDBMS_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?
Correct Answer:E
About Altering the Default Full Data Redaction Value
You can alter the default displayed values for full Data Redaction polices. By default, 0 is the redacted value when Oracle Database performs full redaction (DBMS_REDACT.FULL) on a column of the NUMBER data type. If you want to change it to another value (for example, 7), then you can run the DBMS_REDACT.UPDATE_FULL_REDACTION_VALUES procedure to modify this value. The modification applies to all of the Data Redaction policies in the current database instance. After you modify a value, you must restart the database for it to take effect.
- (Exam Topic 1)
You are administering a database that supports data warehousing workload and is running in NOARCHIVELOG mode. You use RMAN to perform a level 0 backup on Sundays and level 1 Incremental backups on all the other days of the week.
One of the data files is corrupted and the current online redo log file is lost because of a media failure. You want to recover the data file.
Examine the steps involved in the recovery process:
1. Shut down the database instance.
2. Start up the database instance in NOMOUNT state.
3. Mount the database.
4. Take the data file offline.
5. Put the data file online.
6. Restore the control file.
7. Restore the database.
8. Restore the data file.
9. Open the database with the RESETLOG option.
10. Recover the database with the NOREDO option.
11. Recover the data file with the NOREDO option. Identify the required steps in the correct order.
Correct Answer:C
- (Exam Topic 1)
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?
Correct Answer:B
- (Exam Topic 2)
You need to perform a block media recovery on the tools01.dbf data file in your database by using Recovery Manager (RMAN).
Which two are prerequisites for performing this operation? (Choose two.)
Correct Answer:CD
The target database must run in ARCHIVELOG mode and be open or mounted with a current control file. The backups of the data files containing the corrupt blocks must be full or level 0 backups. They cannot be
proxy copies or incremental backups.
References: Oracle Database, Backup and Recovery User's Guide, 12 Release 2 (January 2017), page 19-4
- (Exam Topic 2)
In a database supporting an OLTP workload, tables are frequently updated on both key and non-key columns. Reports are also generated by joining multiple tables.
Which table organization or type would provide the best performance for this hybrid workload?
Correct Answer:E