1Z0-063 Free Practice Test

- (Exam Topic 1)
You want to consolidate backup information and centrally manage backup and recovery scripts for multiple databases running in your organization.
Which two backup solutions can be used? (Choose two.)

1. A. RMAN recovery catalog
2. B. RMAN Media Management Library
3. C. Enterprise Manager Cloud Control
4. D. Enterprise Manager Database Express
5. E. Oracle Secure Backup

Correct Answer: AC

- (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?

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

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 2)
Which Oracle Database component is audited by default if the Unified Auditing option is enabled?

1. A. Oracle Data Pump
2. B. Oracle Recovery Manager (RMAN)
3. C. Oracle Label Security
4. D. Oracle Database Vault
5. E. Oracle Real Application Security

Correct Answer: B

- (Exam Topic 1)
Automatic Undo Management is enabled for your database. You want a user to retrieve metadata and historical data for a given transaction or for transactions in a given time interval.
Which three are prerequisites to fulfill this requirement? (Choose three.)

1. A. Minimal supplemental logging must be enabled.
2. B. The database must be running in archivelog mode.
3. C. Flashback Data Archive must be created and the flashback archive administer system privilege must be granted to the user.
4. D. The flashback any table privilege must be granted to the user.
5. E. The select any transaction privilege must be granted to the user.
6. F. The recycle bin parameter must be set to on.

Correct Answer: ABE

- (Exam Topic 2)
You issue the RMAN commands:
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;
RKAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY; RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which three tasks are performed by the BACKUP DATABASE command? (Choose three.)

1. A. switching the online redo log file
2. B. backing up all data files as image copies and archive log files, and deleting those archive log files
3. C. backing up only the used blocks in the data files
4. D. backing up all used and unused blocks in the data files
5. E. backing up all archived log files and marking them as obsolete

Correct Answer: ABD