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