Oracle 1z0-067 問題集

質問 1：
Examine the command used to perform an incremental level-0 backup:
RMAN>BACKUP INCREMENTAL LEVEL0 DATABASE;
To enable block change tracking, after the incremental level 0 backup, you issue the command:
SQL>ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING
FILE'/mydir/rman_change_track.f';
To perform an incremental level-1 cumulative backup, you issue the command:
RMAN>BACKUP INCREMENTAL LEVEL1 CUMULATIVE DATABASE;
Which two statements are true in the preceding situation?
A. The incremental level 1 backup fails because a block change tracking file Is created after the level 0 backup.
B. The block change tracking data is used only from the next incremental backup.
C. The incremental level 1 backup does not use change tracking data for accomplishing the backup.
D. The block change tracking data is used for the next incremental level 1 backup only after the next level
0 backup.
E. The block change tracking file scans all blocks and creates a bitmap for the blocks backed up in the level
0 backup.
正解：C,D

質問 2：
Examine the command to create a pluggable database (PDB):
SQL> CREATE PLUGGABLE DATABASE pdb2 FROM pdb1
FILE_NAME-_CONVERT = ('/disk1/oracle/pdb1/', '/disk2/oracle/pdb2/') PATH_PREFIX =
'/disk2/oracle/pdb2';
Which two statements are true?
A. The tablespace specifications of pdb2 are the same as pdb1.
B. All database objects belonging to common users in PD3I are cloned in PD32.
C. pdb2 is created with its own private undo and temp tablespaces.
D. Details about the metadata describing pdb2 are stored in an XML file in the '/disk2/oracle/pdb2/' directory.
E. The pluggable database pdb2 is created by cloning pdb1 and is in mount state.
正解：A,E
解説: (Topexam メンバーにのみ表示されます)

質問 3：
You create a new database by using the CREATE DATABASE command in SQL*Plus, with the ENABLE PLUGGABLE DATABASE clause specified.
Which statement is true about the database that is created? (Choose the best answer.)
A. It is created as a non-CDB that becomes a CDB after the first PDB is plugged in.
B. It is created as a CDB with the CDB$ROOT and PDB$SEED databases.
C. It is created as a PDB that must be plugged into an existing CDB.
D. It is created as a container database (CDB) with CDB$ROOT, PDB$SEED, and a pluggable database (PDB).
正解：B

質問 4：
Your database is running in archivelog mode and a nightly backup of the database, along with an autobackup of the control file, is taken by using RMAN. Because of a media failure, the SPFILE and the control files are lost.
Examine the steps to restore the SPFILE and the control file to mount the database:
1. Set DBID of the target database in RMAN.
2. Start the database instance by using the STARTUP FORCE NOMOUNT command in RMAN.
3. Restore the control files from the backup.
4. Mount the database.
5. Restore the SPFILE from the autobackup.
6. Create a PFILE from the recovered SPFILE.
7. Restart the instance in NOMOUNT state.
Identify the required steps in the correct order.
A. 2, 1, 5, 7, 3, 4
B. 1, 2, 3, 5, 6, 4
C. 1, 2, 5, 3, 6, 4
D. 2, 1, 5, 6, 7, 4, 3
正解：A

質問 5：
Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?
A. In a PDB plan, subplans may be used with up to eight consumer groups.
B. If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.
C. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.
D. If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.
E. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB.
正解：C,D
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Which three statements are true about common roles? (Choose three.)
A. Only system privileges can be granted to a common role to a container database (CDB)
B. A common user that is granted a common role can grant the role to other common and local users in a PDB
C. Object privileges can be granted to a common role in a pluggable database (PDB)
D. A common rule cannot be created by a local user
E. A common role can be granted only to a common user
正解：B,C,D

質問 7：
In your database, the tbs percent used parameter is set to 60 and the tbs percent free parameter is set to 20.
Which two storage-tiering actions might be automated when using Information Lifecycle Management (ILM) to automate data movement?
A. The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS percent used
B. Taking the target tablespace offline after the segments are moved
C. The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used
D. Setting the target tablespace to read-only after the segments are moved
E. The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used
正解：A,D
解説: (Topexam メンバーにのみ表示されます)