单选题Exhibit， Viewing the Exhibit and examine the Flashback Database architecture. Identify the missing component （shown with a "？`"= in the Flashback Database architecture.（）ADBWnBRVWRCARCHDRECOETRWR

题目
单选题
Exhibit， Viewing the Exhibit and examine the Flashback Database architecture. Identify the missing component （shown with a "？`"= in the Flashback Database architecture.（）
A

 DBWn

B

 RVWR

C

 ARCH

D

 RECO

E

 TRWR

相似考题

1.Examine the following commands and their output:SQL> SELECT ename, sal FROM emp WHERE ename=‘JAMES‘; ENAME SAL JAMES 1050QL> UPDATE emp SET sal=sal+sal*1.2 WHERE ename=‘JAMES‘;1 row updated.SQL> SELECT ename, sal FROM emp WHERE ename=‘JAMES‘; ENAME SAL JAMES 2310View the exhibit and examine the Flashback Version Query that was executed after the preceding commands.What could be the possible cause for the query not displaying any row?（）A. Flashback logging is not enabled for the database.B. The changes made to the table are not committed.C. Supplemental logging is not enabled for the database.D. The database is not configured in ARCHIVELOG mode.

2.ViewtheExhibitandexaminetheFlashbackDatabasearchitecture.Identifythemissingcomponent(shownwitha"?")intheFlashbackDatabasearchitecture.()A.DBWnB.RVWRC.ARCHD.RECOE.TRWR

3.ThesearethedetailsaboutV$FLASHBACK_DATABASE_STAT：SQL>DESCV$FLASHBACK_DATABASE_STATNameNull？Type-----------------------------------BEGIN_TIMEDATEEND_TIMEDATEFLASHBACK_DATANUMBERDB_DATANUMBERREDO_DATANUMBERESTIMATED_FLASHBACK_SIZENUMBERWhichtwostatementsregardingtheV$FLASHBACK_DATABASE_STATviewaretrue？（）A.BEGIN_TIMEisthetimeatwhichFlashbackloggingisenabled.B.END_TIMEisthetimeatwhichthequeryisexecutedontheview.C.REDO_DATAisthenumberofbytesofredodatawrittenduringtheinterval.D.Thisviewcontainsinformationaboutflashbackdatapertainingtothelast24hours.E.FLASHBACK_DATAistheamountofflashbackdatageneratedsincethedatabasewasopened.

4.Which three actions are required to configure the Flashback Database? ()A. set Flash Recovery AreaB. enable Flashback loggingC. create FLASHBACK tablespaceD. start the database in the ARCHIVELOG modeE. start the database in the NOARCHIVELOG mode

参考答案和解析
正确答案： E
解析： 暂无解析
更多“单选题Exhibit， Viewing the Exhibit and examine the Flashback Database architecture. Identify the missing component （shown with a "？`"= in the Flashback Database architecture.（）A  DBWnB  RVWRC  ARCHD  RECOE  TRWR”相关问题

  • 第1题：

    Examine the following commands and their output:View the exhibit and examine the Flashback Version Query that was executed after the preceding commands.What could be the possible cause for the query not displaying any row?（）

    A. Flashback logging is not enabled for the database.

    B. The changes made to the table are not committed.

    C. Supplemental logging is not enabled for the database.

    D. The database is not configured in ARCHIVELOG mode.


    参考答案：B

  • 第2题：

    Exhibit,ViewingtheExhibitandexaminetheFlashbackDatabasearchitecture.Identifythemissingcomponent(shownwitha"?`"=intheFlashbackDatabasearchitecture.()

    A.DBWn

    B.RVWR

    C.ARCH

    D.RECO

    E.TRWR


    参考答案：B

  • 第3题：

    You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？ （）

    • A、 Flashback logs are not archived.
    • B、 Flashback logs are maintained in redo log files.
    • C、 Flashback logs are maintained in the Flash Recovery Area.
    • D、 Flashback logs are used to maintain Flashback Database related errors.
    • E、 Flashback logs need to be cleared manually after you disable Flashback Database.

    正确答案:A,C

  • 第4题：

    Your Oracle Database 10g is online when you execute the following statement：        SQL>ALTER TABLESPACE MY_TABLESPACE FLASHBACK OFF；   What is the result of executing this statement if the Flashback Database feature is already enabled in the database？（）

    • A、 The database does not record flashback logs for MY_TABLESPACE
    • B、 The tables residing in MY_TABLESPACE are not protected by the Recycle Bin.
    • C、 All the tablespaces except MY_TABLESPACE can be recovered using Flashback Database feature.
    • D、 None of the flashback technologies， such as Flashback Table， Flashback Transaction Query and Flashback Version Query can be used to recover individual rows within the objects from MY_TABLESPACE

    正确答案:A

  • 第5题：

    Which three statements are true about Flashback Database?（）

    • A、Flashback logs are written sequentially, and are archived.
    • B、Flashback Database uses a restored control file to recover a database.
    • C、The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area.
    • D、Flashback Database can recover a database to the state that it was in before a reset logs operation.
    • E、Flashback Database can recover a data file that was dropped during the span of time of the flashback.
    • F、Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.

    正确答案:B,C,F

  • 第6题：

    You are managing a single instance Oracle 10g database that utilizes the following parameters：  Which of the following set of commands must you execute to enable Flashback Database？（）

    • A、  STARTUP MOUNT EXCLUSIVE  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；
    • B、  STARTUP MOUNT  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS；
    • C、  STARTUP MOUNT EXCLUSIVE  ATLER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS；
    • D、  STARTUP MOUNT  ALTER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；

    正确答案:D

  • 第7题：

    Exhibit， Viewing the Exhibit and examine the Flashback Database architecture. Identify the missing component （shown with a "？`"= in the Flashback Database architecture.（）

    • A、 DBWn
    • B、 RVWR
    • C、 ARCH
    • D、 RECO
    • E、 TRWR

    正确答案:B

  • 第8题：

    单选题
    You are maintaining the SALES database for an organization. You have enabled the Flashback Database feature and want to estimate the flashback space required for future operations.  Which view would you query to estimate the flashback space required？（）
    A

     V$DATABASE

    B

     V$FLASHBACK_DATABASE_STAT

    C

     V$FLASHBACK_DATABASE_LOG

    D

     V$RECOVERY_FILE_DEST


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

  • 第9题：

    单选题
    View the Exhibit and examine the Flashback Database architecture.  Identify the missing component （shown with a "？"） in the Flashback Database architecture.（）
    A

    DBWn

    B

    RVWR

    C

    ARCH

    D

    RECO

    E

    TRWR


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

  • 第10题：

    单选题
    Exhibit， Viewing the Exhibit and examine the Flashback Database architecture. Identify the missing component （shown with a "？`"= in the Flashback Database architecture.（）
    A

     DBWn

    B

     RVWR

    C

     ARCH

    D

     RECO

    E

     TRWR


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

  • 第11题：

    多选题
    Which three actions are required to configure the Flashback Database？（）
    A

    set Flash Recovery Area

    B

    enable Flashback logging

    C

    create FLASHBACK tablespace

    D

    start the database in the ARCHIVELOG mode

    E

    start the database in the NOARCHIVELOG mode


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

  • 第12题：

    单选题
    You are managing a single instance Oracle 10g database that utilizes the following parameters：  Which of the following set of commands must you execute to enable Flashback Database？（）
    A

      STARTUP MOUNT EXCLUSIVE  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；

    B

      STARTUP MOUNT  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS；

    C

      STARTUP MOUNT EXCLUSIVE  ATLER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS；

    D

      STARTUP MOUNT  ALTER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；


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

  • 第13题：

    You want to flash back a test database by five hours.You issue this command:SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE － 5／24);Which two statements are true about this flashback scenario?()

    A. The database must have multiplexed redo logs for the flashback to succeed.

    B. The database must be MOUNTED for the flashback to succeed.

    C. The database must use block change tracking for the flashback to succeed.

    D. The database must be opened in restricted mode for the flashback to succeed.

    E. The database must be opened with the RESETLOGS option after the flashback is complete.

    F. The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.


    参考答案：E, F

  • 第14题：

    You are the administrator of a SQL Server 2000 computer. The server contains database named Sales. Users report that they cannot add new data to the database. You examine the properties of the database. The database is configured as shown in the Sales Properties exhibit.

    You examine drive E. The hard disk is configured as shown in the Local Disk Properties exhibit.

    You want the users to be able to add data, and you want to minimize administrative overhead. What should you do?

    A．Increase the maximum file size of Sales_Data to 1,500MB.

    B．Use the DBCC SHRINKDATABASE statement.

    C．Set automatic file growth to 10 percent.

    D．Create another data file named Sales_Data2 in a new SECONDARY filegroup.


    正确答案：A
    解析：Explanation: By examining the first exhibit we see that the database has reached its maximum size of 1001 MB. The data file is located on drive E and the second exhibit shows us that there is enough free space on that disk to increase the maximum size of the data file to 1,500 MB.

    Incorrect Answers:
    B: DBCC SHRINKDATABASE could possibly shrink the database and new records could be added for a while, but it would just be a temporary solution.

    C: The database is already set to automatic file growth, but it has reached the maximum size.

    D: The primary file has reached it maximum size. A secondary filegroup would help if it was set to the default file group. New data would still be added to the primary filegroup which is at its maximum size.

  • 第15题：

    Which background process sequentially writes Flashback Database data from the flashback buffer to the Flashback Database logs？（）

    • A、 DBWn
    • B、 RECO
    • C、 RVWR
    • D、 LGWR

    正确答案:C

  • 第16题：

    You are maintaining the SALES database for an organization. You have enabled the Flashback Database feature and want to estimate the flashback space required for future operations.  Which view would you query to estimate the flashback space required？（）

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

    正确答案:B

  • 第17题：

    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

  • 第18题：

    Which three actions are required to configure the Flashback Database? （）

    • A、set Flash Recovery Area
    • B、enable Flashback logging
    • C、create FLASHBACK tablespace
    • D、start the database in the ARCHIVELOG mode
    • E、start the database in the NOARCHIVELOG mode

    正确答案:A,B,D

  • 第19题：

    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

  • 第20题：

    单选题
    The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database？（）
    A

     Enable flashback logging.

    B

     Start the database in the ARCHIVELOG mode.

    C

     Issue the ALTER DATABASE FLASHBACK ON； command.

    D

     Set the FAST_START_MTTR_TARGET initialization parameter.


    正确答案： 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题：

    单选题
    Which background process sequentially writes Flashback Database data from the flashback buffer to the Flashback Database logs？（）
    A

     DBWn

    B

     RECO

    C

     RVWR

    D

     LGWR


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

  • 第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 Oracle Database 10g is online when you execute the following statement：        SQL>ALTER TABLESPACE MY_TABLESPACE FLASHBACK OFF；   What is the result of executing this statement if the Flashback Database feature is already enabled in the database？（）
    A

     The database does not record flashback logs for MY_TABLESPACE

    B

     The tables residing in MY_TABLESPACE are not protected by the Recycle Bin.

    C

     All the tablespaces except MY_TABLESPACE can be recovered using Flashback Database feature.

    D

     None of the flashback technologies， such as Flashback Table， Flashback Transaction Query and Flashback Version Query can be used to recover individual rows within the objects from MY_TABLESPACE


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

相关内容