銆?/p>
-
鍙紪杈戜慨鏀?/p>
-
XXXX
鎰熻阿鎮ㄥ鏈璇曢鐨勫洖绛旓紝棣栧厛璇锋偍濉啓涓婃偍鐨勫鍚?/p>
(____________),
鏈璇曢灏嗕綔涓?/p>
XXXX
鍏ヨ亴鐨勫弬鑰冿紝
澶氳阿鎮ㄧ殑閲?/p>
瑙嗐�傛湰濂楄瘯棰樺垎涓夐儴鍒嗭細濉┖棰橈紙
10
鍒嗭級
銆侀�夋嫨棰橈紙
20
鍒嗭級
锛?/p>
SQL
鍩虹棰橈紙
30
锛?/p>
銆佺畝绛旈锛?/p>
20
锛?/p>
銆佺患鍚堥锛?/p>
30
锛?/p>
銆傛椂闂?/p>
60
鍒嗛挓锛屾弧鍒?/p>
110
鍒嗐�?/p>
涓�銆佸～绌洪
(
姣忛
2
鍒嗭紝鍏?/p>
10
鍒?/p>
)
1.
绱㈠紩瀛楁鍊间笉鍞竴锛屽簲璇ヤ娇鐢ㄧ殑绱㈠紩绫诲瀷涓?/p>
(
鏅�氱储寮?/p>
)
2.
鍙湁婊¤冻鑱旀帴鏉′欢鐨勮褰曟墠鍖呭惈鍦ㄦ煡璇㈢粨鏋滀腑锛岃繖绉嶈仈鎺ヤ负
(
鍐呰仈鎺?/p>
)
3. E-R
妯″瀷鐨勭粍鎴愬寘鎷偅浜涘厓绱?/p>
(
瀹炰綋
)(
灞炴�?/p>
)(
鍏崇郴
)
4.
浜嬪姟鎵�鍏锋湁鐨勭壒鎬ф湁
(
鍘熷瓙鎬?/p>
)(
涓�鑷存�?/p>
)(
闅旂鎬?/p>
)(
鎸佷箙鎬?/p>
)
5
銆佺粨鏋勫寲绋嬪簭璁捐鐨勪笁绉嶅熀鏈�昏緫缁撴瀯鏄?/p>
锛?/p>
椤哄簭缁撴瀯
)
锛?/p>
锛堥�夋嫨缁撴瀯锛?/p>
锛?/p>
锛堝惊鐜粨鏋勶級
銆?/p>
浜屻�侀�夋嫨鎻?/p>
(
姣忛
1
鍒嗭紝鍏?/p>
20
鍒?/p>
)
1
銆佸湪鍒犻櫎鏁磋〃鏁版嵁锛屽悓鏃朵繚鐣欒〃缁撴瀯鏃讹紝閲囩敤锛?/p>
C
锛夌殑鏁堢巼姣旓紙
A
锛夎楂橈紱
A. delete
B. drop table
C
. truncate
Table
2
銆?/p>
鏁版嵁搴撶鐞嗙郴缁熶腑锛?/p>
鑳藉疄鐜板鏁版嵁搴撲腑鐨勬暟鎹繘琛屾彃鍏?/p>
/
淇敼
/
鍒犻櫎鐨勫姛鑳界О涓?/p>
锛?/p>
C
锛?/p>
;
A.
鏁版嵁瀹氫箟鍔熻兘
B.
鏁版嵁绠＄悊鍔熻兘
C.
鏁版嵁鎿嶄綔鍔熻兘
D.
鏁版嵁鎺у埗鍔熻兘
3
銆?/p>
24
銆佸湪鍏崇郴妯″瀷涓紝瀹炵幇
"
鍏崇郴涓笉鍏佽鍑虹幇鐩稿悓鐨勫厓缁?/p>
"
鐨勭害鏉熸槸閫氳繃
(B)
銆?/p>
A
锛氬�欓�夐敭
B
锛氫富閿?/p>
C
锛氬閿?/p>
D
锛氳秴閿?/p>
4
銆佹暟鎹簱绠＄悊绯荤粺
DBMS S
鏄?/p>
锛?/p>
D
锛?/p>
;
A.
淇℃伅绠＄悊鐨勫簲鐢ㄨ蒋浠?/p>
B.
鏁版嵁搴撶郴缁?/p>
+
搴旂敤绋嬪簭
C.
绠＄悊涓殑鏁版嵁搴?/p>
D.
绠＄悊鏁版嵁鐨勮蒋浠?/p>
5
銆佸叧绯绘暟鎹簱涓紝瀹炵幇琛ㄤ笌琛ㄤ箣闂寸殑鑱旂郴鏄�氳繃
锛?/p>
B
锛?/p>
銆?/p>
A
銆佸疄浣撳畬鏁存�ц
B
銆佸弬鐓у畬鏁存�ц鍒?/p>
C
銆佺敤鎴疯嚜瀹氫箟鐨勫畬鏁存�?/p>
D
銆佸�煎煙
6
銆佽鏈夐儴闂ㄥ拰鑱屽憳涓や釜瀹炰綋锛屾瘡涓亴鍛樺彧鑳藉睘浜庝竴涓儴闂紝涓�涓儴闂ㄥ彲浠ユ湁澶氬悕鑱屽憳锛?/p>
鍒欓儴闂ㄤ笌鑱屽憳瀹炰綋涔嬮棿鐨勮仈绯荤被鍨?/p>
(B)
銆?/p>
A
銆?/p>
m
锛?/p>
n
B
銆?/p>
1
锛?/p>
m
C
銆?/p>
m
锛?/p>
1
D
銆?/p>
1
锛?/p>
1
7
銆佽鏈夎绋嬪拰瀛︾敓涓や釜瀹炰綋锛屾瘡涓鐢熷彲浠ラ�変慨澶氫釜璇剧▼锛屼竴涓绋嬪彲浠ユ湁澶氬悕瀛︾敓
閫変慨锛屽垯璇剧▼涓庡鐢熷疄浣撲箣闂寸殑鑱旂郴绫诲瀷
( A )
銆?/p>
A
銆?/p>
m
锛?/p>
n
B
銆?/p>
1
锛?/p>
m
C
銆?/p>
m
锛?/p>
1
D
銆?/p>
1
锛?/p>
1
8
銆佸鏋滀竴涓彮鍙兘鏈変竴涓彮闀匡紝鑰屼笖涓�涓彮闀夸笉鑳藉悓鏃舵媴浠诲叾瀹冪彮鐨勭彮闀匡紝鐝骇鍜岀彮
闀夸袱涓疄浣撲箣闂寸殑鍏崇郴灞炰簬锛?/p>
D
锛?/p>
銆?/p>
A
銆?/p>
m
锛?/p>
n
B
銆?/p>
1
锛?/p>
m
C
銆?/p>
m
锛?/p>
1
D
銆?/p>
1
锛?/p>
1
9
銆佺储寮曞瓧娈靛�间笉鍞竴锛屽簲璇ラ�夋嫨鐨勭储寮曠被鍨嬩负
(
B
)
銆?/p>
A
锛氫富绱㈠紩
B
锛氭櫘閫氱储寮?/p>
C
锛氬�欓�夌储寮?/p>
D
锛氬敮涓�绱㈠紩
10
銆佸鏋滄寚瀹氬弬鐓у畬鏁存�х殑鍒犻櫎瑙勫垯涓?/p>
"
绾ц仈
"
锛屽垯褰撳垹闄ょ埗琛ㄤ腑鐨勮褰曟椂
( C )
銆?/p>
A
锛氱郴缁熻嚜鍔ㄥ浠界埗琛ㄤ腑琚垹闄よ褰曞埌涓�涓柊琛ㄤ腑
B
锛氳嫢瀛愯〃涓湁鐩稿叧璁板綍锛屽垯绂佹鍒犻櫎鐖惰〃涓褰?/p>