多项选择题
Which tablespaces are mandatory in an Oracle database for it to be operational（）
A.Undo tablespace
B.USERS tablespace
C.SYSAUX tablespace
D.SYSTEM tablespace
E.Temporary tablespace
相关考题
-
多项选择题
Identifytwosituationsinwhichtheblockheadergrowsinadatablock.（）
A.when row directories need more row entries
B.when there is row migration in the data block
C.when there is an increase in the PCTFREE value for the data block
D.when more transaction slots are required than are initially configured -
多项选择题
Whichtwostatementsaretrueregardingatablespace（）
A.It can span multiple databases.
B.It can consist of multiple data files.
C.It can contain blocks of different sizes.
D.It can contain segments of different sizes.
E.It can contain a part of a nonpartitioned segment. -
单项选择题
Your database is configured in shared server mode. However， your senior DBA asks you to modifythe value of the PRIVATE_SGA limit in the profile of the users. What could be the reason for this（）
A.to limit the User Global Area （UGA） memory allocated to a session from the SGA
B.to limit the amount of memory to be used for the dispatcher queue of a session in SGA
C.to limit the amount of memory to be used for the request pool in System Global Area （SGA）
D.to control the amount of memory allocated in SGA for the local variables for each shared server process
