NAIMMCQ MS SQL Server 2008 Using the data from Table 6-5, you need to partition the table into three divisions, one for employees who make less than $49,999 one for employees who make $50,000 to $69,999, and one for employees who make $70,000 and higher. Which function should you use?

Using the data from Table 6-5, you need to partition the table into three divisions, one for employees who make less than $49,999 one for employees who make $50,000 to $69,999, and one for employees who make $70,000 and higher. Which function should you use?

MS SQL Server 2008

Using the data from Table 6-5, you need to partition the table into three divisions, one for employees who make less than $49,999 one for employees who make $50,000 to $69,999, and one for employees who make $70,000 and higher. Which function should you use?

Answer – CREATE PARTITION FUNCTION pfSalary (money) AS RANGE RIGHT FOR VALUES (50000,70000);

(The RIGHT range gives you three partitions, 0–49,999, 50,000–69,999, and 70,000 and higher. A LEFT range would give you 0–49,999, 50,000–69,999, and 70,000 and higher.)

NAIMMCQ

Using the data from Table 6-5, you need to partition the table into three divisions, one for employees who make less than $49,999 one for employees who make $50,000 to $69,999, and one for employees who make $70,000 and higher. Which function should you use?

Using the data from Table 6-5, you need to partition the table into three divisions, one for employees who make less than $49,999 one for employees who make $50,000 to $69,999, and one for employees who make $70,000 and higher. Which function should you use?

Share this