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