A. Jobs B. Chains C. Windows D. Window groups E. Schedule
单项选择题TheDBAhaschosentomanageSGAandPGAmemoryseparatelyinanOLTPdatabasebecauseofhisuniqueknowledgeoftheapplication.WhichofthesearegoodstartingpointstousewhenconfiguringthemaximumvaluesforSGAandPGA,basedontheamountofmemoryavailableonthesystem?()
A. 20% SGA 80% PGA B. 25% SGA 75% PGA C. 50% SGA 50% PGA D. 75% SGA 25% PGA E. 80% SGA 20% PGA
多项选择题InaDatabaseReplayworkloadcapture,whatclientrequestinformationisgathered?()
A. SQL text B. Shared server requests (Oracle MTS) C. Bind variable values D. Information about transactions E. Remote DESCRIBE and COMMIT operations
单项选择题Adevelopercallsandreportsthatheaccidentallydroppedanimportantlookuptablefromaproductiondatabase.Heneedsthetabletoberecovered.Whatactionwouldyoutake?()
A. Initiate an incomplete recovery operation using RMAN. B. Copy the table from a development database. C. Advise the user to rekey the data. D. Perform a Flashback Drop operation. E. Perform a Flashback Recovery operation.
单项选择题Auserperformsanupdateonatable.Shortlyaftercommittingthetransaction,theyrealizethattheyhadanerrorintheirWHEREclausecausingthewrongrowstobeupdated.WhichFlashbackoptionwouldallowyoutoundothistransactionandrestorethetabletoitspreviousstate?()
A. Flashback Drop B. Flashback Query C. Flashback Versions Query D. Flashback Transaction Query E. Flashback Table
单项选择题WhatRMANcommandisusedtoexecuteatablespacepoint-in-timerecovery?()
A. recover B. duplicate C. restore D. copy E. None of the above