CD115: DATABASE CONCEPTS & DESIGN

What is a database?

• A word processing software

• A system for browsing the internet

• A structured collection of related data

• A spreadsheet

Which of the following is a characteristic of a database system?

• Manual record-keeping

• Unstructured storage

• Data redundancy

• Efficient data management

What does DBMS stand for?

• Data Built Machine System

• Database Model Structure

• Database Management System

• Data Backup Management Software

Which of the following best describes the difference between database and DBMS?

• A DBMS is data itself

• A database stores data, DBMS manages it

• A database is a programming language

• DBMS is used for internet access

Why are database systems important for businesses?

• They prevent electricity loss

• They enhance business intelligence

• They improve office layout

• They are required by law

What is a major disadvantage of the file system?

• High performance

• Low data redundancy

• Data inconsistency

• Centralized management

In file-based systems, data is:

• Managed by DBMS

• Integrated and centralized

• Independent of applications

• Stored in separate files per application

One key benefit of DBMS over file systems is:

• Less secure storage

• More redundancy

• Data integrity and consistency

• Higher cost

Which of the following is not a problem of file systems?

• Data redundancy

• Limited data sharing

• Complex backup

• Easy multi-user access

What is data redundancy?

• Multiple users accessing one file

• Storing the same data in multiple locations

• Making backups of data

• Securing data with encryption