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.D、 Copy the datafiles from source to destination.

考题 Examine the following command that is used to duplicate a database on the same host:Which two statements describe the effect after the database is duplicated successfully? () A. The data files of the read-only tablespaces in the target database are not duplicatedB. The read-only tablespaces in the target database are still defined in new the databaseC. The read-only tablespaces in the target database are changed to online after duplicationD. The data files of the read-only tablespaces in the target database get duplicatedE. The read-only tablespaces in the target database are not defined in the new database

查看答案

考题 Which two statements are correct about database transportation? () A. The source and target platforms must be the sameB. Redo logs, control files and temp files are also transportedC. The transported database must have the same database identifier (DBID) as the source database and cannot be changedD. The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transportedE. 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

查看答案

考题 Thefollowingquerywillprovidewhatinformationabouttransportabletablespacesforthecurrentdatabase？（）selectd.platform_nameSource，t.platform_nameCompatibleTargets，endian_formatfromv$transportable_platformt，v$databasedwheret.endian_format=（selectendian_formatfromv$transportable_platformt，v$databasedwhered.platform_name=platform_name）；A.ThelistoftargetplatformshavingthesameendianformatasthesourcedatabaseB.ThelistoftargetplatformsrequiringendianconversionC.ThelistoftargetplatformsthatwillnotrequireendianconversionD.ThelistofalltargetplatformsthatcanreceivetransportabletablespacesfromthesourcedatabaseE.Noneoftheabove

查看答案

考题 Which two statements are correct about database transportation?() (Choose two.) A. The source and target platforms must be the sameB. Redo logs, control files and temp files are also transportedC. The transported database must have the same database identifier (DBID) as the source database and cannot be changedD. The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transportedE. 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

查看答案

考题 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 duplicatedB. The read-only tablespaces in the target database are still defined in new the databaseC. The read-only tablespaces in the target database are changed to online after duplicationD. The data files of the read-only tablespaces in the target database get duplicatedE. The read-only tablespaces in the target database are not defined in the new database

查看答案

考题 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 clientB、 The FTP server allocates a port touse for the data channel and transmit that port number to the clientC、 The FTP server opens the data channel to the client using the port number indicated by the clientD、 The FTP client opens the data channel to the FTP server on Port 20E、 The FTP client opens the datachannel to the FTP server on Port 21

查看答案

考题 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 backupsB、temporarily disable the retention policy for RMAN backupsC、configure automatic channel allocation for RMAN backupsD、use the CONFIGURE command to reconfigure the recovery window to 60 days

查看答案

考题 When importing or exporting routing information using routing policy, the import or export is always done from which point of view?（）A、routing tableB、forwarding tableC、routing protocolD、neighbor or peer

查看答案

考题 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 copyB、 The system tablespaceC、 An export of the tablespace metadataD、 The spfileE、 All of the above

查看答案

考题 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 instanceB、add new tempfiles to the temporary tablespaces after recoveryC、perform a media recovery and open the database with the RESETLOGS optionD、perform a media recovery and bring the database to NOARCHIVELOG mode

查看答案

考题 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 duplicatedB、The read-only tablespaces in the target database are still defined in new the databaseC、The read-only tablespaces in the target database are changed to online after duplicationD、The data files of the read-only tablespaces in the target database get duplicatedE、The read-only tablespaces in the target database are not defined in the new database

查看答案

考题 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 fileB、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

查看答案

考题 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.

查看答案

考题 Which two statements are correct about database transportation? （）A、The source and target platforms must be the sameB、Redo logs, control files and temp files are also transportedC、The transported database must have the same database identifier (DBID) as the source database and cannot be changedD、The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transportedE、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

查看答案

考题 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，6B、1，3，4，5，6，7C、1，4，3，5，6，7D、2，1，3，4，5，6，7E、1，5，6，4，3，2

查看答案

考题 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.

查看答案

考题 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 datafileB、Many tablespaces can share one datafileC、One tablespace can have many datafilesD、One datafile can contain many tablespaces

查看答案

考题 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.

查看答案

考题 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.

查看答案

考题 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 databaseB、 The list of target platforms requiring endian conversionC、 The list of target platforms that will not require endian conversionD、 The list of all target platforms that can receive transportable tablespaces from the source databaseE、 None of the above

查看答案

考题 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 backupsB、 temporarily disable the retention policy for RMAN backupsC、 configure automatic channel allocation for RMAN backupsD、 use the CONFIGURE command to reconfigure the recovery window to 60 days

查看答案

考题单选题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.

查看答案

考题多选题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）；AThe list of target platforms having the same endian format as the source databaseBThe list of target platforms requiring endian conversionCThe list of target platforms that will not require endian conversionDThe list of all target platforms that can receive transportable tablespaces from the source databaseENone of the above

查看答案

考题多选题Which of the following are included in a transportable tablespace set？（）AThe datafiles that make up a self-contained group of tablespaces required for copyBThe system tablespaceCAn export of the tablespace metadataDThe spfileEAll of the above

查看答案

考题单选题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.D Copy the datafiles from source to destination.

查看答案

考题多选题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)AThe data files of the read-only tablespaces in the target database are not duplicatedBThe read-only tablespaces in the target database are still defined in new the databaseCThe read-only tablespaces in the target database are changed to online after duplicationDThe data files of the read-only tablespaces in the target database get duplicatedEThe read-only tablespaces in the target database are not defined in the new database

查看答案

考题单选题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.

查看答案

网友您好， 请在下方输入框内输入要搜索的题目：

网友您好，请在下方输入框内输入要搜索的题目：