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.
After making changes to IP aliasing and rebooting the system, an AIX server is unable to communicate with other hosts. Which command can be run to check ent0 adapter configuration relative to IP address and network mask?()
A、ifconfig -a
B、errpt -a
C、cfgmgr -v
D、entstat -d ent0
Which command will show network statistics such as kernel malloc and mblk failures?()
A、ifconfig -m
B、netstat -m
C、iptrace -a
D、errpt -a
A modem is set up for a remote TTY connection that will become the system console. How should one verify that the console is enabled as the system console after the next reboot?()
A、lscons -b
B、lscons -d
C、lscons -s
D、swcons /dev/tty0
一般风速的轻负荷区架空线路相隔多少档杆数交替设立防凌杆()。
A、8
B、12
C、16
D、20