Home > Databases > Quizzes > Database Fundamentals
Database Fundamentals
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 35% • Most missed: “The plural of Criterion”
Database Fundamentals
Time left 00:00
25 Questions

1. A collection of relations

2. The portion of the Query Design window in Access where you enter fields or criteria or sort orders and so on

3. When sorting on two fields this is the more important field

4. A data manipulation language for relational databases in which users indicate the action to be taken by completing on-screen forms

5. Duplication of data or the storing of the same data in more than one place.

6. The process of creating collections of records that share some common characteristics

7. A structure that satisfies the properties required to be a relation with the exception of allowing repeating groups

8. A person or place or object or event or idea for which you want to store and process data

9. A screen object you use to maintain or view and print data from a database

10. A database has integrity if the data in it satisfies all established integrity constraints

11. A field whose value is computed from other fields in the database

12. A structure that satisfies the properties required to be a relation with the exception of allowing repeating groups

13. Two tables are union compatible if they have the same number of fields and if their corresponding fields have identical data types

14. A relational data manipulation language in which new tables are created from existing tables through the use of a set of operations

15. When sorting on two fields - the less important field

16. A collection of relations

17. The part of an SQL SELECT command that indicates grouping

18. The SQL command used to delete a table

19. Two simple criteria in a query the are combined with the AND or OR operators

20. A function used to calculate the number of entries and the sum or average of all the entries in a given column or the largest or smallest of the entries in a given column

21. A two-dimensional table-style collection of data in which all entries are single-valued - each column has a distinct name and all the values in a column are values of the attribute that is identified by the column name - and the order of the columns

22. The property that lets you change the structure of a database without requiring you to change the programs that access the database

23. A word that is part of the SQL language

24. An index built on a single field

25. A question the answer to which is found in the database

⚡ Recently practiced quizzes in this topic
Live quiz activity
DBMS Basics Practice Test: SQL - Queries, Constraints and Triggers Transact-SQL (T-SQL) Practice Test PostgreSQL Fundamentals Test SQL Server Vocab Redis Practice Test (NoSQL) DBMS Basics Practice Test: Indexing and Hashing Database Management System (DBMS) Practice Test: All Topics SQL Fundamentals Test SQL MCQs MariaDB Practice Test
 
❤ 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.