男性，47岁，因结节性甲状腺肿拟行手术，下列哪项是手术禁忌证（)A．心房纤颤B．偶发早搏C．完全性右束

“找出北京供应商的所有信息”的SELECT语句是

A．SELECT*FROM S WHERE CITY=‘北京’

B．SELECTSNO，SNAME FROM S WHERE CITY=‘北京’

C．SELECT*FROM S WHERE CITY=北京

D．SELECT SNO，SNAME FROM S WHERE CITY=北京

“找出北京供应商的所有信息”的SELECT语句是______。

A．SELECT*FROM S WHERE CITY='北京'

B．SELECT SNO，SNAME FROM S WHERE CITY='北京'

C．SELECT*FROM S WHERE CITY=北京

D．SELECT SNO，SNAME FROM S WHERE CITY=北京

TLECT SNO,SNAME FROM S WHERE CITY=’北京’ C．SELECT P.*FROM S,P WHERE S.CITY=’北京’ AND S.SNO=SJP.SNO AND SJP.PNO=P.PNO D．SELECT P.*FROM P,S,SJP WHERE S.CITY=’北京’ AND S.SNO=SJP.SNO AND SJP.PNO=P.PNO

设有一个数据库，包括S、P、J、SJP四个关系模式如下：供应商关系模式S(SNO，SNAME, CITY)零件关系模式P(PNO, PNAME, COLOR, WEIGHT)工程项目关系模式J(JNO, JNAME, CITY)供应情况关系模式SJP(SNO, PNO, JNO, QTY)假定它们都已经有若干数据。则“找出北京供应商供应的所有零件信息”的SELECT语句是()。

A．SELECT * FROM S WHERE CITY=′北京′

B．SELECT SNO, SNAME FROM S WHERE CITY=′北京′

C．SELECT P. * FROM S, P WHERE S. CITY=′北京′ANDS. SNO=SJP. SNO AND SJP. PNO=P. PNO

D．SELECT P.* FROM P，S, SJP WHERE S. CITY=′北京′AND S. SNO=SJP. SNO AND SJP. PNO=P. PNO

实现“从学生信息表中找出性别为女的学生姓名”的SQL语句是

A．SELECT*FROMs

B．SELECT*FROM s WHERE sex＝'女'

C．SELECT sname FROM s WHERE sex＝'女'

D．SELECT*FROM s WHERE grade＝"

假设供应商S和供应情况SPJ的关系模式分别为：S(Sno, Sname, Status, City)和SPJ(Sno, Pno, Jno, Qty)。SQL语句______不能正确地查询出“零件号Pno等于'P3'的供应商名Sname”。

A．SELECT DISTINCT Sname FROM S WHERE EXISTS (SELECT* FROM SPJ WHERE S.Sno=SPJ.Sno AND SPJ.Pno='P3')

B．SELECT DISTINCT Sname FROM S WHERERE 0＜ (SELECT COUNT (*) FROM SPJ WHERE S.Sno=SPJ.Sno AND SPJ.Pno='P3')

C．SELECT Sname FROM S WHERE EXISTS (SELECT* FROM SPJ WHERE S.Sno=SPJ.Sno AND SPJ.Pno='P3')

D．SELECT Sname FROM S, SPJ WHERE S.Sno=SPJ.Sno AND SPJ.Pno='P3') GROUP BY Sname

下列SELECT语句语法正确的是()。

A．SELECT* FROM′teacher′WHERE性别=′男′

B．SELECT*FROM ′teacher′ WHERE性别=男

C．SELECT* FROM teacher WHERE性别=男

D．SELECT* FROM teacher WHERE性别=′男′

检索所有比“王华”年龄大的学生的姓名、年龄和性别，正确的SELECT语句是______。

A．SELECT SN,AGE,SEX FROM S SHERE AGE＞(SELECT AGE FROM S WHERE SN='王华')

B．SELECT SN,AGE,SEX FROM S WHERE SN='王华'

C．SELECT SN,ACE,SEX FROM S WHERE AGE＞(SELECT ACE WHERE SN='王华')

D．SELECT SN,ACE,SEX FROM S WHERE ACE＞王华 AGE

下面( )不是管理对信息和信息处理的要求。

A．准确性

B．可维护性

C．及时性

D．经济性

数据仓库是具有基本特征的支持企业决策的数据集合，以下( )不是数据仓库的特征。

A．数据与历史变化无关

B．数据是集成的

C．数据是相对稳定的

D．数据是面向主题的