单选题Which is the correct command to back up the database， back up the archived redo logs， and then remove the backed-up archived redo logs？（）Abackup databaseBbackup database and archivelogsCbackup database plus archivelogsDbackup database plus archivelog d

题目
单选题
Which is the correct command to back up the database， back up the archived redo logs， and then remove the backed-up archived redo logs？（）
A

 backup database

B

 backup database and archivelogs

C

 backup database plus archivelogs

D

 backup database plus archivelog delete input

E

 backup database and archivelog delete input

相似考题

1.Examine the following RMAN command:Which two statements are true regarding the backup taken by using the above RMAN command?()A. Only data files and the control file are backed up.B. Archived redo logs are backed up only I f the database is open during the backup.C. The backup is deleted after one day, regardless of the default retention policy settings.D. The backup becomes obsolete after one day, regardless of the default retention policy settings.

2.Your database is in NOARCHIVELOG mode. You start to do a backup， but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you？（）  A、 Put the database in hot backup mode and perform an online backup，including backing up the  archived redo logs.B、 Just back up the database datafiles without shutting down the database.C、 You will have to wait until you can shut down the database to perform the backup.D、 Mark each datafile as backup in progress， back them up individually，and then mark them as backup not in progress. No archived redo logs will need to be backed up.E、 Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing，you can shut down the database and back up the datafiles the user changed during the  course of the remaining backup

3. When performing an online backup，what is the proper order of the following steps？（）   a. Issue the alter database end backup command. b. Back up the archived redo logs. c. Issue the alter database begin backup command.  d. Back up the database files.  e. Determine the beginning log sequence number. f. Determine the ending log sequence number.  g. Force a log switch with the alter system switch logfile command.A、a， b， c， d， e， f， gB、c， d， a， b， e， g， fC、f， d， b， g， a， c， eD、e， c， d， a， g， f， bE、a， f， b， g， e， c， d

4.When you are allowing RMAN to backup your archived redo log files，how does RMAN know which archived redo logs to back up from your archive log destination？（）A、RMAN keeps a list of archive logs in a text file.B、The DBA must manually tell RMAN which archive logs to backup.C、RMAN has access to target control file and/or catalog information.D、RMAN looks at the ARCHIVE_LOG_DEST parameter of your target database and backs up all archive logs found.

更多“单选题Which is the correct command to back up the database， back up the archived redo logs， and then remove the backed-up archived redo logs？（）A  backup databaseB  backup database and archivelogsC  backup database plus archivelogsD  backup database plus arch”相关问题

  • 第1题：

    Examine the following RMAN command：   BACKUP DATABASE TAG TESTDB  KEEP UNTIL ’SYSDATE+1’ RESTORE POINT TESTDB06；   Which two statements are true regarding the backup taken by using the above RMAN command？（）  

    • A、 Only data files and the control file are backed up.
    • B、 Archived redo logs are backed up only if the database is open during the backup.
    • C、 The backup is deleted after one day，regardless of the default retention policy settings. 
    • D、 The backup becomes obsolete after one day，regardless of the default retention policy settings.

    正确答案:B,D

  • 第2题：

    Which files are required for a full recovery of the database in ARCHIVELOG mode？（）

    • A、 Database datafiles
    • B、 Online redo logs
    • C、 Archived redo logs
    • D、 Backup control file
    • E、 Control file from a backup

    正确答案:A,C,D

  • 第3题：

    Your database is running in ARCHIVELOG mode,and the database is open. You execute an RMAN backup and specify the KEEP clause.Which components are backed up when this option is specified?（）

    • A、only the control file, the current SPFILE, and data files
    • B、only the current SPFILE and data files if autobackup is disabled
    • C、only the data files and the archived redo logs
    • D、the control file, current SPFILE file, data files, and archived redo logs

    正确答案:D

  • 第4题：

    Which is the correct command to back up the database， back up the archived redo logs， and then remove the backed-up archived redo logs？（）  

    • A、 backup database
    • B、 backup database and archivelogs
    • C、 backup database plus archivelogs
    • D、 backup database plus archivelog delete input
    • E、 backup database and archivelog delete input

    正确答案:D

  • 第5题：

    A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java.  Knowing that your database is in danger，which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression？（）

    • A、 backup database all
    • B、 backup compressed database
    • C、 backup as compressed backupset database
    • D、 backup as compressed backup database plus archivelog all
    • E、 backup as compressed backupset database plus compress archivelog all

    正确答案:C

  • 第6题：

    You backed up the database at 8 a.m. today using an online backup. Accounting made a large change to the underlying data between 10 a.m. and noon.  Which of the following actions would ensure that the changes could be recovered using the 8 a.m. backup？（）  

    • A、 Create a manual incremental online database backup.
    • B、 Back up all the archived redo logs generated since the 8 a.m. backup.
    • C、 Create a brand-new backup after all the changes have been applied.
    • D、 There is no way to make the changes recoverable based on the 8 a.m. backup.
    • E、 Perform an online backup of the tablespace（s） that contained changed data.

    正确答案:B

  • 第7题：

    单选题
    Which is the correct command to back up the database， back up the archived redo logs， and then remove the backed-up archived redo logs？（）
    A

     backup database

    B

     backup database and archivelogs

    C

     backup database plus archivelogs

    D

     backup database plus archivelog delete input

    E

     backup database and archivelog delete input


    正确答案： A
    解析： 暂无解析

  • 第8题：

    单选题
    Your database is running in ARCHIVELOG mode,and the database is open. You execute an RMAN backup and specify the KEEP clause.Which components are backed up when this option is specified?（）
    A

    only the control file, the current SPFILE, and data files

    B

    only the current SPFILE and data files if autobackup is disabled

    C

    only the data files and the archived redo logs

    D

    the control file, current SPFILE file, data files, and archived redo logs


    正确答案： D
    解析： 暂无解析

  • 第9题：

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


    正确答案： B
    解析： 暂无解析

  • 第10题：

    单选题
    A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java.  Knowing that your database is in danger，which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression？（）
    A

     backup database all

    B

     backup compressed database

    C

     backup as compressed backupset database

    D

     backup as compressed backup database plus archivelog all

    E

     backup as compressed backupset database plus compress archivelog all


    正确答案： D
    解析： 暂无解析

  • 第11题：

    单选题
    You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database. The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?（）
    A

    Open the database in NORMAL mode

    B

    Open the database in read-only mode

    C

    Open the database in RESTRICTED mode

    D

    Open the database with the RESETLOGS option


    正确答案： B
    解析： 暂无解析

  • 第12题：

    单选题
    You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup？（）
    A

     Database Datafiles

    B

     Database Control Files

    C

     Online redo logs

    D

     Archived redo logs

    E

     The database SPFILE

    F

     None of the above，all these files are backed up


    正确答案： A
    解析： 暂无解析

  • 第13题：

    You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database. The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?（）

    • A、Open the database in NORMAL mode
    • B、Open the database in read-only mode
    • C、Open the database in RESTRICTED mode
    • D、Open the database with the RESETLOGS option

    正确答案:D

  • 第14题：

    You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?（）

    • A、Database Datafiles 
    • B、Database Control Files 
    • C、Online redo logs
    • D、Archived redo logs 
    • E、The database SPFILE 
    • F、None of the above, all these files are backed up. 

    正确答案:C

  • 第15题：

    What is the purpose of the recover command？（） 

    • A、 Recover database datafiles from physical disk backup sets.
    • B、 Recover required incremental backups from physical disk backup sets.
    • C、 Recover required archived redo logs from physical disk backup sets.
    • D、 Apply incremental backups to recover the database. 
    • E、 Apply archived redo logs to recover the database.

    正确答案:B,C,D,E

  • 第16题：

    Your database has a backup that was taken yesterday （Tuesday） between 13：00 and 15：00 hours. This is the only backup you have. You have lost all the archived redo logs generatedsince the previous Monday， but you have archived redo logs available from the previous Sunday and earlier. You now need to restore your backup due to database loss.  To which point can you restore your database？（）  

    • A、 13：00 on Tuesday.
    • B、 15：00 on Tuesday.
    • C、 Up until the last available archived redo log on Sunday.
    • D、 To any point； all the redo should still be available in the online redo logs.
    • E、 The database is not recoverable.

    正确答案:E

  • 第17题：

    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.

    正确答案:B

  • 第18题：

    Your developers have asked you to restore the development database， which is in NOARCHIVELOG mode， back to last Tuesday the 20th. Your last backup is from Monday the 19th. What do you do？（）

    • A、 Restore the 19ths backup， restore all archived redo logs， recover the database to the 20th，and open the database.
    • B、 Tell them that their request cannot be met with the current backup strategy.
    • C、 Restore the 19ths backup， apply the online redo logs，and open the database.
    • D、 Switch the database into ARCHIVELOG mode，restore the 19th’s backup，restore all archived redo  logs，and recover the database to the 20th.
    • E、 Use the recover database command to roll back the database from today to the 19th of the month.

    正确答案:B

  • 第19题：

    单选题
    When performing an online backup，what is the proper order of the following steps？（）   a. Issue the alter database end backup command. b. Back up the archived redo logs. c. Issue the alter database begin backup command.  d. Back up the database files.  e. Determine the beginning log sequence number. f. Determine the ending log sequence number.  g. Force a log switch with the alter system switch logfile command.
    A

    a， b， c， d， e， f， g

    B

    c， d， a， b， e， g， f

    C

    f， d， b， g， a， c， e

    D

    e， c， d， a， g， f， b

    E

    a， f， b， g， e， c， d


    正确答案： C
    解析： 暂无解析

  • 第20题：

    单选题
    You backed up the database at 8 a.m. today using an online backup. Accounting made a large change to the underlying data between 10 a.m. and noon.  Which of the following actions would ensure that the changes could be recovered using the 8 a.m. backup？（）
    A

     Create a manual incremental online database backup.

    B

     Back up all the archived redo logs generated since the 8 a.m. backup.

    C

     Create a brand-new backup after all the changes have been applied.

    D

     There is no way to make the changes recoverable based on the 8 a.m. backup.

    E

     Perform an online backup of the tablespace（s） that contained changed data.


    正确答案： E
    解析： 暂无解析

  • 第21题：

    单选题
    Your developers have asked you to restore the development database， which is in NOARCHIVELOG mode， back to last Tuesday the 20th. Your last backup is from Monday the 19th. What do you do？（）
    A

     Restore the 19ths backup， restore all archived redo logs， recover the database to the 20th，and open the database.

    B

     Tell them that their request cannot be met with the current backup strategy.

    C

     Restore the 19ths backup， apply the online redo logs，and open the database.

    D

     Switch the database into ARCHIVELOG mode，restore the 19th’s backup，restore all archived redo  logs，and recover the database to the 20th.

    E

     Use the recover database command to roll back the database from today to the 19th of the month.


    正确答案： E
    解析： 暂无解析

  • 第22题：

    单选题
    Your database has a backup that was taken yesterday （Tuesday） between 13：00 and 15：00 hours. This is the only backup you have. You have lost all the archived redo logs generatedsince the previous Monday， but you have archived redo logs available from the previous Sunday and earlier. You now need to restore your backup due to database loss.  To which point can you restore your database？（）
    A

     13：00 on Tuesday.

    B

     15：00 on Tuesday.

    C

     Up until the last available archived redo log on Sunday.

    D

     To any point； all the redo should still be available in the online redo logs.

    E

     The database is not recoverable.


    正确答案： B
    解析： 暂无解析

  • 第23题：

    单选题
    When you are allowing RMAN to backup your archived redo log files，how does RMAN know which archived redo logs to back up from your archive log destination？（）
    A

    RMAN keeps a list of archive logs in a text file.

    B

    The DBA must manually tell RMAN which archive logs to backup.

    C

    RMAN has access to target control file and/or catalog information.

    D

    RMAN looks at the ARCHIVE_LOG_DEST parameter of your target database and backs up all archive logs found.


    正确答案： B
    解析： 暂无解析

  • 第24题：

    单选题
    Your database is in NOARCHIVELOG mode. You start to do a backup， but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you？（）
    A

     Put the database in hot backup mode and perform an online backup，including backing up the  archived redo logs.

    B

     Just back up the database datafiles without shutting down the database.

    C

     You will have to wait until you can shut down the database to perform the backup.

    D

     Mark each datafile as backup in progress， back them up individually，and then mark them as backup not in progress. No archived redo logs will need to be backed up.

    E

     Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing，you can shut down the database and back up the datafiles the user changed during the  course of the remaining backup


    正确答案： A
    解析： 暂无解析

相关内容