f
锛堣�冭瘯鏃堕棿锛?/p>
180
鍒嗛挓
璇曞嵎婊″垎锛?/p>
300
鍒嗭級
娉ㄦ剰浜嬮」锛?/p>
1.
绛斿嵎鍓嶏紝璇峰叧闂墜鏈猴紝绂佹浣跨敤璁惧瀵硅瘯鍗疯繘琛屾媿鐓с�?/p>
2.
璇峰姟蹇呭皢涓汉鐩稿叧淇℃伅濉啓鍦ㄧ浉搴斾綅缃�?/p>
3.
璇峰皢绛旀濉啓鍦ㄧ浉搴斾綅缃紝鍚﹀垯鏃犳晥銆?/p>
绗竴閮ㄥ垎
鍗曢�夐锛堟瘡棰?/p>
2
鍒嗭紝婊″垎
80
鍒嗭級
鍋氶鏃讹紝鍏堝皢绛旀鏍囧湪璇曞嵎涓婏紝褰曢煶缁撴潫鍚庯紝浣犲皢鏈変袱鍒嗛挓鐨勬椂闂村皢璇曞嵎涓婄殑绛旀杞?/p>
娑傚埌绛旈鍗′笂銆?/p>
涓�銆佸崟閫夐锛堟瘡棰?/p>
2
鍒?/p>
* 40 = 80
鍒嗭級
1.
浣跨敤
Oracle
鏁版嵁搴擄紝蹇呴』鍚姩鍝釜鏈嶅姟锛?/p>
锛?/p>
A
锛?/p>
OracleHOME_NAMETNSListener
B
锛?/p>
OracleServiceSID
C
锛?/p>
OracleMTSRecoveryService
D
锛?/p>
OracleJobSchedulerSID
2.
鍦?/p>
Windows
鎿嶄綔绯荤粺涓紝
Oracle
鐨?/p>
锛堬級
鏈嶅姟鐩戝惉骞舵帴鍙楁潵鑷鎴风搴旂敤绋嬪簭鐨勮繛鎺ヨ姹傘�?/p>
A
锛?/p>
OracleHOME_NAMETNSListener
B
锛?/p>
OracleServiceSID
C
锛?/p>
OracleHOME_NAMEAgent
D
锛?/p>
OracleHOME_NAMEHTTPServer
3.
鐢ㄤ簩缁磋〃缁撴瀯琛ㄨ揪瀹炰綋闆嗙殑妯″瀷鏄紙
锛?/p>
A
锛庢蹇垫ā鍨?/p>
B
锛庡眰娆℃ā鍨?/p>
C
锛庣綉鐘舵ā鍨?/p>
D
锛庡叧绯绘ā鍨?/p>
4. Oracle
11g
鏄熀浜庯紙
锛夌殑
A.
鍏崇郴鍨?/p>
B.
鏂囦欢绯荤粺
C.
灞傛鍨?/p>
D.
缃戠粶鍨?/p>
5. ( )
浠ｈ〃浜嗘暟鎹簱涓渶灏忕矑搴︾殑閫昏緫鏁版嵁瀛樺偍灞傛銆?/p>
A.
鐩樺尯
B.
琛ㄧ┖闂?/p>
C.
鏁版嵁鍧?/p>
D.
鏁版嵁鏂囦欢
6.
浣犱娇鐢ㄤ笅鍒楀懡浠よ繛鎺ユ暟鎹簱锛?/p>
sqlplusscott/***************:1522/orcl.
鐩爣鏁版嵁搴?/p>
鏄摢涓�涓紵锛?/p>
锛?/p>
A. abc.com B.tiger
C. orcl
D. scott
7.
璁炬湁涓�涓叧绯伙細
DEPT
锛?/p>
DNO
锛?/p>
DNAME,LOC
锛?/p>
锛屽鏋滆鎵惧嚭鍊掓暟绗笁涓瓧姣嶄负
W
锛屽苟涓旇嚦灏戝寘
鍚?/p>
4
涓瓧姣嶇殑
DNAME
锛屽垯鏌ヨ鏉′欢瀛愬彞搴斿啓鎴?/p>
WHERE DNAME LIKE
锛?/p>
锛?/p>
A.鈥榑 _ W _ %鈥?nbsp;
B.鈥榑 % W _ _鈥?/p>
C. 鈥榑 W _ _鈥?nbsp; D. 鈥榑 W _ %鈥?/p>
8.
涓嬪垪瑙ｉ攣
scott
璐︽埛鐨勫懡浠ゆ纭殑鏄紙锛?/p>
A
銆?/p>
update user scottaccount unlock;
B
銆?/p>
alter user scott account unlock;
C
銆?/p>
alter user scott unlock;
9. having
, where , group by
鐨勬纭墽琛岄『搴忔槸锛?/p>
锛?/p>
A
銆?/p>
having,where,group by