题目内容

In the SQL language, which of the following operations involving null values are incorrect

AGE IS NULL
B. AGE IS NOT NULL
C. AGE=NULL
D. NOT(AGE IS NULL)

查看答案

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

更多问题

DEPT(DNO,DNAME), if you want to find a DNAME whose third letter from the end is W and contains at least four letters, the query condition should be written as WHERE DNAME LIKE

A. '_ _W _%'
B. '_ W _ %'
C. '_ W _ _'
D. ' _ %W _ _'

查看答案

SELECTstatement includes( ) at least

A. SELECT
B. SELECT，FROM
C. SELECT，GROUP
D. SELECT，INTO

查看答案

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, which of the following operations involving null values are incorrect

AGE IS NULL B. AGE IS NOT NULL C. AGE=NULL D. NOT(AGE IS NULL)

DEPT(DNO,DNAME), if you want to find a DNAME whose third letter from the end is W and contains at least four letters, the query condition should be written as WHERE DNAME LIKE

SELECTstatement includes( ) at least

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 ( )

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

AGE IS NULL
B. AGE IS NOT NULL
C. AGE=NULL
D. NOT(AGE IS NULL)