本文主要是介绍OCP-1Z0-053-V13.02-538题,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!
538.Which type of database file is spread across all disks in a disk group?
A. All types of files are spread across all disks in the disk group.
B. Datafiles
C. Redo log files
D. Archived redo log files
E. Control files
Answer: A
答案解析:
从以下可知,BCDE文件都会存储在disk上
sys@RCAT1028> select name from v$datafile;
NAME
--------------------------------------------------
+DATA/rcat1028/datafile/system.262.830015445
+DATA/rcat1028/datafile/sysaux.261.830015451
+DATA/rcat1028/datafile/undotbs1.265.830015451
+DATA/rcat1028/datafile/users.259.830015453
+DATA/rcat01.dbf
sys@RCAT1028> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------------ ------------ ------------------
1 1 19 52428800 512 2 YES INACTIVE 1525062 08-NOV-13 1540138 09-NOV-13
2 1 20 52428800 512 2 YES INACTIVE 1540138 09-NOV-13 1571988 09-NOV-13
3 1 21 52428800 512 2 NO CURRENT 1571988 09-NOV-13 2.8147E+14
sys@RCAT1028> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_
---------- ------- ------- -------------------------------------------------- ---
3 ONLINE +DATA/rcat1028/onlinelog/group_3.257.830015661 NO
3 ONLINE +RECOVERY/rcat1028/onlinelog/group_3.259.830015665 YES
2 ONLINE +DATA/rcat1028/onlinelog/group_2.263.830015655 NO
2 ONLINE +RECOVERY/rcat1028/onlinelog/group_2.258.830015657 YES
1 ONLINE +DATA/rcat1028/onlinelog/group_1.258.830015647 NO
1 ONLINE +RECOVERY/rcat1028/onlinelog/group_1.257.830015651 YES
6 rows selected.
sys@RCAT1028> select name from v$archived_log;
NAME
--------------------------------------------------
+RECOVERY/rcat1028/archivelog/2013_10_28/thread_1_seq_5.264.830030433
+RECOVERY/rcat1028/archivelog/2013_10_29/thread_1_seq_6.265.830106043
+RECOVERY/rcat1028/archivelog/2013_10_29/thread_1_seq_7.266.830125503
+RECOVERY/rcat1028/archivelog/2013_10_30/thread_1_seq_8.267.830214029
这篇关于OCP-1Z0-053-V13.02-538题的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!