Informatics: Practice Question

Which of the following database structures utilizes multiple tables queried through Structured Query Language (SQL) with each row in a table having a unique identifier called a primary key?
  1. Relational database
  2. Flat file database
  3. Hierarchical database
  4. Network database
  5. Object oriented database
Show Answer and Explanations

Relational database — Correct answer

Correct. These are the most widely used database management systems. The data is stored in rows and columns in tables. Each row has a unique primary key. Data in one table can relate to another table through a foreign key.

Flat file database

Incorrect. A flat file database is a single table without a primary key, an example is a spreadsheet.

Hierarchical database

Incorrect. A hierarchical database has a parent child tree-like model.

Network database

Incorrect. Network databases are not used much anymore. They are structured like hierarchical databases, and use SQL.

Object oriented database

Incorrect. In an object oriented database, data is not stored in tables. The data is accessed through pointers, or locations in the computer's memory. This database is presently being developed.

Summary

Summary: A relational database is the most commonly used type of database..
Build a Free Exam