1
/
20
绗竴濂?/p>
閫夋嫨棰?/p>
1.
涓嬪垪璇存硶閿欒鐨勬槸锛?/p>
锛夈�?/p>
A
锛庡唴宓岃〃鍊煎嚱鏁版病鏈夊嚱鏁颁富浣擄紝杩斿洖鐨勮〃鏄崟涓?/p>
SELECT
璇彞鐨勭粨鏋滈泦
B
锛庡璇彞琛ㄥ�煎嚱鏁扮殑璋冪敤涓庡唴宓岃〃鍊煎嚱鏁扮殑璋冪敤鏂规硶鐩稿悓
C
锛庡璇彞琛ㄥ�煎嚱鏁扮殑鍔熻兘鍙互鐢ㄦ爣閲忓嚱鏁版潵瀹炵幇
D
锛庡湪鍐呭祵琛ㄥ�煎嚱鏁扮殑瀹氫箟涓紝涓嶄娇鐢?/p>
BEGIN
鈥?/p>
END
鍧楀畾涔夊嚱鏁颁富浣?/p>
2.
浠ヤ笅鍝釜浜嬩欢涓嶈兘婵�娲?/p>
DML
瑙﹀彂鍣ㄧ殑鎵ц锛?/p>
锛夈�?/p>
A
锛?/p>
SELECT B. UPDATE
C. INSERT D. DELETE
3.
浠ヤ笅鍝釜鏁版嵁搴撳疄渚嬩笉灞炰簬绯荤粺鏁版嵁搴擄紙
锛夈�?/p>
A
锛?/p>
master B
锛?/p>
model
C
锛?/p>
msdb D
锛?/p>
temp
4.
鎵ц浠ヤ笅璇彞锛?/p>
DECLARE @n int
Set @n=3
WHILE @n<5
Begin
IF @n=4
Print ltrim(@n)+
鈥樼殑骞虫柟鏁颁负鈥?/p>
+ltrim(@n*@n)
Set @n=@n+1
End
鎵ц瀹屾垚鍚庡惊鐜鏁颁负锛?/p>
锛夈�?/p>
A
锛?/p>
0
娆?/p>
B
锛?/p>
1
娆?/p>
C
锛?/p>
2
娆?/p>
D
锛庢寰幆
5.
鍒╃敤娓告爣鏉ユ搷绾垫暟鎹椂锛屾墍鐢ㄧ殑
FOR UPDATE
瀛愬彞鍏呭垎鍒╃敤浜嗕簨鍔＄殑鍝釜鐗规�?/p>
锛?/p>
锛夈�?/p>
A
锛庡師瀛愭�?/p>
B
锛庝竴鑷存�?/p>
C
锛庢案涔呮�?/p>
D
锛庨殧绂绘�?/p>
6.
鍏充簬瑙﹀彂鍣ㄧ殑鎻忚堪锛屼笅鍒楄娉曟纭殑鏄紙
锛夈�?/p>
A
锛庤Е鍙戝櫒鏄湪鏁版嵁淇敼鍓嶈瑙﹀彂锛岀害鏉熸槸鍦ㄦ暟鎹慨鏀瑰悗琚Е鍙?/p>
B
锛庤Е鍙戝櫒鏄竴涓兘鑷姩鎵ц鐨勭壒娈婄殑瀛樺偍杩囩▼
C
锛庤Е鍙戝櫒浣滀负涓�涓嫭绔嬬殑瀵硅薄瀛樺湪锛屼笌鏁版嵁搴撲腑鍏朵粬瀵硅薄鏃犲叧
D
锛?/p>
inserted
琛ㄥ拰
deleted
琛ㄦ槸鏁版嵁搴撲腑鐨勭墿鐞嗚〃
7.
鍏充簬鏈嶅姟鍣ㄨ鑹蹭笌鏁版嵁搴撹鑹诧紝璇存硶姝ｇ‘鐨勬槸锛?/p>
锛夈�?/p>
A
锛庡彧鑳藉皢涓�涓櫥褰曞悕娣诲姞涓烘煇涓浐瀹氭湇鍔″櫒瑙掕壊鐨勬垚鍛?/p>
B
锛庡彧鑳藉皢涓�涓櫥褰曞悕娣诲姞涓烘煇涓浐瀹氭暟鎹簱瑙掕壊鐨勬垚鍛?/p>
C
锛?/p>
sysadmin
鏄浐瀹氭暟鎹簱瑙掕壊
D
锛?/p>
db_owner
鏄浐瀹氭湇鍔″櫒瑙掕壊
8.
鍏充簬鍒涘缓姘镐箙澶囦唤璁惧锛屼笅鍒楄娉曢敊璇殑鏄紙
锛夈�?/p>
A
锛庢墽琛岀郴缁熷瓨鍌ㄨ繃绋?/p>
sp_addumpdevice
鍒涘缓姘镐箙澶囦唤璁惧
B
锛庢墽琛岀郴缁熷瓨鍌ㄨ繃绋?/p>
sp_dropdevice
鍒犻櫎姘镐箙澶囦唤璁惧
C
锛庤嫢琚垹闄ょ殑鈥滃懡鍚嶅浠借澶団�濈殑绫诲瀷涓虹鐩橈紝閭ｄ箞蹇呴』鎸囧畾
DELFILE
閫夐」
D
锛庡彧椤绘寚瀹氳鍛藉悕澶囦唤璁惧鐨勭墿鐞嗗悕锛屾棤椤绘寚瀹氳鍛藉悕澶囦唤璁惧鐨勯�昏緫鍚?/p>