CLEARREQUEST消息中,Cause的值为()时,统计为业务信道掉话
A.00H
B.02H
C.0DH
D.10H
参考答案:A, C
假设供应商S和供应情况SPJ的关系模式分别为:S(Sno,Sname,Status,City)和SPJ(Sno,Pno,Jno,Qty)。SQL语句 (22) 不能正确地查询出“零件号Pno等于‘P3’的供应商名Sname",而 (23) .能正确查询的关系代数表达式。
A.SELECT DISTINCT Sname
B.SELECT DISTmCT Sname FROMS FROMSWHERE EXISTS WHERE 0< (SELECT * (SEIECT COUNT (*) FROM SPJ FROM SPJ WHERE S.Sno=SPJ.SnO WHERE S.Sno=SPJ.Sno AND SPJ.Pno= ’P3’) AND SPJ.Pno= ’P3’)
C.SELECT Sname
D.SELECT Sname FROMS FROMS, SPJ WHERE EXISTS WHERES.Sno=SPJ.Sno (SELECT *AND SPJ.Pno= ’P3’) FROM SPJ GROUP BYSname WHERE S.Sno=SPJ.Sno AND SPJ.Pno= ’P3’)
具有生津止渴功效的药物是()
A.薄荷
B.菊花
C.天花粉
D.升麻
E.桑叶