多项选择题

Which two statements are true about Shared SQL Area and Private SQL Areas（）

A.Shared SQL Area will be allocated in the shared pool.
B.Shared SQL Area will be allocated when a session starts.
C.Shared SQL Area will be allocated in the large pool always.
D.The whole of Private SQL Area will be allocated in the Program Global Area （PGA） always.
E.Shared SQL Area and Private SQL Area will be allocated in the PGA or large pool.
F.The number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter.

<上一题目录下一题>

热门试题

单项选择题Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client whileconnecting to the database instance from a remote machine（）

A.Host naming method
B.Local naming method
C.External naming method
D.Directory naming method

多项选择题You execute this command to drop the ITEM table， which has the primary key referred in the ORDERS table：SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE； Which two statements are true about theeffect of the command（）

A.No flashback is possible to bring back the ITEM table.
B.The ORDERS table is dropped along with the ITEM table.
C.The dependent referential integrity constraints in the ORDERS table are disabled.
D.The dependent referential integrity constraints in the ORDERS table are removed.
E.The table definition of the ITEM table and associated indexes are placed in the recycle bin

单项选择题You want to import schema objects of the HR user using Oracle Data Pump from the development database，DEVDB， to the production database， PRODDB. A database link devdb.us.oracle.com is created betweenPRODDB and DEVDB. You execute the following command on the PRODDB database server：$ impdp system manager directory = DB_DATAdumpfile = schemas.datschemas = hr flashback_time = TO_TIMESTAMP（’25-08-2007 14：35：00’， ’DD-MM-YYYY HH24：MI：SS’） The command fails displaying the following error：ORA-39001： invalid argument valueORA-39000： bad dump file specification ORA-31640： unable to open dump file home oracle schema schemas.dat for read ORA-27037： unable toobtain file status What would you do to overcome the error（）

A.Add the user， SYSTEM， to the schemas option.
B.Add the network_link = devdb.us.oracle.com option.
C.Change the dumpfile option to schema.dat@devdb.us.oracle.com.
D.Replace the schemas option with the network_link = devdb.us.oracle.com
E.Replace the dumpfile option with the network_link = devdb.us.oracle.com

多项选择题Which two operations can be performed on an external table（）

A.Create a view on the table.
B.Create an index on the table.
C.Create a synonym on the table.
D.Add a virtual column to the table.
E.Update the table using the UPDATE statement.
F.Delete rows in the table using the DELETE command

单项选择题Your database is configured in shared server mode. However， your senior DBA asks you to modify the value ofthe 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