绮惧搧鏂囨。
绮惧搧鏂囨。
鑰?/p>
鐢?/p>
淇?/p>
鎭?/p>
鏍?/p>
绯?/p>
涓?/p>
涓?/p>
绾?/p>
鐝?/p>
绾?/p>
濮?/p>
鍚?/p>
瀛?/p>
鍙?/p>
瑁?/p>
璁?/p>
绾?/p>
涓�銆侀�夋嫨棰橈細
锛堟湰棰樺叡
20
涓皬棰橈紝姣忓皬棰?/p>
2
鍒嗭紝鍏?/p>
40
鍒嗭級
1
褰?/p>
Oracle
鏈嶅姟鍣ㄥ惎鍔ㄦ椂锛屼笅鍒楀摢绉嶆枃浠朵笉鏄繀椤荤殑
(
)
銆?/p>
A.
鏁版嵁鏂囦欢
B.
鎺у埗鏂囦欢
C.
鏃ュ織鏂囦欢
D.
褰掓。鏃ュ織鏂囦欢
2.
鍦?/p>
Oracle
涓紝涓�涓敤鎴锋嫢鏈夌殑鎵�鏈夋暟鎹簱瀵硅薄缁熺О涓?/p>
(
)
銆?/p>
A.
鏁版嵁搴?/p>
B.
妯″紡
C.
琛ㄧ┖闂?/p>
D.
瀹炰緥
3
锛庡湪
Oracle
鏁版嵁搴撶殑閫昏緫缁撴瀯涓湁浠ヤ笅缁勪欢锛?/p>
1.
琛ㄧ┖闂?/p>
2.
鏁版嵁鍧?/p>
3.
鍖?/p>
4.
娈?/p>
杩欎簺缁勪欢浠庡ぇ鍒板皬渚濇鏄紙
锛夈�?/p>
A. 1
鈫?/p>
2
鈫?/p>
3
鈫?/p>
4
B.1
鈫?/p>
4
鈫?/p>
3
鈫?/p>
2
C.1
鈫?/p>
3
鈫?/p>
2
鈫?/p>
4
D. 4
鈫?/p>
1
鈫?/p>
3
鈫?/p>
2
4.
涓嬪垪鍝釜瀛愬彞瀹炵幇瀵逛竴涓粨鏋滈泦杩涜鍒嗙粍鍜屾眹鎬?/p>
(
)
銆?/p>
A.HAVING
B.ORDER
BY
C.WHERE
D.GROUP
BY
5.
鍦?/p>
Oracle
鏁版嵁搴撲腑锛?/p>
(
)
鐢ㄦ埛妯″紡瀛樺偍鏁版嵁瀛楀吀琛ㄥ拰瑙嗗浘瀵硅薄銆?/p>
A. SYS
B. SYSTEM
C. SCOTT
D. SYSDBA
6.
浠ヤ笅涓嶅睘浜庡懡鍚嶇殑
PL/SQL
鍧楃殑鏄?/p>
(
)
銆?/p>
A
锛庣▼搴忓寘
B
锛庤繃绋?/p>
C
锛庢父鏍?/p>
D
锛庡嚱鏁?/p>
7.
鍦?/p>
Oracle
涓垱寤虹敤鎴锋椂锛?/p>
鑻ユ湭鎻愬強
DEFAULT TABLESPACE
鍏抽敭瀛楋紝
鍒?/p>
Oracle
灏卞皢锛?/p>
锛夎〃绌洪棿鍒嗛厤缁欑敤鎴蜂綔涓洪粯璁よ〃绌洪棿銆?/p>
A
锛?/p>
HR
B
锛?/p>
SCOTT
C
锛?/p>
SYSTEM
D
锛?/p>
SYS