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

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

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第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题:

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

第3题:

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.


参考答案:B

第4题:

These are the details about V$FLASHBACK_DATABASE_STAT:  SQL> DESC V$FLASHBACK_DATABASE_STAT Name Null? Type  ------------- -------- --------------  BEGIN_TIME DATE END_TIME DATE  FLASHBACK_DATA NUMBER  DB_DATA NUMBER REDO_DATA NUMBER  ESTIMATED_FLASHBACK_SIZE NUMBER  Which two statements regarding the V$FLASHBACK_DATABASE_STAT view are true? ()

  • A、BEGIN_TIME is the time at which Flashback logging is enabled.
  • B、END_TIME is the time at which the query is executed on the view.
  • C、REDO_DATA is the number of bytes of redo data written during the interval.
  • D、This view contains information about flashback data pertaining to the last 24 hours.
  • E、FLASHBACK_DATA is the amount of flashback data generated since the database was opened.

正确答案:C,D

第5题:

You are working as a DBA at NetFx Corporation. You discover that the SCOTT schema is deleted by mistake. You decide to flash the database back to the time when the schema existed. Which view will you query to determine the estimated size of the flashback data that you require for your current target retention?()

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

正确答案:A

第6题:

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

A.DBWn

B.RVWR

C.ARCH

D.RECO

E.TRWR


参考答案:B

第7题:

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

第8题:

ViewtheExhibitandexaminetheFlashbackDatabasearchitecture.Identifythemissingcomponent(shownwitha"?")intheFlashbackDatabasearchitecture.()

A.DBWn

B.RVWR

C.ARCH

D.RECO

E.TRWR


参考答案:B

第9题:

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

第10题:

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

更多相关问题