1
绗?/p>
6
绔?/p>
涔犻瑙ｇ瓟
1
锛庨�夋嫨棰?/p>
锛?/p>
1
锛?/p>
锛?/p>
C
锛夊厑璁哥敤鎴峰畾涔変竴缁勬搷浣滐紝杩欎簺鎿嶄綔閫氳繃瀵规寚瀹氱殑琛ㄨ繘琛屽垹闄ゃ�佹彃鍏ュ拰
鏇存柊鍛戒护鏉ユ墽琛屾垨瑙﹀彂銆?/p>
A
锛庡瓨鍌ㄨ繃绋?/p>
B
锛庤鍥?/p>
C
锛庤Е鍙戝櫒
D
锛庣储寮?/p>
锛?/p>
2
锛?/p>
SQL Server
涓烘瘡涓Е鍙戝櫒鍒涘缓浜嗕袱涓复鏃惰〃锛屽畠浠槸锛?/p>
B
锛?/p>
銆?/p>
A
锛?/p>
Updated
鍜?/p>
Deleted
B
锛?/p>
Inserted
鍜?/p>
Deleted
C
锛?/p>
Inserted
鍜?/p>
Updated
D
锛?/p>
Seleted
鍜?/p>
Inserted
锛?/p>
3
锛?/p>
SQL
Server
涓瓨鍌ㄨ繃绋嬬敱涓�缁勯鍏堝畾涔夊苟琚?/p>
锛?/p>
C
锛?/p>
鐨?/p>
Transact-SQL
璇彞缁勬垚銆?/p>
A
锛庣紪鍐?/p>
B
锛庤В閲?/p>
C
锛庣紪璇?/p>
D
锛庝繚瀛?/p>
锛?/p>
4
锛変笅鍒楀彲浠ユ煡鐪嬭〃鐨勮鏁颁互鍙婅〃浣跨敤鐨勫瓨鍌ㄧ┖闂翠俊鎭殑绯荤粺瀛樺偍杩囩▼鏄紙
A
锛?/p>
銆?/p>
A
锛?/p>
sq_spaceused
B
锛?/p>
sq_depends
C
锛?/p>
sq_help
D
锛?/p>
sq_rename
锛?/p>
5
锛変互涓嬭鍙ュ垱寤虹殑瑙﹀彂鍣?/p>
ABC
鏄綋瀵硅〃
T
杩涜
_
_D
_____
鎿嶄綔鏃惰Е鍙戙�?/p>
CREATE TRIGGER ABC ON
琛?/p>
T
FOR INSERT, UPDATE, DELETE
AS
鈥︹�?/p>
A
锛庡彧鏄慨鏀?/p>
B
锛庡彧鏄彃鍏?/p>
C
锛庡彧鏄垹闄?/p>
D
锛庝慨鏀广�佹彃鍏ャ�佸垹闄?/p>
锛?/p>
6
锛変互涓?/p>
_______
涓嶆槸瀛樺偍杩囩▼鐨勪紭鐐广�?/p>
A
锛庡疄鐜版ā鍧楀寲缂栫▼锛岃兘琚涓敤鎴峰叡浜拰閲嶇敤
B
锛庡彲浠ュ姞蹇▼搴忕殑杩愯閫熷害
C
锛庡彲浠ュ鍔犵綉缁滅殑娴侀噺
D
锛庡彲浠ユ彁楂樻暟鎹簱鐨勫畨鍏ㄦ�?/p>
锛?/p>
7
锛変互涓?/p>
_______
鎿嶄綔涓嶆槸瑙﹀彂瑙﹀彂鍣ㄧ殑鎿嶄綔銆?/p>
A
锛?/p>
SELECT
B
锛?/p>
INSERT
C
锛?/p>
DELETE
D
锛?/p>
UPDATE
锛?/p>
8
锛変笅闈㈠叧浜庤Е鍙戝櫒鐨勬弿杩帮紝閿欒鐨勬槸
_______
銆?/p>
A
锛庤Е鍙戝櫒鏄竴绉嶇壒娈婄殑瀛樺偍杩囩▼锛岀敤鎴峰彲浠ョ洿鎺ヨ皟鐢?/p>
B
锛庤Е鍙戝櫒琛ㄥ拰
deleted
琛ㄦ病鏈夊叡鍚岃褰?/p>
C
锛庤Е鍙戝櫒鍙互鐢ㄦ潵瀹氫箟姣?/p>
CHECK
绾︽潫鏇村鏉傜殑瑙勫垯
D
锛庡垹闄よЕ鍙戝櫒鍙互浣跨敤
DROP TRIGGER
鍛戒护锛屼篃鍙互浣跨敤浼佷笟绠＄悊鍣?/p>
锛?/p>
9
锛夊叧浜?/p>
SQL Server
涓殑瀛樺偍杩囩▼锛屼笅鍒楄娉曚腑姝ｇ‘鐨勬槸
_______
銆?/p>
A
锛庝笉鑳芥湁杈撳叆鍙傛暟
B
锛庢病鏈夎繑鍥炲�?/p>
C
锛庡彲浠ヨ嚜鍔ㄨ鎵ц
D
锛庡彲浠ュ祵濂椾娇鐢?/p>
锛?/p>
10
锛夊浜庝笅闈㈢殑瀛樺偍杩囩▼锛?/p>
CREATE PROCEDURE Mysp1 @p Int
AS
SELECT St_name, Age FROM Students WHERE Age=@p
璋冪敤杩欎釜瀛樺偍杩囩▼鏌ヨ骞撮緞涓?/p>
20
宀佺殑瀛︾敓鐨勬纭柟娉曟槸
_______
銆?/p>
A
锛?/p>
EXEC Mysp1 @p='20'
B
锛?/p>
EXEC Mysp1 @p=20
C
锛?/p>
EXEC Mysp1='20'
D
锛?/p>
EXEC Mysp1=20