Oracle 1z0-063 問題集

質問 1：
Which activity is audited by default and recorded in the operating system audit trail irrespective of whether or not database auditing is enabled?
A. execution of SQL statements by users connected with the SYSDBA privilege
B. configuration of unified auditing mode
C. creation of a fine grained audit policy
D. usage of the AUDIT statement
正解：D

質問 2：
One of your databases supports a data warehousing workload and is in NOARCHIVELOG mode. You perform RMAN level 0 backup on Sundays and level 1 incremental backups on other days.
One data file is corrupt and the current online redo log is missing due to media failure.
Which four actions must you take for recovery? (Choose four.)
A. Restore the control file.
B. Restore all data files.
C. Open the database by using the RESETLOGS option.
D. Recover the database by using RECOVER DATABASE;
E. Restore the missing data file.
F. Recover the corrupt file by using RECOVER DATAFILE.
G. Recover the database by using RECOVER DATABASE NOREDO;
正解：A,B,C,G

質問 3：
The following parameters are set for your Oracle 12c database instance:
OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE
OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE
You want to manage the SQL plan evolution task manually. Examine the following steps:
1. Set the evolve task parameters.
2. Create the evolve task by using the DBMS_SPM.CREATE_EVOVLE_TASK function.
3. Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASK function.
4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function.
5. Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function.
Identify the correct sequence of steps.
A. 1, 2, 4, 5
B. 1, 2, 3, 4, 5
C. 2, 4, 5
D. 2, 1, 4, 3, 5
正解：D

質問 4：
Which three conditions must be true for unused block compression to be used automatically while performing backups by using RMAN? (Choose three.)
A. The fast recovery area is less than 50 percent free.
B. The tablespaces are locally managed.
C. There are no guaranteed restore points defined for the database.
D. The default device for the backup must be set to disk.
E. The COMPATIBLE initialization parameter is set to 10.2 or higher.
正解：B,C,E

質問 5：
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. Flush the shared pool.
B. Re-connect the sessions that access objects with redaction policies defined on them.
C. Restart the database instance.
D. Re-create redaction policies that use FULL data redaction.
E. Re-enable redaction policies that use FULL data redaction.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 6：
A complete database backup to media is taken for your database every day. Which three actions would you take to improve backup performance? (Choose three.)
A. Configure large pool if not already done.
B. Always use synchronous I/O for the database.
C. Remove the rate parameter, if specified, in the allocate channel command.
D. Always use RMAN compression for tape backups rather than the compression provided by media manager.
E. Set the dbwr_io_slaves parameter to a nonzero value if synchronous I/O is in use.
F. Set the backup_tape_io_slaves parameter to true.
正解：A,C,E