题目内容

S（S＃，SNAME，SEX），C（C＃，CNAME），SC（S＃，C＃，GRADE）. The SQL statement to query the names of all male students taking the database course is: SELECT SNAME FROM S，C，SC WHERE ( )

A. S.S
B. = SC.S
C. and C.C
D. = SC.C
E. and SEX=’M’ and CNAME=’DATABASE’
F. S.S
G. = SC.S
H. and C.C
I. = SC.C
J. and SEX in’M’and CNAME in’DATABASE’
K. SEX ’M’ and CNAME ’ DATABASE’
L. S.SEX=’M’ and CNAME=’ DATABASE’

查看答案

搜索结果不匹配？点我反馈

更多问题

S(S#，SNAME，SEX，AGE)，C(C#，CNAME，TEACHER)，SC(S#，C#，GRADE)。To find the name of all "female" students taking a "COMPUTER" course involves

A. S
B. SC，C
C. S，SC
D. S，C，SC

查看答案

In the SQL language, the command to delete all the data in a table but keep the table structure is ()

A. DELETE
B. DROP
CLEAR
D. REMORE

查看答案

A function used to find the date of a system is ( )

A. YEAR()
B. GETDATE()
COUNT()
D. SUM()

查看答案

which one is wrong( )。

A. select right('hello',3)return value=hel
B. select ltrim(rtrim(' hello '))return value=hello (without spaces)
C. select replace('hello','e','o') return value=hollo
D. select len('hello') return value=5

查看答案

S（S＃，SNAME，SEX），C（C＃，CNAME），SC（S＃，C＃，GRADE）. The SQL statement to query the names of all male students taking the database course is: SELECT SNAME FROM S，C，SC WHERE ( )

A. S.S B. = SC.S C. and C.C D. = SC.C E. and SEX=’M’ and CNAME=’DATABASE’ F. S.S G. = SC.S H. and C.C I. = SC.C J. and SEX in’M’and CNAME in’DATABASE’ K. SEX ’M’ and CNAME ’ DATABASE’ L. S.SEX=’M’ and CNAME=’ DATABASE’

S(S#，SNAME，SEX，AGE)，C(C#，CNAME，TEACHER)，SC(S#，C#，GRADE)。To find the name of all "female" students taking a "COMPUTER" course involves

In the SQL language, the command to delete all the data in a table but keep the table structure is ()

A function used to find the date of a system is ( )

which one is wrong( )。

A. S.S
B. = SC.S
C. and C.C
D. = SC.C
E. and SEX=’M’ and CNAME=’DATABASE’
F. S.S
G. = SC.S
H. and C.C
I. = SC.C
J. and SEX in’M’and CNAME in’DATABASE’
K. SEX ’M’ and CNAME ’ DATABASE’
L. S.SEX=’M’ and CNAME=’ DATABASE’