- 1 -
涓�銆?/p>
閫夋嫨棰?/p>
1
銆?/p>
DB
銆?/p>
DBMS
鍜?/p>
DBS
涓夎�呬箣闂寸殑鍏崇郴鏄紙
B
锛?/p>
锛?/p>
A
锛?/p>
DB
鍖呮嫭
DBMS
鍜?/p>
DBS
锛?/p>
B
锛?/p>
DBS
鍖呮嫭
DB
鍜?/p>
DBMS
锛?/p>
C
锛?/p>
DBMS
鍖呮嫭
DB
鍜?/p>
DBS
锛?/p>
D
锛変笉鑳界浉浜掑寘鎷?/p>
2
銆?/p>
DBMS
閫氬父鎻愪緵鎺堟潈鍔熻兘鏉ユ帶鍒朵笉鍚岀敤鎴疯闂暟鎹殑鏉冮檺锛岃繖涓昏鏄负浜嗗疄鐜版暟鎹簱鐨勶紙
D
锛?/p>
锛?/p>
A
锛夊彲闈犳�э紙
B
锛変竴鑷存�?/p>
锛?/p>
C
锛夊畬鏁存�э紙
D
锛夊畨鍏ㄦ�?/p>
3
銆?/p>
E-R
鍥炬槸鏁版嵁搴撹璁＄殑宸ュ叿涔嬩竴锛屽畠閫傜敤浜庡缓绔嬫暟鎹簱鐨勶紙
A
锛?/p>
锛?/p>
A
锛夋蹇垫ā鍨嬶紙
B
锛夐�昏緫妯″瀷
锛?/p>
C
锛夌粨鏋勬ā鍨嬶紙
D
锛夌墿鐞嗘ā鍨?/p>
4
銆?/p>
SELECT
璇彞浣跨敤鍏抽敭瀛楋紙
A
锛夊彲浠ユ妸閲嶅琛屽睆钄芥帀銆?/p>
锛?/p>
A
锛?/p>
DISTINCT
锛?/p>
B
锛?/p>
UNION
锛?/p>
C
锛?/p>
UNIQUE
锛?/p>
D
锛?/p>
TOP
5
銆?/p>
SQL Server
鏁版嵁搴撴槸鐢辨枃浠剁粍鎴愮殑銆備笅鍒楀叧浜庢暟鎹簱鎵�鍖呭惈鐨勬枃浠剁殑璇存硶涓紝姝ｇ‘鐨勬槸锛?/p>
D
锛?/p>
锛?/p>
A
锛変竴涓暟鎹簱榛樿灏嗘暟鎹枃浠跺強鏃ュ織鏂囦欢褰掍簬涓绘枃浠剁粍
锛?/p>
B
锛変竴涓暟鎹簱鍙兘鍖呭惈涓�涓富瑕佹暟鎹枃浠跺拰涓�涓棩蹇楁枃浠?/p>
锛?/p>
C
锛変竴涓暟鎹簱鍙寘鍚涓瑕佹暟鎹枃浠讹紝浣嗗彧鑳藉寘鍚竴涓棩蹇楁枃浠?/p>
锛?/p>
D
锛変竴涓暟鎹簱鍙寘鍚涓瑕佹暟鎹枃浠跺拰澶氫釜鏃ュ織鏂囦欢
6
銆?/p>
SQL Server
鎻愪緵鐨勫崟琛屾敞閲婅鍙ョ殑娉ㄩ噴绗︽槸锛?/p>
B
锛?/p>
锛?/p>
A
锛?/p>
鈥?/p>
/*
鈥?/p>
锛?/p>
B
锛?/p>
鈥?/p>
--
鈥?/p>
锛?/p>
C
锛?/p>
鈥?/p>
*/
鈥?/p>
锛?/p>
D
锛?/p>
鈥?/p>
//
鈥?/p>
7
銆?/p>
SQL
涓?/p>
C
璇█澶勭悊璁板綍鐨勬柟寮忔槸涓嶅悓鐨勩�?/p>
褰撳皢
SQL
璇彞宓屽叆鍒?/p>
C
璇█绋嬪簭鏃讹紝
涓哄崗璋冧袱鑰呰�屽紩鍏?/p>
锛?/p>
C
锛?/p>
锛?/p>
A
锛夊爢锛?/p>
B
锛夋爤
锛?/p>
C
锛夋父鏍囷紙
D
锛夎仛绨?/p>
8
銆?/p>
SQL
璇█鐨勪竴娆℃煡璇㈢殑缁撴灉鏄竴涓紙
D
锛?/p>
锛?/p>
A
锛夋暟鎹」锛?/p>
B
锛夎褰?/p>
锛?/p>
C
锛夊厓缁勶紙
D
锛夎〃
9
銆?/p>
SQL
璇█鍏锋湁涓ょ浣跨敤鏂瑰紡锛屽垎鍒О涓轰氦浜掑紡
SQL
鍜岋紙
C
锛?/p>
锛?/p>
A
锛夌紪璇戝紡
SQL
锛?/p>
B
锛夎В閲婂紡
SQL
锛?/p>
C
锛夊祵鍏ュ紡
SQL
锛?/p>
D
锛夎繃绋嬪寲
SQL
10
銆?/p>
SQL
璇█鏄紙
C
锛夎瑷�銆?/p>
锛?/p>
A
锛夊眰娆℃暟鎹簱锛?/p>
B
锛夌綉缁滄暟鎹簱
锛?/p>
C
锛夊叧绯绘暟鎹簱锛?/p>
D
锛夐潪鏁版嵁搴?/p>
11
銆?/p>
SQL
璇█鏄叧绯绘暟鎹簱鐨勬爣鍑嗚瑷�锛屽畠鏄紙
B
锛?/p>
锛?/p>
A
锛夎繃绋嬪寲鐨勶紙
B
锛夐潪杩囩▼鍖栫殑
锛?/p>
C
锛夋牸寮忓寲鐨勶紙
D
锛夊鑸紡鐨?/p>
12
銆?/p>
X
鈫?/p>
Y
锛屽綋涓嬪垪锛?/p>
D
锛夋垚绔嬫椂锛岀О涓哄钩鍑″嚱鏁颁緷璧栥�?/p>
锛?/p>
A
锛?/p>
X
鈫?/p>
Y
锛涳紙
B
锛?/p>
Y
鈫?/p>
X;
锛?/p>
C
锛?/p>
X
鈫?/p>
Y=脴
锛涳紙
D
锛夐兘涓嶆纭�?/p>
13
銆佹寜鎵�浣跨敤鐨勬暟鎹ā鍨嬫潵鍒嗭紝鏁版嵁搴撳彲鍒嗕负锛?/p>
A
锛変笁绉嶇被鍨嬨�?/p>
锛?/p>
A
锛夊眰娆°�佸叧绯诲拰缃戠姸锛?/p>
B
锛夌綉鐘躲�佺幆鐘跺拰閾剧姸
锛?/p>
C
锛夊ぇ鍨嬨�佷腑鍨嬪拰灏忓瀷锛?/p>
D
锛夌嫭浜�佸叡浜拰鍒嗘椂
14
銆佷繚鎶ゆ暟鎹簱锛岄槻姝㈡湭缁忔巿鏉冪殑鎴栦笉鍚堟硶鐨勪娇鐢ㄩ�犳垚鐨勬暟鎹硠闇层�佹洿鏀圭牬鍧忋�傝繖鏄寚鏁版嵁搴撶殑锛?/p>
A
锛?/p>
锛?/p>
A
锛夊畨鍏ㄦ�э紙
B
锛夊畬鏁存�?/p>
锛?/p>
C
锛夊苟鍙戞帶鍒讹紙
D
锛夋仮澶?/p>
15
銆佽〃绀轰簨鍔℃墽琛屾垚鍔熺殑璇彞鏄紙
A
锛?/p>