Oracle 1z0-067 問題集

質問 1：
In your multitenant container database (CDB) that contains pluggable databases (PDBs), the hr user executes the following commands to create and grant privileges on a procedure:
CREATEORREPLACEPROCEDUREcreate_test_v(v_emp_idNUMBER,v_enameVARCHAR2,v_SALARYNU BEGIN INSERT INTO hr.test VALUES (v_emp_id, v_ename, v salary, v_dept_id); END;
/
GRANT EXECUTE ON CREATE_TEST TO John, jim, smith, king;
How can you prevent users having the execute privilege on the create_test_v procedure from inserting values into tables on which they do not have any privileges?
A. Create the create_test procedure with definer's rights.
B. Create the create_test procedure as part of a package and grant users the execute privilege on the package.
C. Grant the execute privilege to users with grant option on the create_test procedure.
D. Create the create_test procedure with invoker's rights.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 2：
You execute the command to recover your database.

Which statement is true?
A. It restores the control file and all data files from the most recent backup, and then applies the redo logs up to the "until time".
B. It restores all data files, redo log files, and control files, and then applies the redo logs up to the specified time
C. It restores all data files from the specified time, and then applies the redo logs
D. It restores all data files and control files from the most recent backup taken before the "until time", and then recovers up to the "until time" using any restored archieve logs that are needed to complete the task
正解：D

質問 3：
You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). RMAN is connected to CDB$ROOT.
Examine the command:
RMAN> LIST FAILURE;
Which statement is true about this command?
A. It lists failures only for the CDB root database.
B. It lists failures only if RMAN is connected to a PDB.
C. It lists failures for a PDB only when RMAN is connected to a recovery catalog.
D. It lists failures for the CDB and all the PDBs in this CDB.
正解：D

質問 4：
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?
A. DEALLOCATE UNUSED
B. SHRINK SPACE COMPACT
C. ROW STORE COMPRESS BASIC
D. SHRINK SPACE CASCADE
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 5：
As part of a manual upgrade process, after installing the software for Oracle Database 12c and preparing the new Oracle home, you shut down the existing single-instance database.
Which step should you perform next to start the upgrade of the database?
A. Start up the database instance by using the new location of the server parameter file and run the catuppst.sqi script to generate informational messages and log files during the upgrade.
B. Start up the database instance by using the new location of the server parameter file and run the cact1.pl script from the new Oracle home to use parallel upgrade options that reduce down time.
C. Start up the database instance by using the STARTUP UPGRADE command, which opens the existing database, and then performs additional upgrade operations.
D. Start up the database instance by using the STARTUP UPGRADE command and gather fixed object statistics to minimize the time needed for recompilation.
正解：C

質問 6：
You wish to create jobs to satisfy these requirements:
1. Automatically bulk load data from a flat file.
2. Rebuild indexes on the SALES table after completion of the bulk load.
How would you create these jobs?
A. Create both jobs by using Scheduler raised events.
B. Create one job to rebuild indexes using Scheduler raised events and another job to perform bulk load by using events raised by the application.
C. Create both jobs using application raised events.
D. Create one job to rebuild indexes using application raised events and another job to perform bulk load using Scheduler raised events.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 7：
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 メンバーにのみ表示されます)