多项选择题
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？ （）
A.A
B.B
C.C
D.D
E.E
相关考题
-
单项选择题
Oracle9iextendsthecursorsharingfunctionalitywiththenewvalueofSIMILARfortheCURSOR_SHARINGparameter.WithCURSOR_SHARING=SIMILAR，cursorsaresharedforsafeliteralsonly.Whatismeantby‘safeliteralsonly’？（）
A.No literal value is substituted for a shared cursor.
B.Different execution plans are generated for substituted literal values.
C.The substitution of a literal value will produce different execution plans.
D.The substitution of any literal value will produce exactly the same execution plan. -
单项选择题
WhatcriteriondoesOracle9iusetodeterminewhetheradatabasefileisanOracleManagedFile？（）
A.The filename format.
B.Information stored inside a data dictionary table.
C.Information stored in the ALERT.LOG file for the corresponding instance.
D.Information stored inside the corresponding initialization parameter file for the instance.
