LIS ICT 321 DATABASE DESIGN (PRELIM)

What is the primary function of a Database Management System (DBMS)?

• To create and manage databases

• To compile programming code

• To execute mathematical calculations

• To design user interfaces

Data in its raw form, before processing, is called:

• Information

• Database

• Data

• Record

Which of the following is NOT a characteristic of a modern DBMS?

• Query Language

• ACID Properties

• Limited User Access

• Security

Which DBMS property ensures transactions are completed successfully or not at all?

• Atomicity

• Consistency

• Durability

• Isolation

The process of reducing data redundancy in a database is called:

• Normalization

• Optimization

• Serialization

• Aggregation

A collection of related data stored in a structured format is called:

• Spreadsheet

• Database

• Application

• Cache

The structure that contains rows and columns in a database is known as:

• Form

• Table

• Record

• Attribute

A unique identifier for each record in a table is called:

• Foreign Key

• Primary Key

• Composite Key

• Candidate Key

Which relationship type requires a junction table?

• One-to-One

• One-to-Many

• Many-to-Many

• Recursive

In a relational database, a foreign key is used to:

• Ensure data security

• Relate two tables

• Store encrypted information

• Define table structure