You need to create a partitioned table to store historical data and you issued the following command：   CREATE TABLE purchase_interval PARTITION BY RANGE （time_id） INTERVAL （NUMTOYMINTERVAL（1，’month’）） STORE IN （tbs1，tbs2，tbs3） （ PARTITION p1 VALUES LESS THAN（TO_DATE（’1-1-2005’， ’dd-mm-yyyy’））， PARTITION p2 VALUES LESS THAN（TO_DATE（’1-1- 2007’， ’dd-mm-yyyy’）））  AS SELECT * FROM purchases WHERE time_id 

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.

C、 It 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.

Examine the output of the query that you executed to list the objects in the recycle bin: You verified that no table named SALES_TAB exists in the schema. Then you executed the following command to purge the objects in the recycle bin: SQL> PURGE TABLE sales_tab; What would be the outcome of this command?（）

A、 All three tables in the recycle bin are purged

B、 Only the table with the oldest DROPSCN is purged

C、 The command returns an error because multiple entries with the same name exist in the recycle bin

D、 Only the table with the latest DROPSCN is purged

Which two code fragments correctly create and initialize a static array of int elements？（）

A

B

C

D

患者女性，68岁。反复咳嗽、喘息20年，加重1周入院。查体：神清，口唇发绀，颈静脉怒张，双肺散在中小水泡音。心率120次／分，律齐。肝肋下3cm，双下肢可凹性水肿。外周血白细胞12×109/L，中性粒细胞80%。X线胸片示右下肺动脉大于17mm，双肺纹理重。患者的医疗诊断是（）

A、呼吸衰竭

B、右心衰竭

C、肺源性心脏病

D、慢性阻塞性肺疾病

E、慢性支气管炎急性发作

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

慢性阻塞性肺气肿最重要的慢性并发症是（）

A、肺结核

B、自发性气胸

C、肺不张

D、慢性肺源性心脏病

E、肺炎