题目内容

At5：30PM，adatabaseadministrator，William，isinformedthatanimportantrecordofemployeenoE0025ismissingfromtheSCOTT.EMPLOYEEtable.At4：30P.M，thetablecontainedtherecordofemployeenoE0025.WilliamissuesthefollowingcommandtofindtheSQLstatementsthatareusedtoundothedeletion：
SELECToperation，undo_sql，logon_user
FROMFLASHBACK_TRANSACTION_QUERYWHERExid=
HEXTORAW（’0100043E23456’）；
where’0100043E23456’isthetransactionIDofthetransactionthatdeletedtherow.Beforeissuingtheabovestatement，whichtaskdidWilliamperformtoidentifythetransactionIDofthetransactionthatdeletedtherow？（）

查看答案

搜索结果不匹配？点我反馈

更多问题

向心枯亡（名词解释)

YouareworkingasaDBAonOracleDatabase9i.Youplantoupgradeyour9idatabasetoOracle10g.Tobefamiliarwiththenewdatabasetechnology，youdecidetoinstallOracleDatabase10gonyourworkstationathome.Youcreateageneralpurposedatabase.
Aftertheinstallation，youmakethefollowingchangesinyourinitializationparameterfile：LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST’
DB_RECOVERY_FILE_DEST=
’LOCATION=d：\product\10.1.0\flash_recovery_area’
DB_RECOVERY_FILE_DEST_SIZE=10g
Wherearethearchivedredologsstoredforyourdatabase？（）

喜树（名词解释)

牡丹（名词解释)