单项选择题

Attheendofthefinancialyear，anaccountsaccumulationbatchisrun.Thisbatchupdatesthecompany’saccountingrecords.Duringthebatchrunprocess，someincorrectentrieswereinsertedintotheACCOUNTtable.Youidentifiedthebugandimmediatelystoppedthebatchrunprocess，but3000incorrectrecordswereinsertedintotheACCOUNTtablebeforethebatchprocesswasstopped.Youwanttorecoverthetabletothestateitwasat11：50P.M.Whichflashbackfeaturewillyouuse？（）
A.FlashbackDrop
B.FlashbackDatabase
C.FlashbackTable
D.FlashbackVersionQuery

A.Thisbatchupdatesthecompany’saccountingrecords.Duringthebatchrunprocess，someincorrectentrieswereinsertedintotheACCOUNTtable.Youidentifiedthebugandimmediatelystoppedthebatchrunprocess，but3000incorrectrecordswereinsertedintotheACCOUNTtablebeforethebatchprocesswasstopped.Youwanttorecoverthetabletothestateitwasat11：50P.M.Whichflashbackfeaturewillyouuse？（）
A.FlashbackDrop
B.FlashbackDatabase
C.FlashbackTable
D.FlashbackVersionQuery

<上一题目录下一题>

热门试题

未分类题

You are adatabase developer.You develop ataskmanagementapplication that connect stoa SQLServer2008databasenamed TaskDB.Users logon to the application by using a SQLServer login. The application containsamodulenamed Taskthatassignstaskstousers.Informationaboutthe setasksisstoredinthe Taskstableofthe TaskDB data base.The Taskstablecontainsmultiplecolumns.These include the Close Dateand Estimated Timecolumns.Theapplication mustmeetthefollowingsecurityrequirements:Usersassigned toad atabase role named User 1 canupd ate all taskinformation columnsexceptthe Close Dateandthe Estimated TimecolumnsintheTaskstable.Administrative usersassigned toad atabase rolenamed Task_Admincanupd ateall taskinformation intheTaskstable.Youneedtodesignastrategy tomeetthesecurityrequirements.Whichtwoactionsshouldyouperform?（）

单项选择题

YouaremaintainingyourdatabaseinOracle10g.YoufindthattheINDEXESindextablespaceshouldberecovered.Howwillyourecovertheindextablespace？（）

A.byusingtheFlashbackDatabasefeature
B.byusingRMANincompleterecovery
C.byperformingauser-managedincompleterecovery
D.bydroppingandre-creatingtheindextablespace