多项选择题

Which statements are true regarding system-partitioned tables?（）

A. Only a single partitioning key column can be specified.
B. All DML statements must use partition-extended syntax.
C. The same physical attributes must be specified for each partition.
D. Unique local indexes cannot be created on a system-partitioned table.
E. Traditional partition pruning and partitionwise joins are not supported on these tables.

点击查看答案

上一题目录下一题

相关考题

多项选择题

Which two statements are true regarding the starting of the database instance using the following command?（）
SQL>STARTUP UPGRADE

A. It enables all system triggers.
B. It allows only SYSDBA connections.
C. It ensures that all job queues remain active during the upgrade process.
D. It sets system initialization parameters to specific values that are required to enable database upgrade scripts to be run.

多项选择题

Which two kinds of failures make the Data Recovery Advisor (DRA)generate a manual checklist? （）

A. failures because a data file is renamed by error
B. failures when no standby database is configured
C. failures that require no archive logs to be applied for recovery
D. failures due to loss of connectivity-for example, an unplugged disk cable

单项选择题

You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain a separation of responsibilities along with a consolidation of RMAN repository.
Which condition must be met before you create the VPC?（）

A. A base catalog exists
B. The recovery catalog is empty
C. The base recovery catalog must be dropped
D. A target database is registered in the recovery catalog