You need to create a partitioned tabl

You need to create a partitioned table to store historical data and you issued the following command: What is the outcome of the above command?（）

A It returns an error because the range partitions P1 and P2 should be of the same range.
B It creates two range partitions (P1, P2). Within each range partition, it creates monthwise subpartitions.
CIt creates two range partitions of varying range. For data beyond '1-1-2007,' it creates partitions with a width of one month each.
D It returns an error because the number of tablespaces (TBS1,TBS2,TBS3)specified does not match the number of range partitions (P1,P2) specified.

参考答案

参考解析：

分类：OCP 11G认证考试题库

You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty.Which statement accomplishes...

You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for depar...

You need to create a data block for DML operations in the NEW_EMPLOYEE form modul...

You need to create a form for Payroll application that will allow the user to&#81...

You need to create a table named ORDERS that contain four columns:1. an ORDER_ID column of number data type2. aCUSTOMER_ID column of number da...

You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for depar...

编辑推荐