绗?/p>
4
銆?/p>
5
绔犵粌涔犻锛堟暟鎹簱鐨勫畨鍏ㄦ�с�佸畬鏁存�э級
涓�銆侀�夋嫨棰?/p>
1
锛庝笅闈㈠摢涓笉鏄暟鎹簱绯荤粺蹇呴』鎻愪緵鐨勬暟鎹帶鍒跺姛鑳?/p>
銆?/p>
A
锛庡畨鍏ㄦ�?/p>
B
锛庡彲绉绘鎬?/p>
C
锛庡畬鏁存�?/p>
D
锛庡苟鍙戞帶鍒?/p>
绛旀锛?/p>
B
2
锛庝繚鎶ゆ暟鎹簱锛岄槻姝㈡湭缁忔巿鏉冪殑鎴栦笉鍚堟硶鐨勪娇鐢ㄩ�犳垚鐨勬暟鎹硠婕忋�佹洿鏀圭牬鍧忋�傝繖鏄寚鏁版嵁鐨?/p>
銆?/p>
A
锛庡畨鍏ㄦ�?/p>
B
锛庡畬鏁存�?/p>
C
锛庡苟鍙戞帶鍒?/p>
D
锛庢仮澶?/p>
绛旀锛?/p>
A
3
锛庢暟鎹簱鐨?/p>
鏄寚鏁版嵁鐨勬纭�у拰鐩稿鎬с�?/p>
A
锛庡畨鍏ㄦ�?/p>
B
锛庡畬鏁存�?/p>
C
锛庡苟鍙戞帶鍒?/p>
D
锛庢仮澶?/p>
绛旀锛?/p>
B
4
锛庡湪鏁版嵁绯荤粺涓紝瀵瑰瓨鍙栨潈闄愮殑瀹氫箟绉颁负
銆?/p>
A
锛庡懡浠?/p>
B
锛庢巿鏉?/p>
C
锛庡畾涔?/p>
D
锛庡璁?/p>
绛旀锛?/p>
B
5
锛庢暟鎹簱绠＄悊绯荤粺閫氬父鎻愪緵鎺堟潈鍔熻兘鏉ユ帶鍒朵笉鍚岀敤鎴疯闂暟鎹殑鏉冮檺锛岃繖涓昏鏄负浜嗗疄鐜版暟鎹簱鐨?/p>
銆?/p>
A
锛庡彲闈犳�?/p>
B
锛庝竴鑷存�?/p>
C
锛庡畬鏁存�?/p>
D
锛庡畨鍏ㄦ�?/p>
绛旀锛?/p>
D
6
锛庝笅鍒?/p>
SQL
璇彞涓紝鑳藉瀹炵幇鈥滄敹鍥炵敤鎴?/p>
ZHAO
瀵瑰鐢熻〃锛?/p>
STUD
锛変腑瀛﹀彿锛?/p>
XH
锛夌殑淇敼鏉冣�濊繖涓�鍔熻兘鐨勬槸
A
锛?/p>
REVOKE UPDATE(XH) ON TABLE FROM ZHAO B
锛?/p>
REVOKE UPDATE(XH) ON TABLE FROM PUBLIC
C
锛?/p>
REVOKE UPDATE(XH) ON TABLE STUD FROM ZHAO D
锛?/p>
REVOKE UPDATE(XH) ON STUD FROM PUBLIC
绛旀锛?/p>
C
7
锛庢妸瀵瑰叧绯?/p>
SC
鐨勫睘鎬?/p>
GRADE
鐨勪慨鏀规潈鎺堜簣鐢ㄦ埛
ZHAO
鐨?/p>
SQL
璇彞鏄?/p>
A
锛?/p>
GRANT GRADE ON SC TO ZHAO B
锛?/p>
GRANT UPDATE ON SC TO ZHAO
C
锛?/p>
GRANT UPDATE (GRADE) ON SC TO ZHAO D
锛?/p>
GRANT UPDATE ON SC (GRADE) TO ZHAO
绛旀锛?/p>
C
8
锛庝互涓嬶紙
D
锛変笉灞炰簬瀹炵幇鏁版嵁搴撶郴缁熷畨鍏ㄦ�х殑涓昏鎶�鏈拰鏂规硶銆?/p>
A.
瀛樺彇鎺у埗鎶�鏈?/p>
B.
瑙嗗浘鎶�鏈?/p>
C.
瀹¤鎶�鏈?/p>
D.
鍑哄叆鏈烘埧鐧昏鍜屽姞閿?/p>
9
锛?/p>
SQL
涓殑瑙嗗浘鎻愰珮浜嗘暟鎹簱绯荤粺鐨勶紙
D
锛?/p>
銆?/p>
A.
瀹屾暣鎬?/p>
B.
骞跺彂鎺у埗
C.
闅旂鎬?/p>
D.
瀹夊叏鎬?/p>
10
锛庡畨鍏ㄦ�ф帶鍒剁殑闃茶寖瀵硅薄鏄紙
B
锛?/p>
锛岄槻姝粬浠鏁版嵁搴撴暟鎹殑瀛樺彇銆?/p>
A
锛庝笉鍚堣涔夌殑鏁版嵁
B
锛庨潪娉曠敤鎴?/p>
C
锛庝笉姝ｇ‘鐨勬暟鎹?/p>
D
锛庝笉绗﹀悎绾︽潫鏁版嵁
11
锛庡湪鏁版嵁搴撶郴缁熶腑锛屼繚璇佹暟鎹強璇箟姝ｇ‘鍜屾湁鏁堢殑鍔熻兘鏄?/p>
锛?/p>
锛?/p>
A.
骞跺彂鎺у埗
B.
瀛樺彇鎺у埗
C.
瀹夊叏鎺у埗
D.
瀹屾暣鎬ф帶鍒?/p>
绛旀锛?/p>
D
12
锛庡叧浜庝富閿害鏉熶互涓嬭娉曢敊璇殑鏄紙
锛?/p>
A.
涓�涓〃涓彧鑳借缃竴涓富閿害鏉?/p>
B.
鍏佽绌哄�肩殑瀛楁涓婁笉鑳藉畾涔変富閿害鏉?/p>
C.
鍏佽绌哄�肩殑瀛楁涓婂彲浠ュ畾涔変富閿害鏉?/p>
D.
鍙互灏嗗寘鍚涓瓧娈电殑瀛楁缁勫悎璁剧疆涓轰富閿?/p>
绛旀锛?/p>
C
13
锛庡湪琛ㄦ垨瑙嗗浘涓婃墽琛岄櫎浜嗭紙
锛変互澶栫殑璇彞閮藉彲浠ユ縺娲昏Е鍙戝櫒銆?/p>
A.Insert
B. Delete
C. Update
D. Create
绛旀锛?/p>
D
14
锛庢暟鎹簱鐨?/p>
____
鏄寚鏁版嵁鐨勬纭�у拰鐩稿鎬с�?/p>
A
锛庡畨鍏ㄦ�?/p>
B
锛庡畬鏁存�?/p>
C
锛庡苟鍙戞帶鍒?/p>
D
锛庢仮澶?/p>
绛旀锛?/p>
B
15
锛庡湪鏁版嵁搴撶殑琛ㄥ畾涔変腑锛岄檺鍒舵垚缁╁睘鎬у垪鐨勫彇鍊煎湪
0
鍒?/p>
100
鐨勮寖鍥村唴锛屽睘浜庢暟鎹殑
________
绾︽潫銆?/p>
A
锛庡疄浣撳畬鏁存�?/p>
B
銆佸弬鐓у畬鏁存�?/p>
C
銆佺敤鎴疯嚜瀹氫箟
D
銆佺敤鎴锋搷浣?/p>
绛旀锛?/p>
C
16
锛庡鏋滃鐢熻〃
STUDENT
鏄娇鐢ㄤ笅闈?/p>
SQL
鐨勮鍙ュ垱寤虹殑
CREATE TABLE STUDENT
(SNO char(4) PRIMARY KEY,
SNAME char(8),
SEX char(2),
AGE int CHECK(AGE>15 AND AGE<30) )
鍒欎笅闈㈢殑璇彞涓彲浠ユ纭墽琛岀殑鏄紙
A
锛?/p>
A.INSERT INTO STUDENT(SNO,SEX,AGE)values(
鈥?/p>
S9
鈥?/p>
,
鈥欑敺鈥?/p>
,17)
B.INSERT INTO STUDENT(SNO,SEX,AGE)values(
鈥?/p>
S9
鈥?/p>
锛?/p>
鈥樼敺鈥?/p>
锛?/p>
14)
C.INSERT INTO STUDENT(SNO,SEX,AGE)values
锛?/p>
鈥樼敺鈥?/p>
锛?/p>
20
锛?/p>
D.INSERT INTO STUDENT(SNO,SEX,AGE)values
锛?/p>
鈥?/p>
S9
鈥?/p>
锛?/p>
鈥樺畨鐞︹�?/p>
16
锛?/p>
17.
鍦ㄦ暟鎹簱涓垹闄よЕ鍙戝櫒浣跨敤锛?/p>
B
锛?/p>
銆?/p>
A.ROLLBACK B.DROP C.DELALLOCATE D.DELETE
浜屻�佸～绌洪