What is one of the downsides of using RAID 5 as

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

(Continued from previous question...)

What is one of the downsides of using RAID 5 as opposed to RAID 1?

Answer: Both write and read performance are worse.

Explanation: The downside of RAID 5 is that write performance can be degraded because it must calculate parity as well as write the data to multiple disks. In RAID 1, the information is written once to two disks.

(Continued on next question...)

Other Job Interview Questions

• How many dimensions can you have in a SQL Server 2005 Analysis Services database?
• Can a contained in SQL Server 2005 Integration Services enlist in a transaction started by a sibling container?
• What is an index? What types of indexes are available in SQL Server 2000?
• Which of the following is the best use for a Scalable Shared Database in SQL Server 2005?
• When using the SQLCMD tool, what does the -V parameter do?
• You wish to initialize subscribers to your SQL Server 2005 database using FTP. Which versions can you do this with?
• You are performing a number of SELECT queries on one of your SQL Server 2005 Service Broker queues and you get a call that applications using the queues are running slowly. What can you do?
• True or false, Report Builder offers direct export to a Microsoft Access database as one of its supported export options?
• What can tracer tokens measure in SQL Server 2005 transactional replication?
• Does a root element in an XML document necessarily contain all the content for a well-formed document?
• More...