2021年上半年(上午)《数据库系统工程师》真题试卷下载
试题预览
1
单选题
1分
- A.SELECT * FROM employee, insurance WHERE insuranc
- B.id = employe
- C.id AND insuranc
- D.isValid=1
- E.SELECT * FROM employee, insurance WHERE insuranc
- F.isvalid= 1 AND employe
- G.islocal=0
- .SELECT * FROM employee, insurance WHERE insuranc
- .id = employe
- .id AND insuranc
- .isvalid= 1 AND employe
- .islocal=0
- .SELECT * FROM employee, insurance WHERE insuranc
- .id = employe
- .id AND insuranc
- .isvalid= 1 AND employe
- .islocal=1
2
单选题
1分
关系模式R(U,F)中,属性集U={A,B,C,D,E},函数依赖集F=(A→BC,C→D,BD→A,AD→E,BD→E}。则(CE)F+=( )。
3
单选题
1分
- A.GRANT SELECT ON department TO userA
- B.REVOKE SELECT ON department FROM userA
- C.GRANT SELECT ON department FROM userA WITH GRANT OPTION
- D.REVOKE SELECT ON department TO userA
4
单选题
1分
- A.SELECT film,sum(attendanc
- B.FROM movie WHERE pdate='20210221' HAVING sumattendanc
- C.> 100
- D.SELECT film,sum(attendanc
- E.FROM movie WHERE pdate=‘20210221’ AND attendance >100 GROUP BY film
- F.SELECT filmum(attenedanc
- G.FROM movie WHERE pdate=‘20210221’ GROUP BY film HAVING sum(attendanc
- .> 100
- .SELECT film,sum(attendanc
- .FROM movie WHERE pdate=*20210221 AND sum(attendanc
- .>100 GROUP BY film