单项选择题
A.Define user profiles and set the CPU_PER_CALL limit.
B.Define a SWITCH_TIME for a plan in the Resource Manager.
C.Create a batch job that checks V$SESSION_LONGOPS；the batch job alters the session priority of the long running operations.
D.Create a user defined event in the Oracle Enterprise Manager， which monitors V$SESSION_LONGOPS.
多项选择题 he Dynamic SGA feature allows the SGA to grow and shrink dynamically according to an ALTER SYSTEM command. This avoids the previous need of shutting down the instance in order to modify the components of the SGA， namely the buffer cache and shared pool components. Which three statements are true for the Dynamic SGA feature？ （）
单项选择题 Oracle9iextendsthecursorsharingfunctionalitywiththenewvalueofSIMILARfortheCURSOR_SHARINGparameter.WithCURSOR_SHARING=SIMILAR，cursorsaresharedforsafeliteralsonly.Whatismeantby‘safeliteralsonly’？（）
单项选择题 WhatcriteriondoesOracle9iusetodeterminewhetheradatabasefileisanOracleManagedFile？（）