网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
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


参考答案

参考解析
解析: 暂无解析
更多 “单选题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” 相关考题
考题 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.

考题 ViewtheExhibitandexaminetheFlashbackDatabasearchitecture.Identifythemissingcomponent(shownwitha?)intheFlashbackDatabasearchitecture.() A.DBWnB.RVWRC.ARCHD.RECOE.TRWR

考题 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.

考题 Exhibit,ViewingtheExhibitandexaminetheFlashbackDatabasearchitecture.Identifythemissingcomponent(shownwitha"?`"=intheFlashbackDatabasearchitecture.() A.DBWnB.RVWRC.ARCHD.RECOE.TRWR

考题 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.

考题 Which background process sequentially writes Flashback Database data from the flashback buffer to the Flashback Database logs?()A、 DBWnB、 RECOC、 RVWRD、 LGWR

考题 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_LOGB、 V$FLASHBACK_DATABASE_STATC、 V$DATABASED、 V$UNDOSTAT

考题 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$DATABASEB、 V$FLASHBACK_DATABASE_STATC、 V$FLASHBACK_DATABASE_LOGD、 V$RECOVERY_FILE_DEST

考题 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.

考题 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 RecoveryArea.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.

考题 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;

考题 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

考题 You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information?()A、 Query the V$FLASHBACK_DATABASE_LOG view.B、 Query the V$FLASHBACK_DATABASE_STAT view.C、 Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.D、 Query the V$RECOVERY_FILE_DEST view.

考题 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_STATview aretrue? ()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.

考题 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$DATABASEB、 V$UNDOSTATC、 V$FLASHBACK_DATABASE_LOGD、 V$FLASHBACK_DATABASE_STAT

考题 At 10:30 A.M., you ran a batch job by mistake, which executed a transaction in the database. The transaction identifier of the transaction that made to the changes in the database is 0500A00627B000. At 11:10 A.M., you stopped the batch job. Now, you want to identify the changes made to the database tables by the batch job. Which view will you query?()A、 DBA_PENDING_TRANSACTIONSB、 DBA_AUDIT_STATEMENTC、 V$FLASHBACK_DATABASE_STATSD、 FLASHBACK_TRANSACTION_QUERY

考题 单选题At 10:30 A.M., you ran a batch job by mistake, which executed a transaction in the database. The transaction identifier of the transaction that made to the changes in the database is 0500A00627B000. At 11:10 A.M., you stopped the batch job. Now, you want to identify the changes made to the database tables by the batch job. Which view will you query?()A  DBA_PENDING_TRANSACTIONSB  DBA_AUDIT_STATEMENTC  V$FLASHBACK_DATABASE_STATSD  FLASHBACK_TRANSACTION_QUERY

考题 单选题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$DATABASEB  V$FLASHBACK_DATABASE_STATC  V$FLASHBACK_DATABASE_LOGD  V$RECOVERY_FILE_DEST

考题 多选题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? ()ABEGIN_TIME is the time at which Flashback logging is enabled.BEND_TIME is the time at which the query is executed on the view.CREDO_DATA is the number of bytes of redo data written during the interval.DThis view contains information about flashback data pertaining to the last 24 hours.EFLASHBACK_DATA is the amount of flashback data generated since the database was opened.

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

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

考题 单选题Which background process sequentially writes Flashback Database data from the flashback buffer to the Flashback Database logs?()A  DBWnB  RECOC  RVWRD  LGWR

考题 多选题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_STATview aretrue? ()ABEGIN_TIME is the time at which Flashback logging is enabled.BEND_TIME is the time at which the query is executed on the view.CREDO_DATA is the number of bytes of redo data written during the interval.DThis view contains information about flashback data pertaining to the last 24 hours.EFLASHBACK_DATA is the amount of flashback data generated since the database was opened.

考题 单选题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$DATABASEB  V$UNDOSTATC  V$FLASHBACK_DATABASE_LOGD  V$FLASHBACK_DATABASE_STAT

考题 多选题Which three actions are required to configure the Flashback Database?()Aset Flash Recovery AreaBenable Flashback loggingCcreate FLASHBACK tablespaceDstart the database in the ARCHIVELOG modeEstart the database in the NOARCHIVELOG mode

考题 单选题You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information?()A  Query the V$FLASHBACK_DATABASE_LOG view.B  Query the V$FLASHBACK_DATABASE_STAT view.C  Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.D  Query the V$RECOVERY_FILE_DEST view.

考题 单选题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;

考题 单选题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_LOGB  V$FLASHBACK_DATABASE_STATC  V$DATABASED  V$UNDOSTAT