TheINV_HISTORYtableiscreatedusingthecommand:CREATETABLEINV_HISTORY(inv_noNUMBER(3),inv_dateDATE,inv_amtNUMBER(10,2))partitionbyrange(inv_date)interval(numtoyminterval(1,’month’))(partitionp0valueslessthan(to_date(’01-01-2005’,’dd-mm-yyyy’)),partitionp1valueslessthan(to_date(’01-01-2006’,’dd-mm-yyyy’)));ThefollowingdatahasbeeninsertedintotheINV_HISTORYtable:INV_NOINV_DATEINV_AMT130-dec-20041000230-dec-2005200031-feb-2006300041-mar-2006400051-apr-20065000Youwouldliketostorethedatabelongingtotheyear2006inasinglepartitionandissuethe command:SQLALTERTABLEinv_historyMERGEPARTITIONSFOR(TO_DATE(’15-feb-2006’,’dd-mon-yyyy’)),FOR(TO_DATE(’15-apr-2006’))INTOPARTITIONsys_py;Whatwouldbetheoutcomeofthiscommand?()
TheINV_HISTORYtableiscreatedusingthecommand:&ens
TheINV_HISTORYtableiscreatedusingthecommand:
SQL>CREATETABLEINV_HISTORY(inv_noNUMBER(3),inv_dateDATE,inv_amtNUMBER(10,2))partitionbyrange(inv_date)interval(numtoyminterval(1,’month’))(partitionp0
valueslessthan(to_date(’01-01-2005’,’dd-mm-yyyy’)),partitionp1valueslessthan(to_date(’01-01-2006’,’dd-mm-yyyy’)));
ThefollowingdatahasbeeninsertedintotheINV_HISTORYtable:
INV_NOINV_DATEINV_AMT130-dec-20041000230-dec-2005200031-feb-2006300041-mar-2006400051-apr-20065000
Youwouldliketostorethedatabelongingtotheyear2006inasinglepartitionandissuethe command:
SQL>ALTERTABLEinv_historyMERGEPARTITIONS
FOR(TO_DATE(’15-feb-2006’,’dd-mon-yyyy’)),FOR(TO_DATE(’15-apr-2006’))INTOPARTITIONsys_py;
Whatwouldbetheoutcomeofthiscommand?()
相关考题:
在系统中,如果想要将IP地址永久保存,可以配置系统的网络接口配置文件,以下那个是RHEL7.5的接口配置文件?A./etc/sysconfig/network-scripts/B./etc/sysconfig/network-scripts/ifcfg-ens33C./etc/sysconfig/network-scripts/ifupD./etc/sysconfig/network-scripts/ifdown
将接口ens33 的ip 地址设置为172.19.18.15,子网掩码255.255.255.0 ,如下哪个命令可以达成?A.ifconfig ens33 172.19.18.15 netmask 255.255.255.0B.ip addr add 172.19.18.15 netmask 255.255.255.0 brd + dev ens33C.ifconfig eth0 172.19.18.15/24D.i p addr add 172.19.18.15 netmask 255.255.255.0 ens33
关于Linux网络接口查看,下面描述正确的是A.可以用nmcli device status命令来查看主机上所有接口设备概况B.在CentOS 7 中接口网络接口默认的设备名是eth加上数字的形式C.只有根用户才能够查看网络接口D.可以用nmcli device show ens33命令来查看主机上ens33接口的详情
3、将接口ens33 的ip 地址设置为172.19.18.15,子网掩码255.255.255.0 ,如下哪个命令可以达成?A.ifconfig ens33 172.19.18.15 netmask 255.255.255.0B.ip addr add 172.19.18.15 netmask 255.255.255.0 brd + dev ens33C.ifconfig eth0 172.19.18.15/24D.ip addr add 172.19.18.15 netmask 255.255.255.0 ens33
4、在系统中,如果想要将IP地址永久保存,可以配置系统的网络接口配置文件,以下那个是RHEL7.5的接口配置文件?A./etc/sysconfig/network-scripts/B./etc/sysconfig/network-scripts/ifcfg-ens33C./etc/sysconfig/network-scripts/ifupD./etc/sysconfig/network-scripts/ifdown
临时配置IP地址应该使用如下那个命令?A.ip addr add 192168.2.10/24 dev ens33B.ip addr del 192.168.2.10/24 dev ens33C.ip addr add 192.168.2.10/24 devD.ip addr del 192.168.2.10/24 ens33