Oracle 1z0-067 問題集

質問 1：
In your database, the user SCOTT wants to retrieve the dropped HR.EMPLOYEES table by using the command:
SQL> FLASHBACK TABLE HR.EMPLOYEES TO BEFORE DROP;
What are three prerequisites for this command to succeed? (Choose three.)
A. No other table with the same name should exist in the HR schema.
B. No duplicates of the HR.EMPLOYEES table should exist in the recyclebin of the HR schema.
C. The recycle bin should be enabled.
D. Undo retention guarantee must be enabled.
E. SCOTT should have the FLASHBACK ANY TABLE privilege.
F. SCOTT should have the SELECT privilege on the HR schema and its recyclebin.
正解：C,E,F

質問 2：
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

質問 3：
Examine the query and its output executed in an RDBMS instance:

Which three statements are true about the users (other than SYS) in the output? (Choose three.)
A. The C##C_ADMIN user can perform the data guard operation with Data Guard Broker
B. The C##B_ADMIN user can perform all backup and recovery operations using RMAN only
C. The C##B_ADMIN user can perform all backup and recovery operations using RMAN or SQL*Plus
D. The C##A_ADMIN user can perform wallet operations
E. The C##D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM)
正解：A,C,E

質問 4：
Examine these parameter values:

There are currently no user defined tablespaces with an 8K or 16K blocksize.
Which statement would return an error?
A. ALTER SYSTEM SET DB_8K_CACHE_SIZE=10M;
B. ALTER SYSTEM SET DB_CACHE_SIZE=50M;
C. ALTER SYSTEM SET DB_16K_CACHE_SIZE=10M;
D. ALTER SYSTEM SET DB_16K_CACHE_SIZE=0;
E. ALTER SYSTEM SET DB_4K_CACHE_SIZE=10M;
正解：A

質問 5：
You execute the RMAN commands:
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk
RMAN> CONFIGURE DEVICE TYPE disk PARALLELISM 2;
RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT "/disk/%U';
RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT "/disk/%U';
RMAN> BACKUP DATABASE;
Which statement is true about the backup set created by the BACKUP command?
A. Two channels are allocated and backup pieces for the backup set are created in both the specified destinations
B. The default channel is allocated and the backup set is created in only one destination
C. Two channels are allocated and two copies of the backup set are taken in parallel in both locations
D. Two channels are allocated and a copy of the backup set is taken in the location specified by CHANNEL 2
正解：A

質問 6：
You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB).
The following are the possible steps to accomplish this task:
1. Place all the user-defined tablespace in read-only mode on the source database.
2. Upgrade the source database to a 12c version.
3. Create a new PDB in the target container database.
4. Perform a full transportable export on the source database with the VERSION parameter set to 12 using the expdp utility.
5. Copy the associated data files and export the dump file to the desired location in the target database.
6. Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options.
7. Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function.
Identify the correct order of the required steps.
A. 1, 5, 6, 4, 3, 2
B. 2, 1, 3, 4, 5, 6, 7
C. 2, 1, 3, 4, 5, 6
D. 1, 4, 3, 5, 6, 7
E. 1, 3, 4, 5, 6, 7
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Examine the commands:
SQL> ALTER SESSION SET RECYCLBIN = ON;
Session altered.
SQL> DROP TABLE emp; --(First EMP table)
Total dropped.
SQL> CREATE TABLE emp (id NUMBER CONSTRAINT emp_id_idx PRIMARY KEY, name VARCHAR2 (15), salary NUMBER(7,2) ); Table created.
You then execute multiple INSERT statements to insert rows into EMP table and drop the table again:
SQL> DROP TABLE emp; -- (Second EMP table)
Table dropped.
SQL> FLASHBACK TABLE emp TO BEFORE DROP;
Which statement is true about the FLASHBACK command?
A. It recovers the structure, data, and indexes of the first emp table.
B. It recovers only the structure of the second emp table.
C. It recovers the structure, data, and indexes of the second emp table.
D. It returns an error because two tables with the same name exist in the recycle bin.
正解：C