Home > FBLA > Quizzes > FBLA Database Design & Applications Test
FBLA Database Design & Applications Test
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 39% • Most missed: “Which one of the following data types should be used for a primary key in a data…”
FBLA Database Design & Applications Test
Time left 00:00
25 Questions

1. Which one of the following albums is most popular according to the Purchases table?
2. A 'top value query would help to answer which one of the following questions?
3. Which one of the following database report features allows you to specify, 'In my report, I want the name of any salesperson that generates more than $750 in sales to be printed in light green letters, italic type, and underlined?
4. In Joe's database, there is a lot of repeated data. Joe has a list of students and their teachers. The problem is that some students have the same teacher more than once. What is the solution?
5. A primary key consists of information in ________ column(s)that can uniquely identify a record.
6. Preventing multiple applications from obtaining copies of the same record when the record is about to change is called ________.
7. What data type is an autonumber?
8. Reports often contain ________, which visually depict the numerical data.
9. Access reports can be viewed in which three views?
10. The asterisk (*) in a SQL statement means
11. The _________ built-in function in SQL allows you to total the values in a numeric field.
12. In a form, the triangle pointing right navigation button:
13. What is the term for a field in a table that points to the primary key of another table?
14. Which one of the following WHERE clauses would show all last names that start with the letter 'S?
15. A rule that requires that the values in a foreign key must have a matching value in the primary key to which the foreign key corresponds, is called:
16. Many people who want to put together a 'Database can manage to do it in a single Excel worksheet. Which one of the following scenarios does not warrant migration to an Access Database instead of Excel?
17. An index in a MySQL database helps to:
18. A new record is added to an 'employees table. As a result, new entries are automatically populated into tables 'Retirement, 'Taxes and 'Security. Which one of the following is responsible for the additional entries?
19. A(n) ______ join is the default join and selects only those records from both tables that have a matching value in the fields that are joined.
20. Which of the following is true about a relation?
21. In SQL, the _________ keyword will allow you to select records based on partial values.
22. You create a parameter by enclosing a value in a criterion like which one of the following examples?
23. All of the following can be added to a report except
24. Some DBMS require text to be enclosed in
25. The following statement is an example of

⚡ Recently practiced quizzes in this topic
Live quiz activity
FBLA Intro to Business Test FBLA Economics Test FBLA Journalism Test FBLA Introduction To Information Technology Test FBLA Insurance & Risk Management Test FBLA Advertising Test FBLA Agribusiness FBLA Parliamentary Procedure Terms FBLA Insurance & Risk Management Test 2 FBLA Personal Finance Test 2
 
❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

🌈  Our mission is to help improve your scores in any subject and exam withonline quizzes, practice tests, study guides, & advice for students. Since 2018.
About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | OSHA Basics Quiz | What Should We Know?
Privacy | Terms |
Without work one finishes nothing. - Ralph Waldo Emerson
© 2026 Fatskills.com

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.