题目内容

樟树(名词解释)

查看答案
更多问题

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?()

喜树(名词解释)

答案查题题库