对 Course表 使用课程号 课程名 学分 及额外增加的iXueshi字段创建视图 学时为学分乘以16 正确的
已帮助 人
对 Course表，使用课程号，课程名，学分，及额外增加的iXueshi字段创建视图，学时为学分乘以16，正确的SQL语句是（)。
A．Create View ShiTu As Select Cno,Cname ,Ccredit ,Ccredit *16 as iXueshi from Course
B．Create View ShiTu As Select Cno,Cname ,Ccredit ,Ccredit *16 from Course
C．Create Proc ShiTu As Select Cno,Cname ,Ccredit ,Ccredit *16 as iXueshi from Course
D．Create Index ShiTu As Select Cno,Cname ,Ccredit ,Ccredit *16 as iXueshi from Course
回答
共1条回复-
Create View ShiTu As Select Cno,Cname ,Ccredit ,Ccredit *16 as iXueshi from Course