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?()


相关考题:

在ENS数据配置中,哪条命令配置用户的ENMU数据?() A.ADD DNAPTRRECB.ADD DSRVRECC.ADD DDNSRECD.ADD NAPTRREC

28、是鼻腔音[ɑ̃]还是[ɔ̃]?(请根据空格数量填写字母或字母组合) ens_ _ble

在系统中,如果想要将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

8、ENS是高等师范学校培养的是未来的教师,而HEC则是培养国家干部的学校。()

临时配置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