单选题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.
单选题
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
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
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
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
In which situation is the UNDO_RETENTION parameter be ignored, even if it is set to a value()A、When the data file of the undo tablespace is autoextensibleB、When there are more than one undo tablespaces available in the databaseC、When the undo tablespace is of a fixed size and retention guarantee is not enabledD、When the undo tablespace is autoextensible and retention guarantee is not enabled
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.
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
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
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
Your network includes Windows Server 2008 R2 Hyper-V failover clusters that support highly available virtual machines (VMs). You manage virtual machines by using Microsoft System Center Virtual Machine Manager (VMM) 2008 R2. You are planning to deploy a large number of VMs to the failover clusters. All VMs must remain available when one node of each cluster is offline. You need to determine the best placement for the new VMs among the clusters. Which two actions should you perform?()A、For each cluster, set the cluster reserve to 1B、Determine the placement for each VM by using the data that is generated by running the Get-VMPerformance PowerShell cmdletC、Determine the placement for each VM by using the data that is generated by running the Get-VMHostRating PowerShell cmdletD、For each cluster, set the cluster reserve to 0
单选题Two data files have been deleted at the operating system level by accident. Your database is running in ARCHIVELOG mode and online backups are taken nightly. One of the data files that has been deleted belongs to the USERS tablespace on the other belongs to the SYSTEM tablespace. How can you recover from this situation?()AShut down the database, restore the two data files and then start up the database. BTake the system and users tablespace offline, restore the two data files, recover the two datafiles, and then bring the SYSTEM and USERS tablespaces online. CShut down the database, restore the two data files, start up the database in MOUNT mode, recover the two data files, and then alter the database open. DTake the SYSTEM and USERS tablespaces offline, recover the two datafiles and then bring the SYSTEM and USERS tablespaces online.
单选题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
单选题When importing or exporting routing information using routing policy, the import or export is always done from which point of view?()Arouting tableBforwarding tableCrouting protocolDneighbor or peer
单选题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.()A2,1,3,4,5,6B1,3,4,5,6,7C1,4,3,5,6,7D2,1,3,4,5,6,7E1,5,6,4,3,2
单选题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.
单选题You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?()AOne tablespace has only one datafileBMany tablespaces can share one datafileCOne tablespace can have many datafilesDOne datafile can contain many tablespaces
多选题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
单选题You work at the regional sales office. You are responsible for importing and exporting data in SQL Server 2005 databases. The main office asks you to send them a text file that contains updated contact information for the customers in your region. The database administrator in the main office asks that the data be sorted by the StateProvince,Surname, and FirstName columns.You need to satisfy these requirements by using the least amount of effort. What should you do?()ASpecify StateProvince, Surname, and FirstName in the ORDER hint in the bcp out command.BCreate a format file for the export operation.CSpecify StateProvince, Surname, and FirstName in the ORDER BY clause in the bcp queryout command.DCopy the data into a new table that has a clustered index on StateProvince,Surname,and FirstName. Export the data.
多选题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.