多项选择题

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

多项选择题

Which two statements correctly describe the relation between a data file and the logical database structures（）

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

多项选择题

A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTER TABLEcommand with the ENABLE VALIDATE option to enable the constraint that was disabled.
What are the twoeffects of this command（）

A.It fails if any existing row violates the constraint.
B.It does not validate the existing data in the table.
C.It enables the constraint to be enforced at the end of each transaction.
D.It prevents insert， update， and delete operations on the table while the constraint is in the process of beingenabled