鏁版嵁搴撳師鐞嗕笌搴旂敤鏁欑▼
鈥昐QL Server
鏈熸湯娴嬭瘯棰樹笌绛旀锛堜簩锛?/p>
涓�銆佸～绌洪
锛堟瘡绌?/p>
1
鍒嗭紝鍏?/p>
10
鍒嗭級
1
锛庡湪淇℃伅涓栫晫涓兘鍞竴鏍囪瘑瀹炰綋鐨勫睘鎬ч泦锛岀О涓?/p>
________
銆?/p>
2
锛庡鏋滃叧绯绘ā寮?/p>
R
鏄?/p>
1NF
锛屼笖姣忎釜闈炰富灞炴�?/p>
________
鍑芥暟渚濊禆浜庝富閿紝閭ｄ箞绉?/p>
R
鏄浜岃寖寮忕殑妯?/p>
寮忋�?/p>
3
锛庢暟鎹鑼冨寲鐨勪紭鐐逛箣涓�鏄兘娑堥櫎
_____
___
鍜屾搷浣滃紓甯哥幇璞°�?/p>
4
锛庤嫢鍏崇郴
A
鏈?/p>
m
涓睘鎬э紝鍏崇郴
B
鏈?/p>
n
涓睘鎬э紝鍒?/p>
A脳
B
鏈?/p>
________
涓睘鎬с�?/p>
5
锛庡叧绯讳唬鏁拌繍绠椾腑锛屼笓闂ㄧ殑鍏崇郴鎿嶄綔鏈夛細閫夋嫨銆佹姇褰便�侀櫎鍜?/p>
________
銆?/p>
6
锛庡叧绯讳腑灞炴�х殑鍙栧�艰寖鍥寸О涓哄睘鎬х殑
___________
銆?/p>
7
锛庡湪
SQL Server2005
涓紝閫氶厤绗﹀彧鏈夊湪
_________
瀛愬彞涓墠鏈夋剰涔夛紝鍚﹀垯浼氳褰撲綔鏅�氬瓧绗︿娇鐢ㄣ�?/p>
8
锛庤Е鍙戝櫒涔熸槸涓�绉嶅瓨鍌ㄨ繃绋嬶紝瀹冧富瑕侀�氳繃浜嬩欢杩涜瑙﹀彂鑰岃鎵ц锛岃�屽瓨鍌ㄨ繃绋嬪彲浠ラ�氳繃
鑰岃鐩存帴璋冪敤銆?/p>
9
锛庝竴鑸彲浠ヤ娇鐢?/p>
________
鍛戒护鏉ユ爣璇?/p>
T-SQL
鎵瑰鐞嗙殑缁撴潫銆?/p>
10
锛庡湪绱㈠紩鍛戒护涓娇鐢ㄥ叧閿瓧
CLUSTERED
琛ㄧず灏嗗缓绔嬬殑鏄?/p>
____________
绱㈠紩銆?/p>
浜屻�侀�夋嫨棰?/p>
锛堟瘡灏忛
1
鍒嗭紝鍏?/p>
20
鍒嗭級
1
锛庢暟鎹簱鐨勬蹇垫ā鍨嬶紙
锛?/p>
(A)
渚濊禆浜庤绠楁満纭欢鍜?/p>
DBMS
(B)
鐙珛浜庤绠楁満纭欢锛屼緷璧栦簬
DBMS
(C)
渚濊禆浜庤绠楁満纭欢锛岀嫭绔嬩簬
DBMS
(D)
鐙珛浜庤绠楁満纭欢鍜?/p>
DBMS
2
锛庡亣璁炬煇涓?/p>
E-R
鍥句腑鏈?/p>
5
涓疄浣撳瀷銆?/p>
2
涓?/p>
1
鈭?/p>
M
鑱旂郴鍜?/p>
2
涓?/p>
M
鈭?/p>
N
鑱旂郴锛屽垯璇?/p>
E-R
鍥捐浆鎹㈢殑鍏崇郴
妯″紡涓暟鑷冲皯鏄紙
锛?/p>
(A)5
(B)7
(C)8
(D)9
3
锛庣敤浜岀淮琛ㄦ潵琛ㄧず瀹炰綋鍙婂疄浣撲箣闂磋仈绯荤殑鏁版嵁妯″瀷绉颁负锛?/p>
锛?/p>
(A)
瀹炰綋
-
鑱旂郴妯″瀷
(B)
灞傛妯″瀷
(C)
缃戠姸妯″瀷
(D)
鍏崇郴妯″瀷
4
锛庡湪瀛︾敓鍏崇郴锛氬鐢燂紙瀛﹀彿锛屽鍚嶏紝骞撮緞锛屾�у埆锛変腑锛屾兂鏌ヨ骞撮緞灏忎簬
20
鐨勫鐢熺殑瀛﹀彿鍜屽鍚嶏紝
鍒欏叧绯昏繍绠楀紡搴斿啓鎴愶紙
锛?/p>
(A)
)
(
20
瀛︾敓
骞撮緞
飥?/p>
飦?/p>
(B)
锛?/p>
瀛︾敓
锛?/p>
骞撮緞
瀛﹀彿锛屽鍚?/p>
)
(
20
飥?/p>
飪?/p>
飦?/p>
(C)
锛?/p>
锛堝鐢?/p>
瀛﹀彿锛屽鍚?/p>
骞撮緞
)
(
20
飪?/p>
飥?/p>
飦?/p>
(D)
))
(
(
20
瀛﹀彿锛屽鍚?/p>
瀛︾敓
骞撮緞
飥?/p>
飦?/p>
5
锛庡湪涓�涓叧绯讳腑锛屾瘡涓睘鎬ч兘鏄笉鍙垎瑙ｇ殑锛岃繖涓叧绯讳竴瀹氳揪鍒帮紙
锛?/p>
(A) 2NF
(B)3NF
(C)BCNF
(D)1NF
6
锛庡鐢熻〃涓?/p>
st(
瀛﹀彿锛屽鍚嶏紝鎬у埆锛屽勾榫?/p>
)
锛屽垹闄ゅ叾涓殑
鈥?/p>
骞撮緞
鈥?/p>
瀛楁鐨?/p>
SQL
璇彞鏄紙
锛?/p>
(A)ALTER TABLE st DROP
骞撮緞