Indiana University Southeast
Natural Sciences Division
Sample Final Examination
C100 Databases
1 - What do you understand by path? Give at least one example to explain.
1.1 - Make FINALS sub-directory the root of your diskette. You must save all the work of the final exam under this sub-directory.
2 - Make the database table shown in figure 9-21 on page 200 of your textbook. Save the table under the name CH9-21.
2.1 - Sort this table in the alphabetical order by last name. Save the table under the name SORT9-21.
3 - Make the following queries using this table:
3.1 - List the last name and zip code of all the customers. Save the query under the name QUERY_F1. Save the answer table under the name ANSF_1.
3.2 - List first name, last name, city and state for the customers whose first name has 'O' as the second character. Save the query under the name QUERY_F2. Save the answer table under the name ANSF_2.
3.3 - Count the number of customers from the state of California or Colorado. Save the query under the name QUERY_F3. Save the answer table under the name ANSF_3.
4 - Submit the hardcopy listing of A:\FINALS and the floppy disk.
Note: Your floppy disk can be picked-up by next week from the basket on my office door.