多选题What information does the report schema command not provide？（）ASize of the datafilesBSize of the tempfilesCDate of last backup for datafiles and tempfilesDFilenames for each datafileECheckpoint SCN associated with the last RMAN backup

题目
多选题
What information does the report schema command not provide？（）
A

Size of the datafiles

B

Size of the tempfiles

C

Date of last backup for datafiles and tempfiles

D

Filenames for each datafile

E

Checkpoint SCN associated with the last RMAN backup

相似考题

1.The backup retention policy is configured as RECOVERY WINDOW 2. You executed the following command in Recovery Manager （RMAN） against your database： RMAN> REPORT OBSOLETE； What would you see in the output？（）A、 a list of all those files that have been deleted in the last two daysB、 a list of all those files that have been recovered within the last two daysC、 a list of all the expired backups and copiesD、 a list of backups and copies that are outside the range covered by the current retention policy

2.What does the minimize load database parameter mean when backing up a database?（）A、RMAN will attempt to make the backup run as fast as possible without any IO limitations. B、RMAN will automatically restrict the number of channels in use to one. C、RMAN will spread the backup IO over the total duration stated in the backup command.D、RMAN will skip any datafile that currently is involved in an IO operation. RMAN will retry backing up the datafile later and an error will be raised at the end of the backup if the datafile cannot be backed up. E、Datafiles will be backed up; those having the lowest current number of IO operations will be backed up first. 

3.Your database runs in NOARCHIVELOG mode， and is backed up every night using RMAN scripts. However， last night your assistant DBA performed a manual operating system backup， instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo？（）A、You need to perform the restore and recover operations manually, because the backup was made manually. B、First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. C、First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. D、You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information. 

4.You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN). Identify two scenarios is which you must have a recovery catalog.（）A、To store the backup information of multiple databaseB、To restrict the amount of space that is used by the backupsC、To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.D、To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.

更多“多选题What information does the report schema command not provide？（）ASize of the datafilesBSize of the tempfilesCDate of last backup for datafiles and tempfilesDFilenames for each datafileECheckpoint SCN associated with the last RMAN backup”相关问题

  • 第1题：

    In which scenario， will you issue the following command？（） RMAN> REPORT NEED BACKUP DAYS 7；

    • A、 to configure RMAN to maintain backup information in the RMAN repository for seven days
    • B、 to configure RMAN to maintain backup information in the control file for at least seven days
    • C、 to display the list of files that have not been backed up for the last seven days
    • D、 to display the list of files that must be backed up within seven days

    正确答案:C

  • 第2题：

    What is the impact of the results of the output of the following command？（）   RMAN> report unrecoverable database；  Report of files that need backup due to unrecoverable operations  File Type of Backup Required Name  4 full or incremental C:///ORACLE/ORADATA/ORCL/USERS01.DBF  

    • A、 There are no backup sets with any backups of the users01.dbf datafile.
    • B、 The users01.dbf datafile has had unrecoverable operations occur in it. It will need to be backed up or some data loss is possible during a recovery.
    • C、 The users01.dbf datafile is corrupted.
    • D、 The users01.dbf datafile backup exceeds the retention criteria.
    • E、 The last backup of the users01.dbf datafile failed and must be rerun.

    正确答案:D

  • 第3题：

    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 days
    • B、 A list of files requiring more than 3 days of archivelogs to apply
    • C、 A list of files that RMAN recommends be backed up only once in every three days，based on low volatility
    • D、 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

    正确答案:B

  • 第4题：

    You have configured your database to use RMAN for backup and recovery. You must back up the datafile contained in the TS1 tablespace. The size of the datafile in the TS1 tablespace is 200 MB.  You issue the following command from the RMAN prompt to perform a backup of the tablespace：   RMAN> BACKUP TABLESPACE TS1 MAXSETSIZE 100M；  Which statement is true about executing this command？（）

    • A、 The command generates an error.
    • B、 The command backs up the tablespace and creates a backup set of size 200 MB
    • C、 The command backs up the tablespace and creates two backup sets of size 100 MB each.
    • D、 The command backs up the tablespace and creates a backup set with backup pieces of size 100 MB each.

    正确答案:A

  • 第5题：

    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 days
    • B、a list of files that have not been backed up for three days
    • C、a list of files that RMAN recommends be backed up only once in every three days， based on low volatility
    • D、a list of files for which a backup has already been performed and may need a backup after three days

    正确答案:B

  • 第6题：

    When CONFIGURE CONTROLFILE AUTOBACKUP is set to ON， RMAN automatically performs a control file autobackup in which three situations？（）

    • A、At the end of every RUN block. 
    • B、After every SET CONTROLFILE AUTOBACKUP FORMAT command. 
    • C、After every BACKUP or COPY command issued at the RMAN prompt. 
    • D、At the end of every RUN block if the last command in the block was either BACKUP or COPY. 
    • E、Whenever a BACKUP or COPY command within a RUN block is followed by a command that is neither BACKUP nor COPY. 
    • F、After every BACKUP or COPY command within a RUN block that is followed by the CONFIGURE CONTROLFILE AUTOBACKUP FORMAT command.

    正确答案:C,D,E

  • 第7题：

    You issue the following command on the RMAN prompt.   REPORT NEED BACKUP DAYS 5；   Which statement is true about executing this command？（）  

    • A、 It will display a list of files that need incremental backup
    • B、 It will display a list of files that need backup after five days
    • C、 It will display a list of files that were backed up in the last five days
    • D、 It will display a list of files that have not been backed up in the last five days
    • E、 It will apply the current retention policy to determine the files that need to be backed up

    正确答案:D

  • 第8题：

    多选题
    You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN). Identify two scenarios is which you must have a recovery catalog.（）
    A

    To store the backup information of multiple database

    B

    To restrict the amount of space that is used by the backups

    C

    To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.

    D

    To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.


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

  • 第9题：

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

    B

     a list of files requiring more than 3 days of archive logs to apply

    C

     a list of files that RMAN recommends be backed up only once in every three days，based on low volatility

    D

     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


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

  • 第10题：

    单选题
    You issue the following command on the RMAN prompt. REPORT NEED BACKUP DAYS 5; Which statement is true about executing this command?（）
    A

    It will display a list of files that need incremental backup

    B

    It will display a list of files that need backup after five days

    C

    It will display a list of files that were backed up in the last five days

    D

    It will display a list of files that have not been backed up in the last five days

    E

    It will apply the current retention policy to determine the files that need to be backed up


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

  • 第11题：

    单选题
    You issue the following command on the RMAN prompt.   RMAN> REPORT NEED BACKUP DAYS = 5 DATABASE；   Which statement is true about executing this command？（）
    A

     It will display a list of files that need incremental backup.

    B

     It will display a list of files that need backup after five days.

    C

     It will display a list of files that were backed up in the last five days.

    D

     It will display a list of files that have not been backed up in the last five days.

    E

     It will apply the current retention policy to determine the files that need to be backed up.


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

  • 第12题：

    多选题
    When CONFIGURE CONTROLFILE AUTOBACKUP is set to ON， RMAN automatically performs a control file autobackup in which three situations？（）
    A

    At the end of every RUN block.

    B

    After every SET CONTROLFILE AUTOBACKUP FORMAT command.

    C

    After every BACKUP or COPY command issued at the RMAN prompt.

    D

    At the end of every RUN block if the last command in the block was either BACKUP or COPY.

    E

    Whenever a BACKUP or COPY command within a RUN block is followed by a command that is neither BACKUP nor COPY.

    F

    After every BACKUP or COPY command within a RUN block that is followed by the CONFIGURE CONTROLFILE AUTOBACKUP FORMAT command.


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

  • 第13题：

    What information does the report schema command not provide？（） 

    • A、 Size of the datafiles
    • B、 Size of the tempfiles
    • C、 Date of last backup for datafiles and tempfiles
    • D、 Filenames for each datafile
    • E、 Checkpoint SCN associated with the last RMAN backup

    正确答案:C,E

  • 第14题：

    You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup？（）

    • A、 online redo log files
    • B、 alert log files
    • C、 control file
    • D、 datafiles associated with the SYSTEM tablespace

    正确答案:C

  • 第15题：

    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 days
    • B、 a list of files requiring more than 3 days of archive logs to apply
    • C、 a list of files that RMAN recommends be backed up only once in every three days，based on low volatility
    • D、 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

    正确答案:A

  • 第16题：

    You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN).Identify two scenarios is which you must have a recovery catalog. （）(Choose two.)

    • A、To store the backup information of multiple database
    • B、To restrict the amount of space that is used by the backups
    • C、To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.
    • D、To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.

    正确答案:A,D

  • 第17题：

    What is the result of this command？（） RMAN> Report need backup days 3；

    • A、 Lists all datafiles created in the last three days that are not backed up.
    • B、 Lists all datafiles not recoverable based on the current retention criteria.
    • C、 Lists all datafiles not backed up in the last three days. The datafile is not recoverable. 
    • D、 Lists all datafiles that need to be backed up due to unrecoverable operations.
    • E、 Lists all datafiles not backed up in the last three days. It does not imply that the datafile is not recoverable.

    正确答案:E

  • 第18题：

    You issue the following command on the RMAN prompt.   RMAN> REPORT NEED BACKUP DAYS = 5 DATABASE；   Which statement is true about executing this command？（）

    • A、 It will display a list of files that need incremental backup.
    • B、 It will display a list of files that need backup after five days.
    • C、 It will display a list of files that were backed up in the last five days.
    • D、 It will display a list of files that have not been backed up in the last five days.
    • E、 It will apply the current retention policy to determine the files that need to be backed up.

    正确答案:D

  • 第19题：

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

    B

    a list of files that have not been backed up for three days

    C

    a list of files that RMAN recommends be backed up only once in every three days， based on low volatility

    D

    a list of files for which a backup has already been performed and may need a backup after three days


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

  • 第20题：

    单选题
    In which scenario， will you issue the following command？（） RMAN> REPORT NEED BACKUP DAYS 7；
    A

     to configure RMAN to maintain backup information in the RMAN repository for seven days

    B

     to configure RMAN to maintain backup information in the control file for at least seven days

    C

     to display the list of files that have not been backed up for the last seven days

    D

     to display the list of files that must be backed up within seven days


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

  • 第21题：

    单选题
    You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup？（）
    A

     online redo log files

    B

     alert log files

    C

     control file

    D

     datafiles associated with the SYSTEM tablespace


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

  • 第22题：

    多选题
    You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN).Identify two scenarios is which you must have a recovery catalog. （）(Choose two.)
    A

    To store the backup information of multiple database

    B

    To restrict the amount of space that is used by the backups

    C

    To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.

    D

    To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.


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

  • 第23题：

    单选题
    The backup retention policy is configured as RECOVERY WINDOW 2. You executed the following command in Recovery Manager （RMAN） against your database： RMAN> REPORT OBSOLETE； What would you see in the output？（）
    A

     a list of all those files that have been deleted in the last two days

    B

     a list of all those files that have been recovered within the last two days

    C

     a list of all the expired backups and copies

    D

     a list of backups and copies that are outside the range covered by the current retention policy


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

相关内容