单项选择题

TheDBAhaschosentomanageSGAandPGAmemoryseparatelyinanOLT……

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

单项选择题WhatRMANcommandisusedtoexecuteatablespacepoint-in-timerecovery？（）

A. recover
B. duplicate
C. restore
D. copy
E. None of the above

单项选择题You have configured flash recovery area in your database and you set the following Initialization parameters for your database instance： LOG_ARCHIVE_DEST 1 = ，，LOCATION= disk1 arch MANDATORY’ LOG _ARCHIEVE_DEST 2 = ，，LOCATION= disk2 arch’ LOG_ARCHIVK_DEST_3 = ，，LOCATION= diSk3 arch LOG_ARCH1VK_DEST_4 = ’ LOCATION= disk4 arch’ LOG_ARCHIVE_MIN-SUCCEED_DEST = 2 While the database instance is functional，you realized that the destination set by the LOG_ARCHIVE_DEST_I parameter Is not available for the archived redo log file to be created in. All redo log groups have been used. What happens in an event of log switch？（）

A. The online redo log file Is not allowed to be overwritten.
B. The archived redo log files are written to the flash recovery area until the MANDATORY destination is made available.
C. The database instance will crash because the archived redo log file cannot be created in a destination set as MANDATORY.
D. The destination set by the LOG_ARCHIVE_DEST_1 parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.