It is possible to use raw devices as data files

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

416. It is possible to use raw devices as data files and what is the advantages over file system files?

Yes. The advantages over file system files. I/O will be improved because Oracle is bypassing the kernel when writing to disk. Disk Corruption will decrease.

(Continued on next question...)

Other Job Interview Questions

• What is a Synonym?
• Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
• What are the different default triggers created when Master Deletes Property is set to Non-isolated?
• How do you reference a parameter indirectly?
• What is COST-based approach to optimization?
• What does ROLLBACK do?
• What are some indications that you need to increase the SHARED_POOL_SIZE parameter?
• Describe two phases of Two-phase commit?
• Which date function returns number value?
• What does a Control file Contain?
• More...