View the Exhibit.You executed the following command to perform a backup of the USERS tablespace: RMAN BACKUP TABLESPACE USERS;  Which three types of files are backed up? ()A、 all the data files belonging to the USERS tablespaceB、 password fileC、 online redo log filesD、 the current control fileE、 archived redo log filesF、 the current server parameter fileG、 data files belonging to the USERS tablespace and all the default tablespaces

View the Exhibit.You executed the following command to perform a backup of the USERS tablespace: RMAN> BACKUP TABLESPACE USERS;  Which three types of files are backed up? ()

  • A、 all the data files belonging to the USERS tablespace
  • B、 password file
  • C、 online redo log files
  • D、 the current control file
  • E、 archived redo log files
  • F、 the current server parameter file
  • G、 data files belonging to the USERS tablespace and all the default tablespaces

相关考题:

Your database is running in ARCHIVELOG mode. One of the data files,USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?()A. Redo logsB. Control fileC. The latest backup of only the damaged data fileD. The latest backup of all the data file in the USERS tablespaceE. Temporary files of temporary tablespaceF. Archive Logs since the latest backup to point of failure

You executed the following command in the Recovery Manager (RMAN):RMAN REPORT NEED BACKUP days 3;What is the output of this command?() A. A list of files that require a backup within 3 daysB. A list of files requiring more than 3 days of archivelogs to applyC. A list of files that RMAN recommends be backed up only once in every three days, based on low volatilityD. A list of files for which a backup as already been performed in the last three days and which is required to be backed up again based on the high number of transactions performed on them

Your database is running in ARCHIVELOG mode. One of the data files, USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available.Which three files would be used in the user-managed recovery process performed by the database administrator ()(DBA)? (Choose Three)A. Redo logsB. Control fileC. The latest backup of only the damaged data fileD. The latest backup of all the data file in the USERS tablespaceE. Temporary files of temporary tablespaceF. Archive Logs since the latest backup to point of failure

You executed the following command to perform a backup of the USERS tablespace:  SQL ALTER TABLESPACE users BEGIN BACKUP; ALTER TABLESPACE users BEGIN BACKUP *  ERROR at line 1:  ORA-01123: cannot start online backup; media recovery not enabled  What could be the reason for this error()A、The MTTR Advisor is disabled.B、The database is in NOARCHIVELOG mode.C、The tablespace is already in backup mode.D、The Flash Recovery Area is not configured.

Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten sincethe last backup.  What would you do to recover the data file()A、Take the USERS tablespace offline and re-create the lost data file.B、Shut down the instance, restore the data file from the last consistent backup, and restart the databaseinstance.C、Shut down the instance, restore all the database files from the last consistent backup, and restart thedatabase instance.D、Take the USERS tablespace offline, restore all the data files of the USERS tablespace from the lastconsistent backup, and make the tablespace online

Your database is running in ARCHIVELOG mode. One of the data files,USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?()A、Redo logsB、Control fileC、The latest backup of only the damaged data fileD、The latest backup of all the data file in the USERS tablespaceE、Temporary files of temporary tablespaceF、Archive Logs since the latest backup to point of failure

Your database is running in ARCHIVELOG mode. One of the data files, USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator ()(DBA)? (Choose Three)A、Redo logsB、Control fileC、The latest backup of only the damaged data fileD、The latest backup of all the data file in the USERS tablespaceE、Temporary files of temporary tablespaceF、Archive Logs since the latest backup to point of failure

To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode:   SQL ALTER TABLESPACE users BEGIN BACKUP;   While copying the file to the backup destination a power outage caused the instance to te minate abnormally.  Which statement is true about the next database startup and the USERS tablespace?()  A、 The database will open,and the tablespace automatically comes out of the backup mode.B、 The database will be mounted,and recovery must be performed on the USERS tablespace.C、 The database will be mounted,and data files in the USERS tablespace must be taken out of the backup mode.D、 The database will not be mounted,and you must restore all the data files for the USERS tablespace from the backup,and perform recovery.

Your database is running In ARCIIIVELOG mode. One of the data files, USBRDATAOI. DBF, in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available.  Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?() A、 redo logsB、 control fileC、 temporary files of temporary tablespaceD、 the latest backup of only the damaged data fileE、 the latest backup of all the data files In the USERS tablespace

You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for Recovery Manager (RMAN). To accomplish the backup, you issued the following RMAN command: RMAN BACKUP SECTION SIZE 300M TABLESPACE users; Which two statements are true about the execution of the above command? ()(Choose two.)A、The backup piece size will be limited to 300 MBB、The RMAN uses multiplexing to perform backupC、The operation is accomplished using the default channel availableD、The RMAN parallelizes the backup although the parallelism is not set for a channel

Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERStablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup.  What would you do to recover the data file()A、Take the USERS tablespace offline and re-create the lost data file.B、Shut down the instance, restore the data file from the last consistent backup, and restart the databaseinstance.C、Shut down the instance, restore all the database files from the last consistent backup, and restart thedatabase instance.D、Take the USERS tablespace offline, restore all the data files of the USERS tablespace from the lastconsistent backup, and make the tablespace online.

You executed the following command in the Recovery Manager (RMAN):   RMAN REPORT NEED BACKUP days 3;   What is the output of this command?()  A、 A list of files that require a backup within 3 daysB、 A list of files requiring more than 3 days of archivelogs to applyC、 A list of files that RMAN recommends be backed up only once in every three days,based on low volatilityD、 A list of files for which a backup as already been performed in the last three days and which is  required to be backed up again based on the high number of transactions performed on them

You executed the following command in Recovery Manager (RMAN):   RMAN REPORT NEED BACKUP days 3;   What is the output of this command?()  A、 a list of files that require a backup within three daysB、 a list of files requiring more than 3 days of archive logs to applyC、 a list of files that RMAN recommends be backed up only once in every three days,based on low volatilityD、 a list of files for which a backup has already been performed in the last three days and which is required to be backed up again based on the high number of transactions performed on them

When performing a backup using Recovery Manager (RMAN), which four types of files can be backed up with the RMAN BACKUPcommand? ()A、 data fileB、 password fileC、 archivelog fileD、 temporary fileE、 online redo log fileF、 the current control fileG、 the tnsnames.ora fileH、 current server parameter file

You executed the following command in Recovery Manager (RMAN) against your Oracle 10g database:  RMAN REPORT NEED BACKUP days 3;  What would be the output of this command?() A、a list of files that require a backup within three daysB、a list of files that have not been backed up for three daysC、a list of files that RMAN recommends be backed up only once in every three days, based on low volatilityD、a list of files for which a backup has already been performed and may need a backup after three days

View this parameter setting in your database:   DB_CREATE_FILE_DEST=’D:// /oracle/product/10.2.0/oradata/oracle’  You created a tablespace by using this command:   CREATE TABLESPACE USERS;  Which two statements are true about the USERS tablespace?()A、The tablespace has two data files.B、An error is reported and tablespace creation fails.C、Data files are created with names generated by the instance.D、The tablespace can be extended without specifying the data file.E、Data files belonging to the USERS tablespace cannot be renamed.

When performing a backup using Recovery Manager (RMAN), which four types of files can be backed up with the RMAN BACKUP command?()A、data fileB、password fileC、archivelog fileD、temporary fileE、online redo log fileF、the current control fileG、the tnsnames.ora fileH、current server parameter file

To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance to terminate abnormally. Which statement is true about the next database startup and the USERS tablespace?()A、The database will open, and the tablespace automatically comes out of the backup modeB、The database will be mounted, and recovery must be performed on the USERS tablespace.C、The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.D、The database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.

单选题You executed the following command in Recovery Manager (RMAN) against your Oracle 10g database:  RMAN REPORT NEED BACKUP days 3;  What would be the output of this command?()Aa list of files that require a backup within three daysBa list of files that have not been backed up for three daysCa list of files that RMAN recommends be backed up only once in every three days, based on low volatilityDa list of files for which a backup has already been performed and may need a backup after three days

多选题Your database is running in ARCHIVELOG mode. One of the data files, USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator ()(DBA)? (Choose Three)ARedo logsBControl fileCThe latest backup of only the damaged data fileDThe latest backup of all the data file in the USERS tablespaceETemporary files of temporary tablespaceFArchive Logs since the latest backup to point of failure

多选题View the Exhibit.You executed the following command to perform a backup of the USERS tablespace: RMAN BACKUP TABLESPACE USERS;  Which three types of files are backed up? ()Aall the data files belonging to the USERS tablespaceBpassword fileConline redo log filesDthe current control fileEarchived redo log filesFthe current server parameter fileGdata files belonging to the USERS tablespace and all the default tablespaces

单选题Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten sincethe last backup.  What would you do to recover the data file()ATake the USERS tablespace offline and re-create the lost data file.BShut down the instance, restore the data file from the last consistent backup, and restart the databaseinstance.CShut down the instance, restore all the database files from the last consistent backup, and restart thedatabase instance.DTake the USERS tablespace offline, restore all the data files of the USERS tablespace from the lastconsistent backup, and make the tablespace online

单选题You executed the following command in Recovery Manager (RMAN):   RMAN REPORT NEED BACKUP days 3;   What is the output of this command?()A a list of files that require a backup within three daysB a list of files requiring more than 3 days of archive logs to applyC a list of files that RMAN recommends be backed up only once in every three days,based on low volatilityD a list of files for which a backup has already been performed in the last three days and which is required to be backed up again based on the high number of transactions performed on them

单选题You executed the following command to perform a backup of the USERS tablespace:  SQL ALTER TABLESPACE users BEGIN BACKUP; ALTER TABLESPACE users BEGIN BACKUP *  ERROR at line 1:  ORA-01123: cannot start online backup; media recovery not enabled  What could be the reason for this error()AThe MTTR Advisor is disabled.BThe database is in NOARCHIVELOG mode.CThe tablespace is already in backup mode.DThe Flash Recovery Area is not configured.

多选题View this parameter setting in your database:   DB_CREATE_FILE_DEST=’D:// /oracle/product/10.2.0/oradata/oracle’  You created a tablespace by using this command:   CREATE TABLESPACE USERS;  Which two statements are true about the USERS tablespace?()AThe tablespace has two data files.BAn error is reported and tablespace creation fails.CData files are created with names generated by the instance.DThe tablespace can be extended without specifying the data file.EData files belonging to the USERS tablespace cannot be renamed.

多选题Your database is running in ARCHIVELOG mode. One of the data files,USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?()ARedo logsBControl fileCThe latest backup of only the damaged data fileDThe latest backup of all the data file in the USERS tablespaceETemporary files of temporary tablespaceFArchive Logs since the latest backup to point of failure

多选题Your database is running In ARCIIIVELOG mode. One of the data files, USBRDATAOI. DBF, in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available.  Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?()Aredo logsBcontrol fileCtemporary files of temporary tablespaceDthe latest backup of only the damaged data fileEthe latest backup of all the data files In the USERS tablespace