Oracle 1z0-063 問題集

質問 1：
You want to move your existing recovery catalog to another database.
Examine the steps:
1) Export the catalog data by using the Data Pump Export utility in the source database.
2) Create a recovery catalog user and grant the necessary privileges in the target database.
3) Create a recovery catalog by using the CREATE CATALOG command.
4) Import the catalog data into the new recovery catalog by using the Data Pump Import utility in the target database.
5) Import the source recovery catalog schema by using the RMAN IMPORT CATALOG command.
6) Connect to the destination database.
7) Connect as CATALOG to the destination recovery catalog schema.
Identify the option with the correct sequence for moving the recovery catalog.
A. 1, 2, 3, 6, 5
B. 2, 3, 7, 5
C. 1, 2, 6, 4
D. 1, 6, 4
正解：C

質問 2：
You issued these commands for one of your databases:
RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE;
RMAN> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING
FILE '/mydir/rman_change_track.f';
RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;
Which two are true? (Choose two.)
A. The cumulative incremental level 1 database backup fails.
B. Future incremental level 0 database backups will reference the block change tracking file.
C. Future cumulative incremental level 1 database backups will reference the block change tracking file.
D. The block change tracking file will be updated automatically after creation to refer to modified blocks contained in the incremental level 0 database backup.
E. The cumulative incremental level 1 database backup ignores the block change tracking file.
正解：C,D

質問 3：
Which two operations are NOT performed by the DUPLICATE command in RMAN while duplicating a database that is open? (Choose two.)
A. copying online redo log files from the target database to the duplicate database
B. generating a new, unique database identifier (DBID) for the duplicate database
C. performing complete recovery by using all available backups
D. creating a control file for the duplicate database
E. restoring target data files to the duplicate database
正解：A,C

質問 4：
You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB).
Examine the steps required to perform the migration:
1. Use Data Pump export to perform a full transportable export on the source database with the export parameter VERSION=12.
2. Place all tablespaces in read-only mode on the source database.
3. Upgrade the source database to Oracle Database 12c.
4. Copy the dump file and data files to the desired location in the target database.
5. Create a new PDB in the target CDB.
6. Synchronize the PDB on the target CDB.
7. Use Data Pump import on the new PDB by using the full transportable import options.
Identify the required steps in the correct order.
A. 2, 1, 3, 5, 7, and 6
B. 2, 5, 1, 4, 7, and 6
C. 1, 5, 4, 7, and 6
D. 3, 2, 5, 1, 4, and 7
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 5：
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.)
A. The database must be running in archivelog mode.
B. The recycle bin parameter must be set to on.
C. Minimal supplemental logging must be enabled.
D. The select any transaction privilege must be granted to the user.
E. Flashback Data Archive must be created and the flashback archive administer system privilege must be granted to the user.
F. The flashback any table privilege must be granted to the user.
正解：A,C,D

質問 6：
You created a database with DBCA by using one of the Oracle supplied templates.
Which is the default permanent tablespace for all users except DBSNMP and OUTLN?
A. SYSAUX
B. EXAMPLE
C. SYSTEM
D. USERS
正解：C