Quiz : Chapter 3 Database

What is a database?

• A collection of unrelated files

• A method for manual data entry

• A collection of related files containing records

• A type of software for managing applications

What does DBMS stand for?

• Database Management Service

• Data Management Base System

• Data Base Management System

• Database Management Software

Which of the following is a popular DBMS?

• Microsoft Word

• Adobe Photoshop

• Google Chrome

• MySQL

What is a primary key in a relational database?

• A unique identifier for each record

• A type of data redundancy

• A key that opens the database

• A method for data encryption

What is one limitation of file-based systems?

• Data is always secure

• Data redundancy

• Data is stored in a centralized location

• Data is easily accessible

What does the term 'data redundancy' refer to?

• Data being duplicated across different programs

• Data being stored in multiple formats

• Data being organized efficiently

• Data being lost or damaged

Which operation creates a subset of records meeting certain criteria?

• Join

• Select

• Update

• Project

What is the purpose of a data dictionary?

• To store user passwords

• To define data elements and their characteristics

• To manage user access

• To create database backups

What is a non-relational database also known as?

• Flat File Database

• NoSQL Database

• SQL Database

• Hierarchical Database

Which of the following is a characteristic of cloud databases?

• Limited to large enterprises

• Always free to use

• Pricing based on usage

• Require physical servers