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

题目

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

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

A.DBWn

B.RVWR

C.ARCH

D.RECO

E.TRWR


参考答案:B

第2题:

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

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

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

第5题:

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

A.DBWn

B.RVWR

C.ARCH

D.RECO

E.TRWR


参考答案:B

第6题:

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.


参考答案:C, D

第7题:

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

第8题:

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

第9题:

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.

第10题:

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

更多相关问题