Database Management Quiz

Anna is working on a research project. She gathers numbers and text from surveys. What is she collecting?

• Programs

• Data

• Instructions

• Queries

Your teacher asks you to explain how raw facts can become useful to people. What should you say?

• They remain the same forever

• They are destroyed after use

• They become information after processing

• They become hardware

In a payroll system, employees' names, IDs, and salaries are stored in tables. What type of system is this?

• Hierarchical database

• Relational database

• Object-oriented program

• Flat database

You enter your test scores into a system and receive a summary of top scorers and averages. What did the system give you?

• Raw data

• Information

• Codes

• Files

You’re managing an online store and want to store product images along with item descriptions. Which database type is most appropriate?

• Flat database

• Object-oriented database

• Relational database

• Hierarchical database

If you make a small update to how your data is stored without affecting any apps, what DBMS feature is helping you?

• Data compression

• Data entry

• Data independence

• Data redundancy

Your friend is manually recording customer info repeatedly in different files. What kind of data issue is this?

• Data consistency

• Redundancy

• ACID violation

• Indexing

Your manager wants employees in Sales to see only sales-related data and not HR data. What DBMS feature makes this possible?

• Referential integrity

• Flat file system

• Multiple views

• Metadata

During a system crash, the database still maintains accurate transaction records. Which DBMS feature is responsible?

• Query Language

• Flat file

• ACID Properties

• Data redundancy

A system stores both student names and their photos. This reflects which kind of database?

• Object-oriented

• Flat

• Relational

• Hierarchical