【单选题】有三个表,即学生表S、课程表C和学生选课表SC,它们的结构 如下:S(S#,SN,SEX,AGE,DEPT)C(C#,CN)SC(S#,C#,GRADE)其中,S#为学号,SN为姓名,SEX为性别,AGE为年龄,DEPT为系别,C#为课程 号,CN为课程名,GRADE为成绩。要检索选修 4 门以上课程的学生总成绩(不统计不及格的课程),并要求按 总成绩的降序排列出来。正确的 SELECT 语句是(...
A.
SELECT S#, SUM ( GRADE ) FROM SC WHERE GRADE>=60 GROUP BY S# ORDER BY 2 DESC HAVING COUNT( * ) >=4
B.
SELECT S#, SUM ( GRADE ) FROM SC WHERE GRADE>=60 GROUP BY S# HAVING COUNT( * ) >=4 ORDER BY 2 DESC
C.
SELECT S#, SUM ( GRADE ) FROM SC WHERE GRADE>=60 HAVING COUNT ( * ) >=4 GROUP BY S# ORDER BY 2 DESC
D.
SELECT S#, SUM ( GRADE ) FROM SC WHERE GRADE>=60 ORDER BY 2 DESC GROUP BY S# HAVING COUNT( * ) >=4
【单选题】有三个表,即学生表S、课程表C和学生选课表SC,它们的结构如下:S(S#,SN,SEX,AGE,DEPT)C(C#,CN)SC(S#,C#,GRADE)其中,S#为学号,SN为姓名,SEX为性别,AGE为年龄,DEPT为系别,C#为课程 号,CN为课程名,GRADE为成绩。检索选修 4 门以上课程的学生总成绩(不统计不及格的课程),并要求按 总成绩的降序排列出来。正确的 SELECT 语句是( ...
A.
SELECT S# , SUM ( GRADE ) FROM SC WHERE GRADE>=60 GROUP BY S# ORDER BY 2 DESC HAVING COUNT ( * ) >=4
B.
SELECT S# , SUM ( GRADE ) FROM SC WHERE GRADE>=60 GROUP BY S# HAVING COUNT ( * ) >=4 ORDER BY 2 DESC
C.
SELECT S# , SUM ( GRADE ) FROM SC WHERE GRADE>=60 HAVING COUNT ( * ) >=4 GROUP BY S# ORDER BY 2 DESC
D.
SELECT S# , SUM ( GRADE ) FROM SC WHERE GRADE>=60 ORDER BY 2 DESC GROUP BY S# HAVING COUNT( * ) >=4
【多选题】下列有关企业所得税收人确认表述正确的有( )。
A.
售后回购满足收入确认条件的,应分别作销售和购进核算
B.
以销售商品方式进行融资,收到的款项应确认为负债,回购价格大于原售价的,差额应在回购期间确认为利息费用
C.
销售商品采取预收款方式的,在收到预收款时确认收人
D.
长期为客户提供重复的劳务收取的劳务费在最终劳务活动结束后确认收入
E.
企业以买一赠一等方式组合销售本企业商品的,不属于捐赠,应将总的销售金额按各项商品的公允价值的比例来分摊确认各项的销售收入
【单选题】基于这样的三个表,即学生表 S、课程表 C 和学生选课表 SC,它们的结构 如下:S(S#,SN,SEX,AGE,DEPT)C(C#,CN)SC(S#,C#,GRADE)其中,S#为学号,SN 为姓名,SEX 为性别,AGE 为年龄,DEPT 为系别,C#为课程 号,CN 为课程名,GRADE 为成绩。检索选修 4 门以上课程的学生总成绩(不统计不及格的课程),并要求按总成绩的降序排列出来。正确的...
A.
SELECT S# , SUM ( GRADE ) FROM SC WHERE GRADE>=60 GROUP BY S# ORDER BY 2 DESC HAVING COUNT ( * ) >=4
B.
SELECT S# , SUM ( GRADE ) FROM SC WHERE GRADE>=60 GROUP BY S# HAVING COUNT ( * ) >=4 ORDER BY 2 DESC
C.
SELECT S# , SUM ( GRADE ) FROM SC WHERE GRADE>=60 HAVING COUNT ( * ) >=4 GROUP BY S# ORDER BY 2 DESC
D.
SELECT S# , SUM ( GRADE ) FROM SC WHERE GRADE>=60 ORDER BY 2 DESC GROUP BY S# HAVING COUNT ( * ) >=4
【简答题】年终决算后,“本年利润”账户与“利润分配”账户都没有期末余额。 ( )
【单选题】给家兔静脉注射去甲肾上腺素后动脉血压升高,肾小球滤过率和尿量迅速减少,该动物肾小球滤过率降低的主要原因是
【单选题】学生课程数据库有三个表,即学生表S、课程表C和学生选课表SC,它们的结构 如下:S(S#,SN,SEX,AGE,DEPT)C(C#,CN)SC(S#,C#,GRADE)其中,S#为学号,SN为姓名,SEX为性别,AGE为年龄,DEPT为系别,C#为课程 号,CN为课程名,GRADE为成绩。检索选修 4 门以上课程的学生总成绩(不统计不及格的课程),并要求按 总成绩的降序排列出来。正确的 SELEC...
A.
SELECT S#, SUM ( GRADE ) FROM SC WHERE GRADE>=60 GROUP BY S# ORDER BY 2 DESC HAVING COUNT( * ) >=4
B.
SELECT S#, SUM ( GRADE ) FROM SC WHERE GRADE>=60 GROUP BY S# HAVING COUNT( * ) >=4 ORDER BY 2 DESC
C.
SELECT S#, SUM ( GRADE ) FROM SC WHERE GRADE>=60 HAVING COUNT ( * ) >=4 GROUP BY S# ORDER BY 2 DESC
D.
SELECT S#, SUM ( GRADE ) FROM SC WHERE GRADE>=60 ORDER BY 2 DESC GROUP BY S# HAVING COUNT( * ) >=4
【多选题】下列有关企业所得税收人确认表述正确的有( )。
A.
售后回购满足收入确认条件的,应作销售和购进核算
B.
以销售商品方式进行融资,收到的款项应确认为负债,回购价格大于原售价的,差额应在回购期间确认为利息费用
C.
销售商品采取预收款方式的,在收到预收款时确认收入
D.
长期为客户提供重复的劳务收取的劳务费,在最终劳务活动结束后确认收入
【判断题】约剂类的铭文主要分为“治民之约”和“治地之约”。