銆?/p>
鏁版嵁搴撳師鐞?/p>
銆?/p>
瀛︿綅鑰冭瘯璇曢
涓�銆佸崟椤归�夋嫨棰?/p>
锛堟湰澶ч鍏?/p>
10
灏忛锛屾瘡灏忛
2
鍒嗭紝鍏?/p>
20
鍒?/p>
)
鍦ㄦ瘡灏忛鍒楀嚭鐨勫洓涓閫夐」涓彧鏈変竴涓槸绗﹀悎棰樼洰瑕?/p>
姹傜殑锛岄敊閫夈�佸閫夋垨鏈�夊潎鏃犲垎銆?/p>
1
.
鍦ㄦ暟鎹簱涓夌骇妯″紡闂村紩鍏ヤ簩绾ф槧璞＄殑涓昏浣滅敤鏄紙
A
锛?/p>
A
锛庢彁楂樻暟鎹笌绋嬪簭鐨勭嫭绔嬫�?/p>
B
锛庢彁楂樻暟鎹笌绋嬪簭鐨勫畨鍏ㄦ�?/p>
C
锛庝繚鎸佹暟鎹笌绋嬪簭鐨勪竴鑷存�?/p>
D
锛庢彁楂樻暟鎹笌绋嬪簭鐨勫彲绉绘鎬?/p>
2
锛?/p>
濡備綍鏋勯�犲嚭涓�涓悎閫傜殑鏁版嵁閫昏緫缁撴瀯鏄紙
C
锛変富瑕佽В鍐崇殑闂銆?/p>
A
锛庡叧绯荤郴缁熸煡璇紭鍖?/p>
B
锛庢暟鎹瓧鍏?/p>
C
锛庡叧绯绘暟鎹簱瑙勮寖鍖栫悊璁?/p>
D
锛庡叧绯绘暟鎹簱鏌ヨ
3
锛庡鏋滀簨鍔?/p>
T
宸插湪鏁版嵁
R
涓婂姞浜?/p>
X
閿侊紝鍒欏叾浠栦簨鍔″湪鏁版嵁
R
涓婏紙
D
锛?/p>
A
.
鍙彲鍔?/p>
X
閿?/p>
B
.
鍙彲鍔?/p>
S
閿?/p>
C
.
鍙姞
S
閿佹垨
X
閿?/p>
D
.
涓嶈兘鍔犱换浣曢攣
4
锛庡叧绯昏鑼冨寲涓殑鍒犻櫎寮傚父鏄寚
( D
)
A
锛庝笉璇ュ垹闄ょ殑鏁版嵁琚垹闄?/p>
B
锛庝笉璇ユ彃鍏ョ殑鏁版嵁琚彃鍏?/p>
C
锛庡簲璇ュ垹闄ょ殑鏁版嵁鏈鍒犻櫎
D
锛庡簲璇ユ彃鍏ョ殑鏁版嵁鏈鎻掑叆
5
锛?/p>
鏈変竴鍚嶄负鈥滃垪杞﹁繍钀モ�濆疄浣擄紝鍚湁锛氳溅娆°�佹棩鏈熴�佸疄闄呭彂杞︽椂闂淬�佸疄闄呮姷杈炬椂闂淬�佹儏鍐垫憳瑕佺瓑灞炴�э紝
璇ュ疄浣撲富鐮佹槸锛?/p>
C
锛?/p>
A
锛庤溅娆?/p>
B
锛庢棩鏈?/p>
C
锛庤溅娆?/p>
+
鏃ユ湡
D
锛庤溅娆?/p>
+
鎯呭喌鎽樿
6.
瀵规暟鎹簱鐗╃悊瀛樺偍鏂瑰紡鐨勬弿杩扮О涓猴紙
B
锛?/p>
A
锛庡妯″紡
B
锛庡唴妯″紡
C
锛庢蹇垫ā寮?/p>
D
锛庨�昏緫妯″紡
7.
鍏崇郴
R
涓庡叧绯?/p>
S
鍙湁
1
涓叕鍏卞睘鎬э紝
T1
鏄?/p>
R
涓?/p>
S
浣溛歌繛鎺ョ殑缁撴灉锛?/p>
T2
鏄?/p>
R
涓?/p>
S
浣滆嚜鐒惰繛鎺ョ殑缁撴灉锛?/p>
鍒欙紙
D
锛?/p>
銆?/p>
A. T1
鐨勫睘鎬т釜鏁扮瓑浜?/p>
T2
鐨勫睘鎬т釜鏁?/p>
B. T1
鐨勫睘鎬т釜鏁板皬浜?/p>
T2
鐨勫睘鎬т釜鏁?/p>
C. T1
鐨勫睘鎬т釜鏁板ぇ浜庢垨绛変簬
T2
鐨勫睘鎬т釜鏁?/p>
D. T1
鐨勫睘鎬т釜鏁板ぇ浜?/p>
T2
鐨勫睘鎬т釜鏁?/p>
8.
涓�涓叧绯绘ā寮?/p>
R(x1, x2, x3, x4)
锛屽亣瀹氳鍏崇郴瀛樺湪鐫�濡備笅鍑芥暟渚濊禆锛?/p>
x1
鈫?/p>
x2
锛?/p>
x1
鈫?/p>
x3
锛?/p>
x3
鈫?/p>
x4
锛屽垯璇ュ叧绯诲睘浜庯紙
A
锛?/p>
銆?/p>
A. 2NF
B. 3NF
C. 4NF
D. BCNF
9
.
鎶婂鍏崇郴
SPJ
鐨勫睘鎬?/p>
QTY
鐨勪慨鏀规潈鎺堜簣鐢ㄦ埛鏉庡媷鐨?/p>
T-SQL
璇彞鏄紙
C
锛?/p>
A
.
GRANT QTY ON SPJ TO '
鏉庡媷
'
B
.
GRANT UPDATE(QTY) ON SPJ TO '
鏉庡媷
'
C
.
GRANT UPDATE (QTY) ON SPJ TO
鏉庡媷
D
.
GRANT UPDATE ON SPJ (QTY) TO
鏉庡媷