Which two statements are true regarding the storage of various database files?

You have an ASM instance and an Oracle database instance running on your Linux machine.
The Oracle database uses Automatic Storage Management (ASM) for storage and it was created using Database Configuration Assistant (DBCA). Which two statements are true regarding the storage of various database files? (Choose two.)

You have an ASM instance and an Oracle database instance running on your Linux machine.
The Oracle database uses Automatic Storage Management (ASM) for storage and it was created using Database Configuration Assistant (DBCA). Which two statements are true regarding the storage of various database files? (Choose two.)

A.
All the database files use ASM except the online redo log files.

B.
The SPFILE of the ASM instance would be stored on ASM disks.

C.
The SPFILE of the database instance would be stored on ASM disks.

D.
The data files, control files, and online redo log files of the database instance would use ASM for storage.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


mr_tienvu

mr_tienvu

I agree with the answer. CD