绗?/p>
1
椤?/p>
锛堝叡
4
椤碉級
銆婃暟鎹簱搴旂敤绯荤粺銆嬫湡鏈�冭瘯璇曢
涓�銆佸～绌洪
(
姣忕┖
2
鍒嗭紝鍏?/p>
30
鍒?/p>
)
1.
鏋勬垚鏁版嵁妯″瀷鐨勪笁澶ц绱犳槸
_
__
銆佹暟鎹搷浣滃拰鏁版嵁瀹屾暣鎬х害鏉熴�?/p>
2.
SQL
璇█闆?/p>
銆?/p>
鏁版嵁鎿嶇旱銆?/p>
鍜屾暟鎹帶鍒跺姛鑳戒簬涓�浣撱�?/p>
3.
select
鍛戒护涓紝
琛ㄨ揪鏉′欢琛ㄨ揪寮忕敤
where
瀛愬彞锛?/p>
鍒嗙粍鐢?/p>
GROUP
瀛愬彞锛?/p>
鎺掑簭鐢?/p>
瀛?
鍙ャ�?/p>
4.
浜嬪姟搴旇鍏锋湁鍥涗釜灞炴�?/p>
:
鍘熷瓙鎬с�?/p>
銆侀殧绂绘�у拰鎸佺画鎬?/p>
銆?/p>
5.
浜岀淮琛ㄤ箣闂寸殑琛岀О涔嬩负鍏崇郴鐨?/p>
銆?/p>
6.
鏁版嵁搴撶殑閫昏緫妯″瀷璁捐闃舵锛屼换鍔℃槸灏?/p>
_____
___
杞崲鎴愬叧绯绘ā鍨嬨�?/p>
7.
瀹炵幇琛ㄤ箣闂翠复鏃惰仈绯荤殑鍛戒护鏄?/p>
銆?/p>
8.
琛ㄥ崟鏂囦欢鐨勬墿灞曞悕鏄?/p>
銆?/p>
9.
鏁版嵁搴撶殑鐗╃悊璁捐涓昏鑰冭檻涓夋柟闈㈢殑闂锛?/p>
______
銆佸垎閰嶅瓨鍌ㄧ┖闂淬�佸疄鐜板瓨鍙栬矾寰勩�?/p>
10.
MOD(8,-3)
鐨勫�兼槸
______
銆?/p>
11.
鍒嗗竷寮忔暟鎹簱鏄竴缁勬暟鎹泦锛?/p>
閫昏緫涓婂畠浠睘浜庡悓涓�绯荤粺锛?/p>
鑰屽湪鐗╃悊涓婂垎鏁ｅ湪鐢ㄨ绠楁満缃?
缁滆繛鎺ョ殑澶氫釜鍦哄湴涓婏紝骞剁粺涓�鐢变竴涓?/p>
___________________
绠＄悊銆?/p>
12.
鍛戒护锛?/p>
ROUND
锛?/p>
12345.678,2
锛夌殑缁撴灉鏄?/p>
______
銆?/p>
13.
鏁版嵁搴撳畬鏁存�х殑闈欐�佺害鏉熸潯浠跺垎涓猴細鍊肩殑绾︽潫鍜?/p>
______
銆?/p>
14.
鏋勬垚绯荤粺璇存槑涔︾殑涓や釜閲嶈鏂囨。鏄?/p>
______
銆?/p>
15.
璁?/p>
A=鈥?鈥?/p>
锛屽垯
V
ARTYPE
锛?/p>
&A+8
锛夌殑缁撴灉鏄?/p>
銆?/p>
浜屻�佸崟閫夐
(
姣忛
1
鍒嗭紝鍏?/p>
20
鍒?/p>
)
1
锛庤鍙?/p>
delete from sc
琛ㄦ槑锛?/p>
锛?/p>
A
锛庡垹闄?/p>
sc
涓殑鍏ㄩ儴璁板綍
B
锛庡垹闄ゅ熀鏈〃
sc
C
锛庡垹闄ゅ熀鏈〃
sc
涓殑鍒楁暟鎹?/p>
D
锛庡垹闄ゅ熀鏈〃
sc
涓殑閮ㄥ垎琛?/p>
2
锛庡悜
student
琛ㄤ腑澧炲姞鈥滃叆瀛︽椂闂?/p>
(Scome)
鈥濆垪锛屽叾鏁版嵁绫诲瀷涓烘棩鏈熷瀷锛?/p>
锛?/p>
A.alter table student add scome date
B.alter table student modify scome date
C.update table student add scome date
D.update table student modify scome date
3
锛庢敹鍥炴墍鏈夌敤鎴峰鍩烘湰琛?/p>
STUDENT
鐨?/p>
UPDATE
鎿嶄綔鏉冮檺鍙敱锛?/p>
锛夎鍙ュ畬鎴愩�?/p>
A
锛?/p>
REVOKE UPDATE ON TABLE STUDENT FROM WANG
B
锛?/p>
REVOKE UPDATE ON STUDENT FROM WANG
C
锛?/p>
GRANT UPDATE ON STUDENT TO PUBLIC
D
锛?/p>
REVOKE UPDATE ON TABLE STUDENT FROM PUBLIC
4
锛?/p>
SQL
涓殑瑙嗗浘鏈哄埗灞炰簬
DBS
鐨勶紙
锛?/p>
A
锛庡畬鏁存�ф帾鏂?/p>
B
锛庡畨鍏ㄦ�ф帾鏂?/p>
C
锛庢仮澶嶆帾鏂?/p>
D
锛?/p>
骞跺彂鎬ф帾鏂?/p>
5.
涓嬪垪閭ｄ簺宸ヤ綔鏄暟鎹簱閫昏緫璁捐鐨勫唴瀹?/p>
( )
鈪狅紟璁捐
E-R
鍥?/p>
鈪★紟鍒涘缓琛?/p>
鈪紟鍒涘缓瑙嗗浘
鈪ｏ紟鍒涘缓绱㈠紩
V
锛庤杞芥暟鎹?/p>
A.
閮芥槸
B.
鈪?/p>
.
鈪″拰鈪?/p>
C.
鈪?/p>
.
鈪㈠拰鈪?/p>
D.
鈪″拰鈪?/p>
6
锛庡湪闆朵欢
-
渚涘簲鏁版嵁搴撲腑锛屾湁濡備笅涓変釜鍏崇郴锛?/p>
渚涘簲鍟嗗叧绯伙細
S
锛堜緵搴斿晢鍙凤紝渚涘簲鍟嗗悕锛屽湴鍧�锛?/p>
闆朵欢鍏崇郴锛?/p>
P
锛堥浂浠跺彿锛岄浂浠跺悕锛岄鑹诧紝閲嶉噺锛?/p>
渚涘簲鍏崇郴锛?/p>
SP
锛堜緵搴斿晢鍙凤紝闆朵欢鍙凤紝鏁伴噺锛?/p>
鑻ヨ鏌ユ壘鈥滅孩鑹查浂浠剁殑渚涘簲鍟嗗悕鈥濓紝灏嗘秹鍙婂埌鍏崇郴