2018
骞?/p>
OCP 052
鏈�鏂拌�冭瘯棰樺簱瑙ｆ瀽
-
20180601
棰樺簱鏂扮壒鐐癸細
鏇村姞鐏垫椿锛岄搴撶殑椤哄簭涓庤�冭瘯鏃剁殑椤哄簭姣忓満閮藉湪鍙樺寲
鏇村姞鑰冮獙鐭ヨ瘑鐐圭殑鎺屾彙锛岄搴撶瓟妗堜负浜岋紝鑰冭瘯鏃惰姹傞�夋嫨鏈�浣充竴涓瓟妗?/p>
鏁寸悊锛?/p>
CUUG
1
銆?/p>
Your database Is configured In archivelog mode.
The USERS01 tablespace Is currently online.
You are required to take the tablespace offline.
Which clause or clauses ensure that no media recovery is required
when the tablespace Is brought back online?
鈥?/p>
鉂?/p>
A) either the NORMAL or the TEMPORARY clause
鈥?/p>
鉂?/p>
B) only the NORMAL clause
鈥?/p>
鉂?/p>
C) only the TEMPORARY clause
鈥?/p>
鉂?/p>
D) either the NORMAL or the IMMEDIATE clause
鈥?/p>
鉂?/p>
E) only the IMMEDIATE clause
鈥?/p>
Answer:B
1 offline temporary
琛ㄧ┖闂存椂锛屽鏋滆〃绌洪棿涓病鏈?/p>
offline
鐨勬暟鎹枃浠讹紝鍒?/p>
online
璇ヨ〃绌洪棿鏃?/p>
涓嶉渶瑕佷粙璐ㄦ仮澶嶃�?/p>
2 offline temporary
琛ㄧ┖闂存椂锛?/p>
涓嶄細瀵瑰凡缁?/p>
offline
鐨勬暟鎹枃浠舵墽琛屾鏌ョ偣鎿嶄綔锛?/p>
浠呬粎瀵?/p>
online
鐨勬暟鎹枃浠舵墽
琛屾鏌ョ偣鎿嶄綔
3 offline temporary
琛ㄧ┖闂存椂锛屽浜庣绾胯〃绌洪棿涔嬪墠宸茬粡
offline
鐨勬暟鎹枃浠讹紝鍒?/p>
online
璇ヨ〃
绌洪棿鏃讹紝
offline
鏁?/p>
鎹枃浠堕渶瑕佷粙璐ㄦ仮澶嶃�?/p>
鈥?/p>
2
銆?/p>
Which two statements are true about tablespaces?
鈥?/p>
鉂?/p>
A) A database can contain multiple undo tablespaces.
鈥?/p>
鉂?/p>
B) A database can contain only a single temporary tablespace.
鈥?/p>
鉂?/p>
C) A database instance stores undo data In the SYSTEM tablespace If no undo tablespace
exists.
鈥?/p>
鉂?/p>
D) A database instance hangs If the SYSAUX tablespace becomes unavailable.
鈥?/p>
鉂?/p>
E)
A
database
with
a
locally
managed
SYSTEM
tablespace
can
have
dictionary
-
managed
user tablepaces.
鈥?/p>
Answer:AE