濡傚鎮ㄦ湁甯姪锛屾杩庝笅杞芥敮鎸侊紝璋㈣阿锛?/p>
1
鑷祴棰?/p>
涓�銆佹槸闈為
1
锛庢暟鎹簱鏄寚鎸変竴瀹氱殑鏁版嵁妯″瀷缁勭粐锛岄暱鏈熷瓨鏀惧湪鍐呭瓨涓婄殑涓�缁勫彲鍏变韩鐨勭浉鍏虫暟鎹泦鍚堛�?/p>
2
锛庢蹇垫ā鍨嬩腑鐨勮仈绯诲彲鍒嗕负涓ょ锛氫竴绉嶆槸瀹炰綋闆嗗唴閮ㄧ殑鑱旂郴锛屽畠鍙嶆槧瀹炰綋闆嗗唴閮ㄤ笉鍚屽睘鎬?/p>
涔嬮棿鐨勮仈绯伙紱鑰屽彟涓�绉嶆槸澶氫釜瀹炰綋闆嗕箣闂寸殑鑱旂郴銆?/p>
3
锛庢暟鎹ā寮忔槸鐢ㄤ竴缁勬蹇靛拰瀹氫箟鎻忚堪鏁版嵁鐨勬墜娈碉紝鑰屾暟鎹ā鍨嬫槸鐢ㄦ煇绉嶆暟鎹ā寮忓鍏蜂綋鎯?/p>
鍐典笅鐩稿叧鏁版嵁鐨勬弿杩般�?/p>
4
锛庢暟鎹簱閫昏緫璁捐鐨勪换鍔℃槸灏嗘蹇电粨鏋勮璁￠樁娈垫墍寰楀埌鐨勫叏灞�
E-R
鍥句腑鐨勫疄浣撻泦鍜岃仈绯伙紝
杞崲涓哄叧绯?/p>
DBMS
鎵�鏀寔鐨勫叧绯诲瀷鏁版嵁鐨勯�昏緫缁撴瀯銆?/p>
浜屻�侀�夋嫨棰?/p>
1
锛庝笅闈㈠叧浜庢暟鎹簱绯荤粺
(DBS)
涓庢枃浠剁郴缁熺殑鏈川鍖哄埆鐨勫彊杩颁腑锛屾纭殑鏄?/p>
(A)DBS
鍦ㄨ鏄庢暟鎹粨鏋勬椂瑕佹弿杩版暟鎹湰韬拰鏁版嵁涔嬮棿鐨勮仈绯伙紝鏂囦欢绯荤粺涓嶈姹?/p>
(B)DBS
鍙互绠＄悊搴炲ぇ鐨勬暟鎹噺锛屾枃浠剁郴缁熺鐞嗙殑鏁版嵁閲忚緝灏?/p>
(C)DBS
鑳藉绠＄悊鍚勭绫诲瀷鐨勬枃浠讹紝鏂囦欢绯荤粺鍙兘绠＄悊绋嬪簭鏂囦欢
(D)DBS
鐨勬暟鎹叡浜�ф瘮鏂囦欢绯荤粺鏇村己
2
锛庡湪鍏崇郴妯″紡涓紝瀵瑰簲鍏崇郴鐨勪富閿槸鎸?/p>
(A)
绗竴涓睘鎬ф垨灞炴�х粍
(B)
鑳芥儫涓�纭畾鍏冪粍鐨勪竴缁勫睘鎬?/p>
(C)
涓嶈兘涓虹┖鍊肩殑涓�缁勫睘鎬?/p>
(D)
涓嶈兘涓哄閿殑涓�缁勫睘鎬?/p>
3
锛庢暟鎹簱绯荤粺涓紝鏁版嵁鐨勯�昏緫鐙珛鎬ф槸鎸?/p>
(A)
搴旂敤绋嬪簭鐙珛浜庣郴缁熼�昏緫妯″紡
(B)
绯荤粺閫昏緫妯″紡鐙珛浜庢暟鎹瓨鍌ㄦā寮?/p>
(C)
绯荤粺鐢ㄤ骇妯″紡鐙珛浜庢暟鎹瓨鍌ㄦā寮?/p>
(D)
搴旂敤绋嬪簭鐙珛浜庣郴缁熺敤鎴锋ā寮?/p>
4
锛庝笅闈㈠叧浜庝竴涓叧绯讳腑浠绘剰涓や釜鍏冪粍鍊肩殑鍙欒堪涓紝姝ｇ‘鐨勬槸
(A)
鍙互鍏ㄥ悓
(B)
蹇呴』鍏ㄥ悓
(C)
涓嶅厑璁稿叏鍚?/p>
(D)
鍙互涓婚敭鐩稿悓锛屽叾浠栧睘鎬т笉鍚?/p>
5
锛庡叧绯讳唬鏁扮殑鍩烘湰鎿嶄綔缁勬垚鍏崇郴浠ｆ暟鐨勫畬澶囨搷浣滈泦锛屽叾浠栨搷浣滃潎鍙互鐢卞熀鏈搷浣滄潵琛ㄨ揪銆?/p>
鍏蜂綋鑰岃█锛屽叧绯讳唬鏁扮殑鍩烘湰鎿嶄綔鏈?/p>
( )
(A)
骞躲�佸樊銆佸箍涔夌瑳鍗″皵绉�佽繛鎺ュ拰閫夋嫨
(B)
骞躲�佸樊銆佷氦銆佽繛鎺ュ拰閫夋嫨
(C)
骞躲�佸樊銆佸箍涔夌瑳鍗″皵绉�佹姇褰卞拰閫夋嫨
(D)
骞躲�佸樊銆佷氦銆侀櫎鍜屽箍涔夌瑳鍗″皵绉?/p>
7
锛?/p>
SQL
鏌ヨ璇彞褰㈠紡涓?/p>
'select
A
from
R
where
F'
锛屽叾涓紝
A
銆?/p>
R
銆?/p>
F
鍒嗗埆瀵瑰簲浜?/p>
(A)
鍒楀悕鎴栧垪琛ㄨ揪寮忋�佸熀鏈〃鎴栬鍥俱�佹潯浠惰〃杈惧紡
(B)
鍒楀悕鎴栧垪琛ㄨ揪寮忋�佸瓨鍌ㄦ枃浠躲�佹潯浠惰〃杈惧紡
(C)
瑙嗗浘灞炴�с�佸熀鏈〃銆佹潯浠惰〃杈惧紡
(D)
鍒楀悕鎴栨潯浠惰〃杈惧紡銆佸熀鏈〃銆佸叧绯讳唬鏁拌〃杈?/p>
8
锛庡弬鐓ф湰涔?/p>
6
锛?/p>
2
锛?/p>
3
鑺傛湁鍏冲鐢熺櫥璁拌〃
(S)
銆佽绋嬪紑璁捐〃
(C)
鍜屽鐢熼�夎鎴愮哗琛?/p>
(SC)
鐨勬ā寮忓畾
涔夈�佷富閿拰澶栭敭鐨勮鏄庯紝浠ヤ笅
SQL
鎿嶄綔涓殑鍝竴涓槸涓嶈兘鎵ц鐨?/p>
? ( )
(A)
浠?/p>
SC
琛ㄤ腑鍒犻櫎鎴愮哗灏忎簬
60
鐨勮
(B)
灏嗚〃
S
涓鍙蜂负
'A041'
鐨勫鐢熻韩楂樻洿鏀逛负
1
锛?/p>
75
(C)
灏嗚
('A012'
锛?/p>
"MS-2ll'
锛?/p>
85)
鎻掑叆鍒拌〃
SC
涓?/p>