单选题What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?（）A An upper limit on how far you can flash back the database, depending on the information in the redo logsB An upper limit on how far you can flash back the database, depending on the in

题目
单选题
What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?（）
A

An upper limit on how far you can flash back the database, depending on the information in the redo logs

B

An upper limit on how far you can flash back the database, depending on the information in the undo tablespace

C

The amount of time for which the flashback data is to be kept in the flash recovery area, provided that there is enough space

D

The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace, provided that there is enough space

相似考题

1.You can go out,()you promise to be back before 12 o'clock.A. so far asB. as far asC. as long as

2.On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30 am. Which option must you use to check whether a flashback operation can recover the database to the specified time? （）A. Check the alert log fileB. Query the V$FLASHBACK_DATABASE_LOG viewC. Query the V$RECOVERY_FILE_DEST_SIZE viewD.Query the V$FLASHBACK_DATABASE_STAT viewE. Check the value assigned for the UNDO_RETENTION parameter

3.There is no reason they should limit how much vitamin you take,____they can limit how much water you drink.A.no less thanB.not any more than C.no more than D.much more or less

4.there is no reason that they should limit how much vitamin you take ____ they can limit how much water you drink.A. any more thanB. no more thanC. much more thanD. no less than

更多“单选题What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?（）A An upper limit on how far you can flash back the database, depending on the information in the redo logsB An upper limit on how far you can flash back the database, depending on the in”相关问题

  • 第1题：

    There is no reason they should limit how much vitamin you take，( )they can limit how much water you drink.

    A.much more than
    B.no more than
    C.no less than
    D.any more than

    答案：D
    解析：
    考查比较结构。A项意为“比...多得多”；B项意为“和……一样不，仅仅”；C项意为“多达”；D项no...more than意为“两者都不”，其强调形式为not...any more than。由于前一句已有否定词no，因此D项正确。故本题选D。句意：正如他们无权限制人们喝多少水一样，他们也没有理由限制人们摄入多少维生素。

  • 第2题：

    A data file became corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）

    • A、flash back all the tables in the data file， one by one
    • B、restore the data file to a new location and perform a media recovery
    • C、flash back the database; there is no need to restore the data file
    • D、restore the data file from the most recent backup and flash back the database

    正确答案:B

  • 第3题：

    What RMAN command must you use before you can back up a database using the recovery catalog？（）

    • A、 create catalog
    • B、 install database
    • C、 catalog database
    • D、 merge Catalog with database
    • E、 register database

    正确答案:E

  • 第4题：

    On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30 am. Which option must you use to check whether a flashback operation can recover the database to the specified time? （）

    • A、Check the alert log file
    • B、Query the V$FLASHBACK_DATABASE_LOG view
    • C、Query the V$RECOVERY_FILE_DEST_SIZE view
    • D、Query the V$FLASHBACK_DATABASE_STAT view
    • E、Check the value assigned for the UNDO_RETENTION parameter

    正确答案:B

  • 第5题：

    You work as a database administrator for Certkiller .com. Your database is configured for automatic undo management. UNDO_RETENTION is set to 3 hours. You want to flash back a table that was created last year. How far back can the flashback query go？ （）

    • A、3 hours
    • B、6 months
    • C、until last year
    • D、until last commit
    • E、until the point when the undotablespacewas refreshed
    • F、until the database is shut down and the memory erased

    正确答案:A

  • 第6题：

    You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）

    • A、 The time when the last flashback operation in your database was performed.
    • B、 The time when the first flashback operation in your database was performed.
    • C、 A list of flashback operations performed in your database using SCN and time.
    • D、 The approximate time and the lowest system change number （SCN） to which you can flash back your database.

    正确答案:D

  • 第7题：

    You executed the following query in your database：  FROM V$FLASHBACK_DATABASE_LOG;  What would you determine from the output？（）

    • A、the time when the last flashback operation in your database was performed
    • B、the time when the first flashback operation in your database was performed
    • C、a list of flashback operations performed in your database using SCN and time
    • D、the approximate time and the lowest system change number （SCN） to which you can flash back your database

    正确答案:D

  • 第8题：

    You are managing an Oracle Database 11g database. You want to ensure the recovery of thedatabase to the point of failure.  Which configuration will you do to accomplish the task（）

    • A、Multiplex all database files
    • B、Configure the Flash Recovery Area.
    • C、Configure the database instance for ARCHIVELOG mode.
    • D、Configure the FAST_START_MTTR_TARGET initialization parameter.

    正确答案:C

  • 第9题：

    单选题
    What RMAN command must you use before you can back up a database using the recovery catalog？（）
    A

     create catalog

    B

     install database

    C

     catalog database

    D

     merge Catalog with database

    E

     register database


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

  • 第10题：

    单选题
    What does the DB_FLASHBACK_RETENTION_TARGET parameter configure？（）
    A

     An upper limit on how far you can flash back the database，depending on the information in the redo logs

    B

     An upper limit on how far you can flash back the database，depending on the information in the undo tablespace

    C

     The amount of time for which the flashback data is to be kept in the flash recovery area， provided that there is enough space

    D

     The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace，provided that there is enough space


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

  • 第11题：

    单选题
    You work as a database administrator for Certkiller .com. Your database is configured for automatic undo management. UNDO_RETENTION is set to 3 hours. You want to flash back a table that was created last year. How far back can the flashback query go？ （）
    A

    3 hours

    B

    6 months

    C

    until last year

    D

    until last commit

    E

    until the point when the undotablespacewas refreshed

    F

    until the database is shut down and the memory erased


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

  • 第12题：

    单选题
    On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30am. Which option must you use to check whether a flashback operation can recover the database to the specified time?（）
    A

    Check the alert log file

    B

    Query the V$FLASHBACK_DATABASE_LOG view

    C

    Query the V$RECOVERY_FILE_DEST_SIZE view

    D

    Query the V$FLASHBACK_DATABASE_STAT view

    E

    Check the value assigned for the UNDO_RETENTION parameter


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

  • 第13题：

    You are maintaining a database that is in ARCHIVELOG mode. You have configured the flash recovery area in your database. The database is in MOUNT EXCLUSIVE mode， and you want to configure the Flashback Database feature. Which two options are NOT required to configure the Flashback Database feature？ （）

    • A、 Open the database in read-only mode.
    • B、 Set the retention target with the DB_FLASHBACK_RETENTION_TARGET initialization parameter.
    • C、 Enable the block change tracking feature.
    • D、 Execute the ALTER DATABASE FLASHBACK ON statement.

    正确答案:A,C

  • 第14题：

    In your database， you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace？（）

    • A、flash back the database
    • B、perform point-in-time recovery
    • C、perform a full database recovery
    • D、drop and re-create the tablespace
    • E、use Recovery Manager （RMAN） to recover the database

    正确答案:D

  • 第15题：

    You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode.  Which two statements are true in this scenario（）

    • A、You must shut down the database instance to perform the backups.
    • B、You must configure the Flash Recovery Area （FRA） for the database.
    • C、You can perform complete database backups without closing the database.
    • D、All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.

    正确答案:C,D

  • 第16题：

    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

    正确答案:C

  • 第17题：

    What does the DB_FLASHBACK_RETENTION_TARGET parameter configure？（）  

    • A、 An upper limit on how far you can flash back the database，depending on the information in the redo logs
    • B、 An upper limit on how far you can flash back the database，depending on the information in the undo tablespace
    • C、 The amount of time for which the flashback data is to be kept in the flash recovery area， provided that there is enough space
    • D、 The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace，provided that there is enough space

    正确答案:C

  • 第18题：

    You are managing an Oracle Database 11g database. You want to ensure the recovery of the database to thepoint of failure. Which configuration will you do to accomplish the task（）

    • A、Multiplex all database files.
    • B、Configure the Flash Recovery Area.
    • C、Configure the database instance for ARCHIVELOG mode.
    • D、Configure the FAST_START_MTTR_TARGET initialization parameter

    正确答案:C

  • 第19题：

    Flashback Database is enabled in your Oracle 10g database. One of your database users erroneously purged an important table residing in his schema. The table was purged sometime between 10：00 P.M. and 10：30 P.M. The next day， you decide to flash back the database. Before you flash back the database， you want to ensure that you have all the necessary flashback data. Which dynamic performance view must you use to determine whether you have the required flashback data to recover the purged table？（）

    • A、 V$DATABASE
    • B、 V$UNDOSTAT
    • C、 V$FLASHBACK_DATABASE_LOG
    • D、 V$FLASHBACK_DATABASE_STAT

    正确答案:C

  • 第20题：

    单选题
    What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?（）
    A

    An upper limit on how far you can flash back the database, depending on the information in the redo logs

    B

    An upper limit on how far you can flash back the database, depending on the information in the undo tablespace

    C

    The amount of time for which the flashback data is to be kept in the flash recovery area, provided that there is enough space

    D

    The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace, provided that there is enough space


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

  • 第21题：

    单选题
    You executed the following query in your database：  FROM V$FLASHBACK_DATABASE_LOG;  What would you determine from the output？（）
    A

    the time when the last flashback operation in your database was performed

    B

    the time when the first flashback operation in your database was performed

    C

    a list of flashback operations performed in your database using SCN and time

    D

    the approximate time and the lowest system change number （SCN） to which you can flash back your database


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

  • 第22题：

    单选题
    Flashback Database is enabled in your Oracle 10g database. One of your database users erroneously purged an important table residing in his schema. The table was purged sometime between 10：00 P.M. and 10：30 P.M. The next day， you decide to flash back the database. Before you flash back the database， you want to ensure that you have all the necessary flashback data. Which dynamic performance view must you use to determine whether you have the required flashback data to recover the purged table？（）
    A

     V$DATABASE

    B

     V$UNDOSTAT

    C

     V$FLASHBACK_DATABASE_LOG

    D

     V$FLASHBACK_DATABASE_STAT


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

  • 第23题：

    单选题
    You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）
    A

     The time when the last flashback operation in your database was performed.

    B

     The time when the first flashback operation in your database was performed.

    C

     A list of flashback operations performed in your database using SCN and time.

    D

     The approximate time and the lowest system change number （SCN） to which you can flash back your database.


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

  • 第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
    解析： 暂无解析

相关内容