Database Practice Test
Questions 1 through 6 are based on the database North Carolina County 2000 data 1. To find the county that had the greatest population in 2000 you would a. click on the Population field name and sort in ascending order b. filter on Population field name > 2000 c. click on Population field and sort in descending order d. filter on Population field = 2000 2. To find all the counties that start with the letter C you would a. click on the Name field name and sort in ascending order b. filter on Name field begins with C c. filter on Name field name = C d. filter on Name field name <= C 3. To find all the counties that had employment greater than 40000 and less than 70000 you would a. click on the Employment field name and sort in descending order. b. filter on the Employment field > 40000 and then from that subset of data, sort on Employment field in descending order c. filter on Employment field > 40000 and Employment field < 70000 d. filter on Employment field <40000 and Employment field >70000 4. To find the Employment of Burke County and the Employment of Wake County you would a. click on the Name field and sort in ascending order and then looking at the data to get the answer. b. filter on the Name field is equal to Burke and county field is equal to Wake and look at the County Employment fields of the two records. c. filter on the Name field is equal to Burke or county field is equal to Wake and look at the County Employment fields of the two records. d. filter on Name field is equal to Burke and Employment field is equal to Wake. 5. Find all the counties where at least 40 percent of the population got a Bachelor's degree or higher. a. click on the % Bachelor's or Higher field, click on the down arrow and look at the data to get the answer. b. filter on the % Bachelor's or Higher field > 40 c . filter on the % Bachelor's or Higher field >= 40 d. filter on the % Bachelor's or Higher field <= 40 6. Find the county that had the greatest amount of unemployment. a. click on the # Unemployed field, sort in descending order and look at the data to get the answer. b. click on the # Unemployed field, sort ascending and look at the data to get the answer. c . filter on the # Unemployed field = 2000 d. filter on the # Unemployed field > 2000
Questions 1 through 6 are based on the database North Carolina County 2000 data
1. To find the county that had the greatest population in 2000 you would
a. click on the Population field name and sort in ascending order
b. filter on Population field name > 2000
c. click on Population field and sort in descending order
d. filter on Population field = 2000
2. To find all the counties that start with the letter C you would
a. click on the Name field name and sort in ascending order
b. filter on Name field begins with C
c. filter on Name field name = C
d. filter on Name field name <= C
3. To find all the counties that had employment greater than 40000 and less than 70000 you would
a. click on the Employment field name and sort in descending order.
b. filter on the Employment field > 40000 and then from that subset of data, sort on Employment field in descending order
c. filter on Employment field > 40000 and Employment field < 70000
d. filter on Employment field <40000 and Employment field >70000
4. To find the Employment of Burke County and the Employment of Wake County you would
a. click on the Name field and sort in ascending order and then looking at the data to get the answer.
b. filter on the Name field is equal to Burke and county field is equal to Wake and look at the County Employment fields of the two records.
c. filter on the Name field is equal to Burke or county field is equal to Wake and look at the County Employment fields of the two records.
d. filter on Name field is equal to Burke and Employment field is equal to Wake.
5. Find all the counties where at least 40 percent of the population got a Bachelor's degree or higher.
a. click on the % Bachelor's or Higher field, click on the down arrow and look at the data to get the answer.
b. filter on the % Bachelor's or Higher field > 40
c . filter on the % Bachelor's or Higher field >= 40
d. filter on the % Bachelor's or Higher field <= 40
6. Find the county that had the greatest amount of unemployment.
a. click on the # Unemployed field, sort in descending order and look at the data to get the answer.
b. click on the # Unemployed field, sort ascending and look at the data to get the answer.
c . filter on the # Unemployed field = 2000
d. filter on the # Unemployed field > 2000
