What is an example of hardware partitioning?

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

(Continued from previous question...)

What is an example of hardware partitioning?

Answer: Using multiple CPUs to handle the workload.

Explanation: Hardware partitioning involves using the hardware architecture to divide the load. Examples would be multiple processors to run multiple threads of execution, multiple disk drives to service requests, multiple network cards to handle incoming data.

(Continued on next question...)

Other Job Interview Questions

• In SQL Server 2005, what does instance aware mean for a service?
• What is the cost threshhold for parallelism in SQL Server 2005?
• What is the difference between a return parameter and an OUTPUT parameter?
• You are configuring a SQL Server 2005 Reporting Services instance for email delivery of reports. What are your options for delivering email?
• What will occur with the following code in SQL Server 2005 if executed by Alice?
• In the REPEATABLE READ isolation level, what phenomena is still possible?
• You want to be sure that your Scalable Shared Database is as available as possible. Which of the following is not needed for this?
• In SQL Server 2005, you want to monitor your transactional replication and determine how long it takes for a transaction to move from the publisher to a subscriber. What would you use to help you do this?
• What does this WHERE clause evaluate to?
• You wish to prevent anyone from using the sa account on your SQL Server 2005 instance, but still keep it available if your polocy changes. What can you do?
• More...