Database Concepts Quiz

Which of the following best defines a relational database?

• A database with only one table

• A database that stores data in a hierarchical structure

• A database that uses linked tables with relationships

• A collection of unstructured data files

What is a flat-file database?

• A collection of interrelated tables

• A single table used to store data

• A database that supports complex relationships

• A document storage system

What is the role of a primary key in a relational database?

• To ensure data consistency

• To link tables through relationships

• To uniquely identify a record

• To store encrypted data

Which of the following is an example of a foreign key?

• A unique identifier in a table

• An attribute that links to a primary key in another table

• A composite key

• An attribute used for indexing

What is the purpose of a secondary key?

• To serve as a backup for the primary key

• To provide an alternative way to access data

• To link tables in a database

• To ensure data integrity

Which of the following best describes entity relationship (ER) modelling?

• Designing a web-based interface

• Creating flowcharts for software development

• Representing data entities and their relationships

• Writing SQL queries

What is the main purpose of database normalization?

• To secure the database from hackers

• To reduce data redundancy and improve efficiency

• To increase storage capacity

• To create more database tables

What is an index in a database?

• A backup of the entire database

• A pointer used to quickly locate data

• A table storing system logs

• A process for encrypting sensitive data

Which method is used to capture data automatically from physical documents?

• OCR (Optical Character Recognition)

• Manual data entry

• Data mining

• Data encryption

What is data validation?

• Verifying user identities

• Ensuring data is entered in the correct format