2017年大连海洋大学农业推广(专业学位)341农业知识综合三之数据库系统概论考研仿真模拟题
● 摘要
2017341
.............................................................................................................................. 2 2017341
............................................................................................................................ 12 2017341
............................................................................................................................ 21 2017341
............................................................................................................................ 29 2017341
............................................................................................................................ 40
2017341
VIP 2017
------------------------------------------------------------------------------------
1 E-R E-R
A.
B.
C.
D.
B
E-R E-R
2 OLTP
A.
B.
C. ODS
D. OLTP
C
3 SQLServer2000"""" 0.61.5
A.CHECK B.CHECK
C.CREATETRIGGERtri_____SalesONFORINSERT UPDATE
AS IFEXISTS
ONa. =b.
WHERE
ROLLBACK
D.CREATETRIGGERtri_____SalesONINSTEADOFINSERT UPDATE
AS
IFEXISTS SELECT*FROMINSERTEDaJOINb
ONa. =b.
WHERE
ROLLBACK
D
FOR SQL INSTEADOF SQL
4 SQLServer2000"" 400, "" 300"" 200
A.UPDA TE SET =+CASE
END
B.UPDA TE SET =+CASE
END
C.UPDA TE SET =CASE
END
D.UPDA TE SET =+CASE
END
A
" UPDATE SET "
5
A.
B.
C.Web
D.
C
6 R A B C IS B , C D A. B. C. D.
B
A D A D R S B
7
A.
B.
C.
D.
C