单项选择题
The DBA has chosen to manage SGA and PGA memory separately in an OLTP database because of his unique knowledge of the application. Which of these are good starting points to use when configuring the maximum values for SGA and PGA，based on the amount of memory available on the system？（）
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
