Which tablespaces are mandatory in an Oracle database for it to be operational（）

多项选择题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

单项选择题Your database instance is currently configured to support 1，500 connections. The Web applicationthat uses the database allows a large number of users to work with the database simultaneously. Someusers of the Web application do not interact with the server all the time.  You want to increase the scalability by configuring the database instance to handle more connections. Asa DBA，  which configuration would you set to support more than 1，500 connections at a time（）

A.You would configure more listeners for the database.
B.You would configure the database in shared server mode to use the connection pooling feature.
C.You would increase the value of the PGA_AGGREGATE_TARGET initialization parameter that assigns more session memory to users.
D.You would decrease the value of the PRIVATE_SGA resource limit in the profiles used by the users to accommodate more session information.

单项选择题You have two database servers SEMP and SACCT. The database in the SEMP server maintains theemployee information and the database in the SACCT server maintains the accounts payable  information.The employees submit the expense reports to the accounts payable department. A user of the accountspayable database wants to extract the employee information from the database in the SEMP server for cross-verification.  Which schema object enables the user to access the information from the remote database（）

A.Cluster
B.Database link
C.Mapping table
D.Materialized view