Q1. What is the purpose of field value substitutions as described in the video?
A. To force users to select from a predefined list of values
B. To allow users to type in their own values while correcting common errors
C. To create a list of all possible country names
D. To enhance database security by restricting data entry options

Q2. Why does the instructor prefer not to maintain a complete list of all possible country names in the database?
A. It is too time-consuming to update regularly
B. Countries never change their names
C. Users might type in localized or misspelled versions of their country names
D. All users spell country names correctly

Q3. How does the instructor suggest handling users' misspellings or variations of country names?
A. By blocking any input that doesn't match the allowed list
B. By updating a lookup table with known misspellings and automatically correcting them
C. By ignoring any input that doesn't match the allowed list
D. By sending users an error message to correct their input

Q4. What type of query is used in the video to correct known misspellings of country names?
A. An append query
B. A delete query
C. An update query
D. A make-table query

Q5. What does the instructor emphasize about using a table without an ID field for this substitution process?
A. It's common practice for all database tables
B. It's a rare exception for situations that don't require relationships
C. It's a recommended practice for all lookup tables
D. It's essential for maintaining data accuracy

Q6. After correcting known misspellings using the described method, what is suggested as the next step?
A. Deleting all entries that are still wrong
B. Finding and addressing unknown misspellings in the next class
C. Requesting users to re-enter their data
D. Locking the corrected entries to prevent future changes

Q7. What is the main reason for setting a default country value in the database, as the instructor mentions?
A. To handle cases where a user's country is unknown (null)
B. To avoid null entries appearing in user output
C. To prevent users from entering any country name
D. To enforce a single country entry for all users

Q8. In the context of the video, what does the instructor identify as an issue with certain special characters in country names?
A. They are always handled correctly by the database
B. They can appear as question marks in the database
C. They enhance the readability of the names
D. They do not affect data processing in any way

Answers: 1-B; 2-C; 3-B; 4-C; 5-B; 6-B; 7-A; 8-B

DISCLAIMER: Quiz questions are AI generated. If you find any that are wrong, don't make sense, or aren't related to the video topic at hand, then please post a comment and let me know. Thanks.