单项选择题

Younoticethatajobinachainhasnotcompletedonanonconstrain……

You notice that a job in a chain has not completed on a nonconstrained RAC database. Which of these are valid reasons why that might occur？（）

A. The job priority is 1 and the resource consumer group CPU emphasis allocation is a low percentage.
B. The job affinity is to a service and one node in that service is unavailable.
C. The job affinity is to an instance and that instance is unavailable.
D. There is no service affinity.
E. None of the above.

<上一题目录下一题>

热门试题

单项选择题Whichofthefollowingarenotdisabledbydefault？（）

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