Introduction to Databases | Practice Test / Quiz / MCQs

Home > Databases > Quizzes > Introduction to Databases

Introduction to Databases

Fast practice, instant feedback. Timer auto-submits when time’s up.

Avg score: 84% • Most missed: “Define the term “Database”.”

A database is an organized collection of structured information, or data, typically stored electronically in a computer system. A database is usually controlled by a database management system (DBMS).

Introduction to Databases

Time left 00:00

25 Questions

1. Explain what a Document database is.

soilA (usually nonprocedural, declarative) language that is supported by a DBMS to express queries, to insert data, to modify the database structure, and to manage access rights. An example of a query language is SQL.A technique that helps to reduce the occurrence of data anomalies and poor data integrity. It leads to an optimized database structure with better control for data management operations.These databases work best if you need a flexible schema. The data is stored in XML or JSON format. You can live with high read performance and can balance read performance with write performance. You can use indexes to maximize your performance with these databases. Examples: MongoDB, DynamoDB, Couchbase.

2. Data is the new [...].“ - David McCandless 2010

3. What is Normalization, in the context of the Database Life Cycle?

A technique that helps to reduce the occurrence of data anomalies and poor data integrity. It leads to an optimized database structure with better control for data management operations.soilA (usually nonprocedural, declarative) language that is supported by a DBMS to express queries, to insert data, to modify the database structure, and to manage access rights. An example of a query language is SQL.These databases work best if you need a flexible schema. The data is stored in XML or JSON format. You can live with high read performance and can balance read performance with write performance. You can use indexes to maximize your performance with these databases. Examples: MongoDB, DynamoDB, Couchbase.

4. What is the objective of a query language?

soilThese databases work best if you need a flexible schema. The data is stored in XML or JSON format. You can live with high read performance and can balance read performance with write performance. You can use indexes to maximize your performance with these databases. Examples: MongoDB, DynamoDB, Couchbase.A (usually nonprocedural, declarative) language that is supported by a DBMS to express queries, to insert data, to modify the database structure, and to manage access rights. An example of a query language is SQL.A technique that helps to reduce the occurrence of data anomalies and poor data integrity. It leads to an optimized database structure with better control for data management operations.

5. What is Conceptual Database Design, in the context of the Database Life Cycle?

'The process that yields the description of the database structure and determines the database components. The Conceptual Data Model comprises business level analysis and design, and yields an abstract data model, independent from any technical realization. It ''faithfully mirrors the operations of the organisation, flexible enough to allow changes as new info needs arise, supports different user views''.'A technique that helps to reduce the occurrence of data anomalies and poor data integrity. It leads to an optimized database structure with better control for data management operations.These databases work best if you need a flexible schema. The data is stored in XML or JSON format. You can live with high read performance and can balance read performance with write performance. You can use indexes to maximize your performance with these databases. Examples: MongoDB, DynamoDB, Couchbase.soil

6. What is Physical Database Design, in the context of the Database Life Cycle?

Defines how data is stored and managed by the database management system (DBMS).A technique that helps to reduce the occurrence of data anomalies and poor data integrity. It leads to an optimized database structure with better control for data management operations.soilThese databases work best if you need a flexible schema. The data is stored in XML or JSON format. You can live with high read performance and can balance read performance with write performance. You can use indexes to maximize your performance with these databases. Examples: MongoDB, DynamoDB, Couchbase.

7. What is Scoping, in the context of the Database Life Cycle?

These databases work best if you need a flexible schema. The data is stored in XML or JSON format. You can live with high read performance and can balance read performance with write performance. You can use indexes to maximize your performance with these databases. Examples: MongoDB, DynamoDB, Couchbase.soilA technique that helps to reduce the occurrence of data anomalies and poor data integrity. It leads to an optimized database structure with better control for data management operations.Scoping is about knowing the requirements domain, and analysing the user environment to determine relevance, importance and priorities for the resulting data model.

8. Name three functions of a relational database (as defined by Edgar Codd).

soilA technique that helps to reduce the occurrence of data anomalies and poor data integrity. It leads to an optimized database structure with better control for data management operations.Select 3 out of these 9: Integration: uniform, non-redundant data management Operations: Create, Read, Update, Delete (CRUD operations) Catalog (Data Dictionary / Metadata): save data on data User views: separate users have separate views on data Consistence: maintaining data integrity Data security: avoiding unauthorised access Transactions: summarising several database operations to one. Synchronisation: Concurrent user access is possible. Data backup: to enable a restore after a system crash (Crash Recovery)These databases work best if you need a flexible schema. The data is stored in XML or JSON format. You can live with high read performance and can balance read performance with write performance. You can use indexes to maximize your performance with these databases. Examples: MongoDB, DynamoDB, Couchbase.

9. Define the term 'data'.

soilThese databases work best if you need a flexible schema. The data is stored in XML or JSON format. You can live with high read performance and can balance read performance with write performance. You can use indexes to maximize your performance with these databases. Examples: MongoDB, DynamoDB, Couchbase.A technique that helps to reduce the occurrence of data anomalies and poor data integrity. It leads to an optimized database structure with better control for data management operations.Raw facts stored in a database.

10. Name different types (categories) of data.

These databases work best if you need a flexible schema. The data is stored in XML or JSON format. You can live with high read performance and can balance read performance with write performance. You can use indexes to maximize your performance with these databases. Examples: MongoDB, DynamoDB, Couchbase.soilPersonally Identifiable Data (PII) Business data Geo and spatial data Timeseries dataA technique that helps to reduce the occurrence of data anomalies and poor data integrity. It leads to an optimized database structure with better control for data management operations.

11. What are the four basic, principal database operations used in data-driven applications?

soilA technique that helps to reduce the occurrence of data anomalies and poor data integrity. It leads to an optimized database structure with better control for data management operations.Create, Read, Update, and Delete (CRUD) are the four basic operations of persistent storage. They are frequently used in the context of requirement specifications for systems that manage persistent data. Create Read/Retrieve Update DeleteThese databases work best if you need a flexible schema. The data is stored in XML or JSON format. You can live with high read performance and can balance read performance with write performance. You can use indexes to maximize your performance with these databases. Examples: MongoDB, DynamoDB, Couchbase.

12. Name three common problems with file-based storage.

13. What are the ACID properties of database transactions?

soilA technique that helps to reduce the occurrence of data anomalies and poor data integrity. It leads to an optimized database structure with better control for data management operations.Atomicity Consistency Isolation DurabilityThese databases work best if you need a flexible schema. The data is stored in XML or JSON format. You can live with high read performance and can balance read performance with write performance. You can use indexes to maximize your performance with these databases. Examples: MongoDB, DynamoDB, Couchbase.

14. What are some types of Non-relational databases?

Key-value databases Document databases Graph databasesThese databases work best if you need a flexible schema. The data is stored in XML or JSON format. You can live with high read performance and can balance read performance with write performance. You can use indexes to maximize your performance with these databases. Examples: MongoDB, DynamoDB, Couchbase.soilA technique that helps to reduce the occurrence of data anomalies and poor data integrity. It leads to an optimized database structure with better control for data management operations.

15. What are some important features of a Database Management System (DBMS)?

Consistent storage of data (data integrity) Multi-user access and data access protection Backup und Recovery High availability and outage protection Centralized data management providing multiple user perspectives Simple, comprehensive (and standardized) database access language Standardized programming interfacesoilThese databases work best if you need a flexible schema. The data is stored in XML or JSON format. You can live with high read performance and can balance read performance with write performance. You can use indexes to maximize your performance with these databases. Examples: MongoDB, DynamoDB, Couchbase.A technique that helps to reduce the occurrence of data anomalies and poor data integrity. It leads to an optimized database structure with better control for data management operations.

16. Define the objective of a Data Manipulation Language (DML).

A technique that helps to reduce the occurrence of data anomalies and poor data integrity. It leads to an optimized database structure with better control for data management operations.soilContains the set of commands that allows an end user to manipulate the data in the database, such as SELECT, INSERT, UPDATE, DELETE, COMMIT, and ROLLBACK.These databases work best if you need a flexible schema. The data is stored in XML or JSON format. You can live with high read performance and can balance read performance with write performance. You can use indexes to maximize your performance with these databases. Examples: MongoDB, DynamoDB, Couchbase.

17. Name the phases of the Database Life Cycle.

18. Define the term 'Database Management System (DBMS)'.

soilA technique that helps to reduce the occurrence of data anomalies and poor data integrity. It leads to an optimized database structure with better control for data management operations.These databases work best if you need a flexible schema. The data is stored in XML or JSON format. You can live with high read performance and can balance read performance with write performance. You can use indexes to maximize your performance with these databases. Examples: MongoDB, DynamoDB, Couchbase.The collection of programs that manages the database structure and controls access to the data stored in the database. There are multiple products on the market.

19. What is Logical Database Design, in the context of the Database Life Cycle?

These databases work best if you need a flexible schema. The data is stored in XML or JSON format. You can live with high read performance and can balance read performance with write performance. You can use indexes to maximize your performance with these databases. Examples: MongoDB, DynamoDB, Couchbase.Mapping the conceptual model onto a specific data model (e.g. relational), but still independent of the underlying physical storage structure of the database.soilA technique that helps to reduce the occurrence of data anomalies and poor data integrity. It leads to an optimized database structure with better control for data management operations.

20. After the information-level design is completed, [...] is the next step.

These databases work best if you need a flexible schema. The data is stored in XML or JSON format. You can live with high read performance and can balance read performance with write performance. You can use indexes to maximize your performance with these databases. Examples: MongoDB, DynamoDB, Couchbase.soilA technique that helps to reduce the occurrence of data anomalies and poor data integrity. It leads to an optimized database structure with better control for data management operations.After the information-level design is completed, the physical database design is the next step.

21. Define the term 'Database System'.

An organization of components that defines and regulates the collection, storage, management, and use of data in a database environment. Consists of a database management system and one or more databases.soilThese databases work best if you need a flexible schema. The data is stored in XML or JSON format. You can live with high read performance and can balance read performance with write performance. You can use indexes to maximize your performance with these databases. Examples: MongoDB, DynamoDB, Couchbase.A technique that helps to reduce the occurrence of data anomalies and poor data integrity. It leads to an optimized database structure with better control for data management operations.

22. What is a Relational Database?

soilA technique that helps to reduce the occurrence of data anomalies and poor data integrity. It leads to an optimized database structure with better control for data management operations.The most popular all-purpose type of database. It is based on set theory and uses logically related two-dimensional tables (based on columns/rows) and defined operations based on the relational calculus to store information.These databases work best if you need a flexible schema. The data is stored in XML or JSON format. You can live with high read performance and can balance read performance with write performance. You can use indexes to maximize your performance with these databases. Examples: MongoDB, DynamoDB, Couchbase.

23. What does the CAP theorem describe?

A technique that helps to reduce the occurrence of data anomalies and poor data integrity. It leads to an optimized database structure with better control for data management operations.soilThese databases work best if you need a flexible schema. The data is stored in XML or JSON format. You can live with high read performance and can balance read performance with write performance. You can use indexes to maximize your performance with these databases. Examples: MongoDB, DynamoDB, Couchbase.That any distributed (database) system is not capable of safeguarding all of these three properties at the same time: Consistency All systems have the same data view at the same time (This is different compared to the consistency criterion of ACID) Availability Queries against the systems are always answered. Partition tolerance The systems continues to be available even if parts are not available. This incurs a trade-off in distributed system design, as two of the named properties must be prioritized before the remaining one.

24. Define the term 'data dictionary'.

A technique that helps to reduce the occurrence of data anomalies and poor data integrity. It leads to an optimized database structure with better control for data management operations.A DBMS component that contains the logical structure for the information in a database (metadata—data about data). Thus, the data dictionary contains the data definition as well as their characteristics and relationships.These databases work best if you need a flexible schema. The data is stored in XML or JSON format. You can live with high read performance and can balance read performance with write performance. You can use indexes to maximize your performance with these databases. Examples: MongoDB, DynamoDB, Couchbase.soil

25. Explain what a Key/Value database is.

These databases work best with a simple database schema. It is best for many read, writes and few updates. It performs best when there are no complex queries or business logic. Examples: Redis, DynamoDB, Cosmos DB.These databases work best if you need a flexible schema. The data is stored in XML or JSON format. You can live with high read performance and can balance read performance with write performance. You can use indexes to maximize your performance with these databases. Examples: MongoDB, DynamoDB, Couchbase.A technique that helps to reduce the occurrence of data anomalies and poor data integrity. It leads to an optimized database structure with better control for data management operations.soil

⚡ Recently practiced quizzes in this topic

Live quiz activity

DBMS Basics Practice Test: SQL - Queries, Constraints and Triggers Database Fundamentals 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

25 Questions

❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

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.

25 Questions

❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

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.

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