When exporting metadata for the transportable tablespaces， what is the correct next step after confirming endian format？（）A、 Export the tablespaces using data pump.B、 Determine if the transportable set is self-contained.C、 Convert the datafiles using RMAN

第1题：

第2题：

You set the recovery window to seven days and the backup optimization to ON using the CONFIGURE command of Recovery Manager （RMAN）. The most recent backup of the TOOLS tablespace to disk was taken on January 3. The TOOLS tablespace is read/x7fonly.  On February 21， when you execute a command to back up all the tablespaces to disk， you find that RMAN backs up the TOOLS tablespace also， even though the contents of the tablespace have not changed after the backup on January 3.  Because there are no changes made to the TOOLS tablespace， you decide that the tablespace should not be backed up by RMAN. What can you to do skip backing up the TOOLS tablespace without changing the current backup optimization setting？（）

• A、configure a default device for RMAN backups
• B、temporarily disable the retention policy for RMAN backups
• C、configure automatic channel allocation for RMAN backups
• D、use the CONFIGURE command to reconfigure the recovery window to 60 days

第3题：

Which of the following are included in a transportable tablespace set？（）  

• A、 The datafiles that make up a self-contained group of tablespaces required for copy
• B、 The system tablespace
• C、 An export of the tablespace metadata
• D、 The spfile
• E、 All of the above

第4题：

Examine the following command that is used to duplicate a database on the same host: RMAN> RUN { ALLOCATE AUXILIARY CHANNEL, aux 1 DEVICE TYPE DISK; DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY; / } Which two statements describe the effect after the database is duplicated successfully? （）(Choose two)

• A、The data files of the read-only tablespaces in the target database are not duplicated
• B、The read-only tablespaces in the target database are still defined in new the database
• C、The read-only tablespaces in the target database are changed to online after duplication
• D、The data files of the read-only tablespaces in the target database get duplicated
• E、The read-only tablespaces in the target database are not defined in the new database

第5题：

The database is running in ARCHIVELOG mode and the FORMAT option is not configured in RMAN for disk backups. You configured the flash recovery area location and size by using the DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE initialization parameters. Which statement is correct in this scenario？（）

• A、 If the FORMAT option to the RMAN BACKUP command is specified， then RMAN creates backup pieces and image copies in the flash recovery area with names in the Oracle Managed Files （OMF） format.
• B、 If any local destinations for LOG_ARCHIVE_DEST_n are set， then archived redo logs are stored in these destinations as well as in the flash recovery area.
• C、 If the flash recovery area location is configured using the DB_RECOVERY_FILE_DEST initialization parameter， then the RMAN backup of Oracle managed datafiles （OMF） only will go to the flash recovery area by default.
• D、 If no other destination is configured for recovery files， then RMAN places the control file autobackups in the flash recovery area by default.

第6题：

You are required to migrate your 11.2.0.3 database as a pluggable database (PDB) to 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、2，1，3，4，5，6
• B、1，3，4，5，6，7
• C、1，4，3，5，6，7
• D、2，1，3，4，5，6，7
• E、1，5，6，4，3，2

第7题：

You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?（）

• A、One tablespace has only one datafile
• B、Many tablespaces can share one datafile
• C、One tablespace can have many datafiles
• D、One datafile can contain many tablespaces

第8题：

Which of the following statements is true when the database is in ARCHIVELOG mode and tablespaces are in hot backup mode？（）

• A、 Archive log generation is suspended until the tablespaces are taken out of hot backup mode. 
• B、 Datafiles are not written to during hot backups.
• C、 Changes to the database are cached during the backup and not written to the datafiles to ensure that the datafiles are consistent when recovered.
• D、 The datafile headers are not updated during the backup.
• E、 The way data is written to the online redo logs is unchanged during the backup.

第9题：

You set the recovery window to seven days and the backup optimization to ON using the CONFIGURE command of Recovery Manager （RMAN）. The most recent backup of the TOOLStablespace to disk was taken on January 3. The TOOLStablespace is read-only.On February 21， when you execute a command to back up all the tablespaces to disk， you find that RMAN backs up the TOOLS tablespace also， even though the contents of the tablespace have not changed after the backup on January 3. Because there are no changes made to the TOOLStablespace， you decide that the tablespace should not be backed up by RMAN. What can you do to skip backing up the TOOLStablespace without changing the current backup optimization setting？（）

• A、 configure a default device for RMAN backups
• B、 temporarily disable the retention policy for RMAN backups
• C、 configure automatic channel allocation for RMAN backups
• D、 use the CONFIGURE command to reconfigure the recovery window to 60 days

第10题：

第11题：

第12题：

第13题：

Using FTP passive mode， after the client opens thecommand channel （port 21） to the FTP server and requests passive mode， what will be the next step？ （）

• A、 The FTP server sends back an acknowledgment （ACK） to the client
• B、 The FTP server allocates a port touse for the data channel and transmit that port number to the client
• C、 The FTP server opens the data channel to the client using the port number indicated by the client
• D、 The FTP client opens the data channel to the FTP server on Port 20
• E、 The FTP client opens the datachannel to the FTP server on Port 21

第14题：

When importing or exporting routing information using routing policy, the import or export is always done from which point of view?（）

• A、routing table
• B、forwarding table
• C、routing protocol
• D、neighbor or peer

第15题：

In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog and restored the control file by using the following command： RMAN> RESTORE CONTROLFILE;  Which two operations do you need to perform after restoring the control file from backup？（）

• A、shut down and restart the instance
• B、add new tempfiles to the temporary tablespaces after recovery
• C、perform a media recovery and open the database with the RESETLOGS option
• D、perform a media recovery and bring the database to NOARCHIVELOG mode

第16题：

In Recovery Manager (RMAN), you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged, you want to place the data file in a different location while restoring the file. Which option must you consider for this task?（）

• A、using only the RMAN SWITCH command to set the new location for the data file
• B、placing the database in the MOUNT state for the restore and recovery operations.
• C、using an RMAN RUN block with the SET NEWNAME and then the SWITCH command.
• D、configuring two channels: one for the restore operation and the other for the recovery operation

第17题：

Which two statements are correct about database transportation? （）

• A、The source and target platforms must be the same
• B、Redo logs, control files and temp files are also transported
• C、The transported database must have the same database identifier (DBID) as the source database and cannot be changed
• D、The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transported
• E、Recovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format

第18题：

Users complain SQL statements using a particular index fail. Using DBVERIFY， you find that two separate blocks in the index have become corrupt. The database data files for user data and index are very large.  What is the least disruptive recover strategy available in Oracle9i？（）

• A、Rebuild the index using the online option. 
• B、Take the individual data file offline (not the whole tablespace), restore and recover the data file from backup with RMAN, then set the data file online again. 
• C、Without setting the individual data file offline, use RMAN with Block Media Recovery to restore and recover only those blocks. 
• D、Take the individual data file (not the whole tablespace) offline, use RMAN with Block Media Recovery to restore and recover only those blocks, then set the data file online again.

第19题：

You are peer reviewing a fellow DBAs backup plan for his NOARCHIVELOG mode database， as shown here：   Put the tablespaces in backup mode.  Back up the datafiles for all tablespaces. Take the tablespaces out of backup mode. Back up all archived redo logs.   Your colleague asks for you to comment on his plan.  Which response would be correct？（）

• A、 The plan will work as is.
• B、 The plan needs to be modified to allow for an archive-log switch after step 3.
• C、 The plan needs to be modified so that a backup of the archived redo logs occurs before step 1.
• D、 The plan needs to be adjusted to shut down the database after step 1 and to restart the database after step 2.
• E、 The plan cannot work as presented.

第20题：

The following query will provide what information about transportable tablespaces for the current database？（） select d.platform_name "Source"， t.platform_name  "Compatible Targets"， endian_format  from v$transportable_platform t， v$database d  where t.endian_format = （select endian_format  from v$transportable_platform t， v$database d  where d.platform_name = platform_name）；  

• A、 The list of target platforms having the same endian format as the source database
• B、 The list of target platforms requiring endian conversion
• C、 The list of target platforms that will not require endian conversion
• D、 The list of all target platforms that can receive transportable tablespaces from the source database
• E、 None of the above

第21题：

第22题：

第23题：