【判断题】销户时,单位人民币卡账户和单位外币卡账户的资金应当转入其基本存款账户不得提取现金。( )
【简答题】执行下列程序,说出下列程序的输出结果,了解静态内部类。 class RedCowForm { static class RedCow { //静态内部类是外嵌类中的一种静态数据类型 void speak() { System.out.println("我是红牛"); } } } class BlackCowForm { public static void main(String args[]...
【单选题】有学生表S(S#,SN,SEX,AGE,DEPT),课程表C(C#,CN),学生选课表SC(S#,C#,GRADE),检索选修课程"C2"的学生中成绩最高的学生的学号,正确的SELECT语句是_________。
A.
SELECT S# FROM SC WHERE C#="C2" AND GRADE>=(SELECT GRADE FROM SC WHERE C#="C2")
B.
SELECT S# FROM SC WHERE C#="C2" AND GRADE IN(SELECT GRADE FROM SC WHERE C#="C2")
C.
SELECT S# FROM SC WHERE C#="C2" AND GRADE NOT IN(SELECT GRADE FROM SC WHERE C#="C2")
D.
SELECT S# FROM SC WHERE C#="C2" AND GRADE>=ALL
【单选题】下列哪项不是CRTSⅡ型板式无砟轨道结构组成。
【单选题】根据人民银行规定,存款单位实际支取其从基本存款账户、一般存款账户、专用存款账户转存的定期存款时,可以( )转入其原转存账户,但不得将定期存款用于结算或从定期存款账户中提取现金。
【单选题】As is known to all, _______ opening ceremony of the 16 th Asian Games held on November 12 th in Guangzhou was _______ great success.
【单选题】检索选修课程"C2”的学生中成绩最高的学生的学号,正确的SELECT语句是( )。
A.
SELECT S# FORM SC WHERE C#='C2' AND GRADE>=(SELECT GRADE FORM SC WHERE C#='C2')
B.
SELECT S# FORM SC WHERE C#='C2' AND GRADE IN(SELECT GRADE FORM S WHERE C#='C2')
C.
SELECT S# FORM SC WHERE C#='C2' AND GRADE NOT IN(SELECT GRADE FORM SC WHERE C#='C2')
D.
SELECT S# FORM SC WHERE C#='C2' AND GRADE>=ALL(SELECT GRADE FORM SC WHERE C#='C2')
【单选题】检索选修课程"C2” 的学生中成绩最高的学生的学号。正确的SELECT语句是( )
A.
SELECT S# FROM SC WHERE C#='C2' AND GRADE>=(SELECT GRADE FROM SC WHERE C#=C2)
B.
SELECT S# FROM SC WHERE C#=’C2’ AND GRADE IN (SELECT GRADE FROM SC where C#='C2’)
C.
SELECT S# FROM SC WhERE C#=’C2’ AND GRADE NOT IN (SELECT GRADE GORM SC WHERE C#='C2’)
D.
SELECT S# FROM SC Where C#='C2' AND GRADE>=ALL (SELECT GRADE FROM SC WHERE C#='C2)
【单选题】学生课程数据库有三个表,即学生表 S、课程表 C 和学生选课表 SC,它们的结构 如下:S(S#,SN,SEX,AGE,DEPT)C(C#,CN)SC(S#,C#,GRADE)其中,S#为学号,SN 为姓名,SEX 为性别,AGE 为年龄,DEPT 为系别,C#为课程 号,CN 为课程名,GRADE 为成绩。检索选修课程“C2”的学生中成绩最高的学生的学号。正确的 SELECT 语句是( ).
A.
SELECT S# FROM SC WHERE C#="C2" AND GRADE >= ( SELECT GRADE FROM SC WHERE C#="C2" )
B.
SELECT S# FROM SC WHERE C#="C2" AND GRADE IN ( SELECT GRADE FROM SC WHERE C#="C2" )
C.
SELECT S# FROM SC WHERE C#="C2" AND GRADE NOT IN ( SELECT GRADE FROM SC WHERE C#="C2" )
D.
ELECT S# FROM SC WHERE C#="C2" AND GRADE >= ALL ( SELECT GRADE FROM SC WHERE C#="C2" )