A.Host naming methodB.Local naming methodC.External nam……

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

多项选择题Whichtwostatementscorrectlydescribetherelationbetweenadatafileandthelogicaldatabasestructures（）

A.An extent cannot spread across data files.
B.A segment cannot spread across data files.
C.A data file can belong to only one tablespace.
D.A data file can have only one segment created in it.
E.A data block can spread across multiple data files as it can consist of multiple operating system （OS）blocks