USA database practice test
Questions 1 through 10 are based on the USA Database pictured below 1. To arrange the name field so that Wyoming would be displayed first you would a. click on the name field and sort in ascending order b. filter on name contains Wyoming. c. click on Name field and sort in descending order d. filter on name is equal to Wyoming. 2. To find all the states that have a state bird that has the word cardinal in the bird field a. click on the Bird field and sort in descending order b. filter on Bird contains Cardinal c. filter on Bird is equal to Cardinal d. filter on Bird starts with Cardinal 3. To find all the states that has the brown pelican as the state bird. a. Filter on bird contains brown pelican b. filter on bird is equal to brown pelican c. filter on bird starts with brown d. a and b only. 4. To find the state that was admitted the earliest you would a. click on admitted and sort in descending order b. filter on admitted <= 1800 c. click on admitted and sort in ascending order. d. Click on the button. 5. To find all the states that have a population density of at least 300 and an area of at most 59000, you would a. Filter on population density >= 300 and area <= 59000 b. Filter on population density < 300 and area < 59000 c . Filter on population density > 300 and area < 59000 d. Filter on population density < 300 and area >=59000 6. To find the state with the nickname of Sunshine State you would a. Sort on nickname field in ascending order and look. b. Filter on name is equal to Sunshine State c . Filter on nickname is equal to Sunshine State d. Filter on nickname not equal to Sunshine State. 7 . To organize the Capital field to display in alphabetical order you would a. Sort on Capital field in descending order. b. Filter on Capital starts with a. c . Filter on Capital is equal to Albany d. Sort on Capital field in ascending order. 8 . To delete all the records of the states who have Cardinal as the state bird you would a. Sort on Bird in descending order and then delete all the fields that have the word Cardinal in them b. Sort on Bird in ascending order, select only the records of the states that have cardinal as the bird, select Edit and Delete. c . Filter on bird is equal to cardinal. From this subset, select all the records, select Edit and Delete. d. None of the above. 9. To find all the states that were admitted after 1850 or that have a population of at most 4 million people you would a. Sort on admitted in descending order and then on population in descending order. b. Filter on admitted >= 1850 and population >= 4000000 c . Filter on admitted > 1850 or population <= 4000000 d. Filter on admitted < 1850 or population <= 4000000 10. To find all the states that were admitted in 1788 or that has an area of at least 5000 you would a. Filter on admitted > 1788 or area > 5000. b. Filter on admitted = 1788 and area >= 5000 c . Filter on admitted = 1788 and area <=5000 d. Filter on admitted = 1788 or area >= 5000
Questions 1 through 10 are based on the USA Database pictured below
1. To arrange the name field so that Wyoming would be displayed first you would
a. click on the name field and sort in ascending order
b. filter on name contains Wyoming.
c. click on Name field and sort in descending order
d. filter on name is equal to Wyoming.
2. To find all the states that have a state bird that has the word cardinal in the bird field
a. click on the Bird field and sort in descending order
b. filter on Bird contains Cardinal
c. filter on Bird is equal to Cardinal
d. filter on Bird starts with Cardinal
3. To find all the states that has the brown pelican as the state bird.
a. Filter on bird contains brown pelican
b. filter on bird is equal to brown pelican
c. filter on bird starts with brown
d. a and b only.
4. To find the state that was admitted the earliest you would
a. click on admitted and sort in descending order
b. filter on admitted <= 1800
c. click on admitted and sort in ascending order.
d. Click on the button.
5. To find all the states that have a population density of at least 300 and an area of at most 59000, you would
a. Filter on population density >= 300 and area <= 59000
b. Filter on population density < 300 and area < 59000
c . Filter on population density > 300 and area < 59000
d. Filter on population density < 300 and area >=59000
6. To find the state with the nickname of Sunshine State you would
a. Sort on nickname field in ascending order and look.
b. Filter on name is equal to Sunshine State
c . Filter on nickname is equal to Sunshine State
d. Filter on nickname not equal to Sunshine State.
7 . To organize the Capital field to display in alphabetical order you would
a. Sort on Capital field in descending order.
b. Filter on Capital starts with a.
c . Filter on Capital is equal to Albany
d. Sort on Capital field in ascending order.
8 . To delete all the records of the states who have Cardinal as the state bird you would
a. Sort on Bird in descending order and then delete all the fields that have the word Cardinal in them
b. Sort on Bird in ascending order, select only the records of the states that have cardinal as the bird, select Edit and Delete.
c . Filter on bird is equal to cardinal. From this subset, select all the records, select Edit and Delete.
d. None of the above.
9. To find all the states that were admitted after 1850 or that have a population of at most 4 million people you would
a. Sort on admitted in descending order and then on population in descending order.
b. Filter on admitted >= 1850 and population >= 4000000
c . Filter on admitted > 1850 or population <= 4000000
d. Filter on admitted < 1850 or population <= 4000000
10. To find all the states that were admitted in 1788 or that has an area of at least 5000 you would
a. Filter on admitted > 1788 or area > 5000.
b. Filter on admitted = 1788 and area >= 5000
c . Filter on admitted = 1788 and area <=5000
d. Filter on admitted = 1788 or area >= 5000
