单项选择题
单项选择题 (海淀零模)黏菌是一种在腐烂有机质中生活的单细胞生物。食物短缺时,可聚集成团。成团的黏菌能通过最短路径找到食物。下列关于黏菌的描述不正确的是()
单项选择题 查看BRICKS表的说明:NAMENULLTYPE-----------------------------------------BRICK__IDNUMBERSHAPEVARCHAR2COLORVARCHAR2WEIGHTNUMBER查看BRICKS__STAGE表的说明:NAMENULLTYPE-----------------------------------------WEIGHTNUMBERSHAPEVARCHAR2COLORVARCHAR2哪两条语句将成功执行()A.SELECTshape,color,weightFROMbricksMINUSSELECT*FROMbricks_stageB.SELECTshape,colorFROMbricksMINUSSELECTcolor,shapeFROMbricks_stageC.SELECTshape,colorFROMbricksMINUSSELECTweight,colorFROMbricks_stageD.SELECT*FROMbricksMINUSSELECT*FROMbricks_stageE.SELECTbrick_id,shapeFROMbricksMINUSSELECTweight,colorFROMbricks_stage
单项选择题 查看EMP表的以下说明:NAMENULLTYPE-----------------------------------------EMPNONOTNULLNUMBERENAMEVARCHAR2SALNUMBER(7,DEPTNONUMBER执行以下查询:SELECTdeptnoAS"departments",SUM(sal)AS"salary"FROMempGROUPBY1HAVINGSUM(sal)>3000;结果是什么()A.仅返回总薪水大于3000的部门,按照部门排序B.所有部门,以及薪水大于3000的员工的薪水总和C.错误D.仅返回总薪水大于3000的部门,不按特定顺序排序