鏁版嵁搴撳師鐞?/p>
-
鏈熸湯鑰冭瘯璇曢鍙婄瓟妗?/p>
涓�銆佸崟椤归�夋嫨棰?/p>
锛堟湰澶ч鍏?/p>
15
灏忛锛屾瘡灏忛
2
鍒嗭紝鍏?/p>
30
鍒?/p>
)
鍦ㄦ瘡灏忛鍒楀嚭鐨勫洓涓閫夐」涓彧鏈変竴涓槸绗﹀悎棰樼洰瑕?/p>
姹傜殑锛岄敊閫夈�?/p>
澶氶�夋垨鏈�夊潎鏃犲垎銆?/p>
1
.
瑕佷繚璇佹暟鎹簱鐨勬暟鎹嫭绔嬫�э紝闇�瑕佷慨鏀圭殑鏄紙
锛?/p>
A
锛庝笁灞傛ā寮忎箣闂寸殑涓ょ鏄犲皠
B
锛庢ā寮忎笌鍐呮ā寮?/p>
C
锛庢ā寮忎笌澶栨ā寮?/p>
D
锛庝笁灞傛ā寮?/p>
2
.
涓嬪垪鍥涢」涓娉曚笉姝ｇ‘鐨勬槸锛?/p>
锛?/p>
A
锛庢暟鎹簱鍑忓皯浜嗘暟鎹啑浣?/p>
B
锛庢暟鎹簱涓殑鏁版嵁鍙互鍏变韩
C
锛庢暟鎹簱閬垮厤浜嗕竴鍒囨暟鎹殑閲嶅
D
锛庢暟鎹簱鍏锋湁杈冮珮鐨勬暟鎹嫭绔嬫�?/p>
3
.
鍏徃涓湁澶氫釜閮ㄩ棬鍜屽鍚嶈亴鍛橈紝
姣忎釜鑱屽憳鍙兘灞炰簬涓�涓儴闂紝
涓�涓儴闂ㄥ彲浠ユ湁澶氬悕鑱屽憳锛?
浠庤亴鍛樺埌閮ㄩ棬鐨勮仈绯荤被鍨嬫槸锛?/p>
锛?/p>
A
锛庡瀵瑰
B
锛庝竴瀵逛竴
C
锛庡瀵逛竴
D
锛庝竴瀵瑰
4
锛?/p>
灏?/p>
E-R
妯″瀷杞崲鎴愬叧绯绘ā鍨嬶紝灞炰簬鏁版嵁搴撶殑锛?/p>
锛?/p>
A
锛庨渶姹傚垎鏋?/p>
B
锛庢蹇佃璁?/p>
C
锛庨�昏緫璁捐
D
锛庣墿鐞嗚璁?/p>
5
锛?/p>
浜旂鍩烘湰鍏崇郴浠ｆ暟杩愮畻鏄紙
锛?/p>
A
锛庘埅锛?/p>
鈥?/p>
锛屆楋紝蟺鍜屜?/p>
B
锛庘埅锛?/p>
鈥?/p>
锛?/p>
锛屜�鍜屜?/p>
C
锛庘埅锛屸埄锛屆楋紝蟺鍜屜?/p>
D
锛庘埅锛屸埄锛?/p>
锛屜�鍜屜?/p>
6
锛?/p>
涓嬪垪鑱氬悎鍑芥暟涓笉蹇界暐绌哄�?/p>
(NULL)
鐨勬槸锛?/p>
锛夈�?/p>
A
锛?/p>
SUM (
鍒楀悕
)
B
锛?/p>
MAX (
鍒楀悕
)
C
锛?/p>
COUNT ( * )
D
锛?/p>
A
VG (
鍒楀悕
)
7.
SQL
涓紝涓嬪垪娑夊強绌哄�肩殑鎿嶄綔锛屼笉姝ｇ‘鐨勬槸锛?/p>
锛?/p>
銆?/p>
A
.
AGE IS NULL
B
.
AGE IS NOT NULL
C
.
AGE = NULL
D
.
NOT (AGE IS NULL)
8
.
宸茬煡鎴愮哗鍏崇郴濡傝〃
1
鎵�绀恒�?/p>
鎵ц
SQL
璇彞锛?/p>
SELECT COUNT
锛?/p>
DISTINCT
瀛﹀彿锛?/p>
FROM
鎴愮哗
WHERE
鍒嗘暟锛?/p>
60
鏌?/p>
璇㈢粨鏋滀腑鍖呭惈鐨勫厓缁勬暟鐩槸锛?/p>
锛?/p>
琛?/p>
1
鎴愮哗鍏崇郴
瀛﹀彿
璇剧▼鍙?/p>
鍒嗘暟
S1
C1
80
S1
C2
75
寰?/p>
鍒?/p>