black

1z0-043

登录

多项选择题

You are performing flashback of the EMPLOYEE table in SCOTT’s schema because some incorrect data was inserted into the table and committed by mistake. Which two clauses will you use in the FLASHBACK TABLE statement for using the Flashback Table feature? ()

A. RESETLOGS
B. TO TIMESTAMP
C. TO BEFORE DROP
D. RENAME TO
E. TO SCN

相关考题

单项选择题 You are working as a Database Administrator. You erroneously dropped an important table named WAREHOUSE_DETAILS. The table resides in a non-SYSTEM tablespace.  The following dependent objects have been defined on the dropped table:       Due to limited space, some of the indexes and triggers have been removed from the Recycle Bin. You decide to recover the table by using Flashback Drop. You execute the following statement: SQL>FLASHBACK TABLE warehouse_details TO BEFORE DROP;   What will be the implication of executing this statement?()

多项选择题 OnJan11,2005at2:30P.M.,anerroneousupdateoperationmodifiedallthevaluesofcolumnLASTNAMEintheEMPLOYEEtableintheScottschematoanemptystring.Youarethesystemadministrator,andyouwanttoreturntheoriginalvaluesinthetable.Todoso,youdecidedtoflashbackthetable.Whichtwooptionscanyouusetoflashbackatable?()

单项选择题 YouwanttousetheFlashbackTransactionQueryfeaturetoidentifyallthechangesmadetoyourdatabasewithinaspecifictimeperiod.WhatisaprerequisiteforusingtheFlashbackTransactionQueryfeature?()

All Rights Reserved 版权所有©建筑考试题库(jzkao.com)

备案号:湘ICP备2020024380号-3