设有关系模式:教师表(教师号,教师名,所在系,工资),现需建立一个统计每个系全体教师工资总额的视图,正确的语句是
A.CREATE VIEW SalaryView (系名,工资总额) AS SELECT 所在系, COUNT( 工资 ) FROM 教师表 GROUP BY 所在系
B.CREATE VIEW SalaryView (系名,工资总额) AS SELECT 所在系, SUM( 工资 ) FROM 教师表 GROUP BY 所在系
C.CREATE VIEW SalaryView AS
D.CREATE VIEW SalaryView AS SELECT 所在系, SUM( 工资 ) FROM 教师表 GROUP BY 所在系
查看答案
正确答案: B 答案分析:无
包含此试题的试卷:
相关的试题
A.CREATE VIEW SalaryView (系名,工资总额) AS SELECT 所在系, COUNT( 工资 ) FROM 教师表 GROUP BY 所在系
B.CREATE VIEW SalaryView (系名,工资总额) AS SELECT 所在系, SUM( 工资 ) FROM 教师表 GROUP BY 所在系
C.CREATE VIEW SalaryView AS
D.CREATE VIEW SalaryView AS SELECT 所在系, SUM( 工资 ) FROM 教师表 GROUP BY 所在系
A.CREATE VIEW SalaryView (系名,工资总额) AS SELECT 所在系, COUNT( 工资 ) FROM 教师表 GROUP BY 所在系
B.CREATE VIEW SalaryView (系名,工资总额) AS SELECT 所在系, SUM( 工资 ) FROM 教师表 GROUP BY 所在系
C.CREATE VIEW SalaryView AS
D.CREATE VIEW SalaryView AS SELECT 所在系, SUM( 工资 ) FROM 教师表 GROUP BY 所在系
A.CREATE VIEW SalaryView (系名,工资总额) AS SELECT 所在系, COUNT( 工资 ) FROM 教师表 GROUP BY 所在系
B.CREATE VIEW SalaryView (系名,工资总额) AS SELECT 所在系, SUM( 工资 ) FROM 教师表 GROUP BY 所在系
C.CREATE VIEW SalaryView AS
D.CREATE VIEW SalaryView AS SELECT 所在系, SUM( 工资 ) FROM 教师表 GROUP BY 所在系
A.CREATE VIEW SalaryView (系名,工资总额) AS SELECT 所在系, COUNT( 工资 ) FROM 教师表 GROUP BY 所在系
B.CREATE VIEW SalaryView (系名,工资总额) AS SELECT 所在系, SUM( 工资 ) FROM 教师表 GROUP BY 所在系
C.CREATE VIEW SalaryView AS
D.CREATE VIEW SalaryView AS SELECT 所在系, SUM( 工资 ) FROM 教师表 GROUP BY 所在系
A.CREATE VIEW SalaryView (系名,工资总额) AS SELECT 所在系, COUNT( 工资 ) FROM 教师表 GROUP BY 所在系
B.CREATE VIEW SalaryView (系名,工资总额) AS SELECT 所在系, SUM( 工资 ) FROM 教师表 GROUP BY 所在系
C.CREATE VIEW SalaryView AS
D.CREATE VIEW SalaryView AS SELECT 所在系, SUM( 工资 ) FROM 教师表 GROUP BY 所在系
A.CREATE VIEW SalaryView (系名,工资总额) AS SELECT 所在系, COUNT( 工资 ) FROM 教师表 GROUP BY 所在系
B.CREATE VIEW SalaryView (系名,工资总额) AS SELECT 所在系, SUM( 工资 ) FROM 教师表 GROUP BY 所在系
C.CREATE VIEW SalaryView AS
D.CREATE VIEW SalaryView AS SELECT 所在系, SUM( 工资 ) FROM 教师表 GROUP BY 所在系
设有关系模式 SC( Sno, Sname, Sex, Birthday, Cno, Cname, Grade, Tno, Tname)满足函数 依赖集: {Sno→Sname, Sno→Sex, Sno→Birthday, Cno→Cname, (Sno, Cno)→Grade, Tno→ Tname}.SC 的主码和属性集( Sno, Tno)的闭包分别是
A.CREATE VIEW SalaryView (系名,工资总额) AS SELECT 所在系, COUNT( 工资 ) FROM 教师表 GROUP BY 所在系
B.CREATE VIEW SalaryView (系名,工资总额) AS SELECT 所在系, SUM( 工资 ) FROM 教师表 GROUP BY 所在系
C.CREATE VIEW SalaryView AS
D.CREATE VIEW SalaryView AS SELECT 所在系, SUM( 工资 ) FROM 教师表 GROUP BY 所在系
A.CREATE VIEW SalaryView (系名,工资总额) AS SELECT 所在系, COUNT( 工资 ) FROM 教师表 GROUP BY 所在系
B.CREATE VIEW SalaryView (系名,工资总额) AS SELECT 所在系, SUM( 工资 ) FROM 教师表 GROUP BY 所在系
C.CREATE VIEW SalaryView AS
D.CREATE VIEW SalaryView AS SELECT 所在系, SUM( 工资 ) FROM 教师表 GROUP BY 所在系
A.CREATE VIEW SalaryView (系名,工资总额) AS SELECT 所在系, COUNT( 工资 ) FROM 教师表 GROUP BY 所在系
B.CREATE VIEW SalaryView (系名,工资总额) AS SELECT 所在系, SUM( 工资 ) FROM 教师表 GROUP BY 所在系
C.CREATE VIEW SalaryView AS
D.CREATE VIEW SalaryView AS SELECT 所在系, SUM( 工资 ) FROM 教师表 GROUP BY 所在系
A.CREATE VIEW SalaryView (系名,工资总额) AS SELECT 所在系, COUNT( 工资 ) FROM 教师表 GROUP BY 所在系
B.CREATE VIEW SalaryView (系名,工资总额) AS SELECT 所在系, SUM( 工资 ) FROM 教师表 GROUP BY 所在系
C.CREATE VIEW SalaryView AS
D.CREATE VIEW SalaryView AS SELECT 所在系, SUM( 工资 ) FROM 教师表 GROUP BY 所在系