当前位置:问答库>考研试题

2016年四川师范大学地理与资源科学学院数据库技术(同等学力加试)复试笔试仿真模拟题

  摘要

2016

. ............................................................................................................................................... 2 2016

. ............................................................................................................................................... 9 2016

. ............................................................................................................................................. 17 2016

. ............................................................................................................................................. 25 2016

. ............................................................................................................................................. 33

2016

VIP

------------------------------------------------------------------------------------

1

A.

B.

C.

D.

C

DBMS

2 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

3 DBMS

A.DDL DML

B.

C.

D.

D

DML DBMS DDL

/

DataDictionary DD

4

A.

B.

C.

D.

B

5

A.

B.

C.

D. --

A

,

6 SQLServer2000

A.

B. --

C.

D.

A

SQLServer

7

A.DFD IDEFIX

B.E-R IDEFO

C.E-R IDEF1X

D.DFD IDEFO

C

E-R IDEFIX

8

A.

B.

C.

D.

B

9

A.

B.

C. CPU I/O

D.

A

DBMS A