Intro to DBMS

Which of the following are disadvantages of a traditional file-based system?

• Data redundancy

• Data integrity

• Concurrency

• Additional hardware cost

• Data inconsistency

Application programs that perform services for the end users where each program defines and manages its own data

• File systems

• Database systems

• File-based systems

• Application software

This is incredibly important for any business but the data will serve no purpose unless there is a way to organize it into usable information.

• Data mining

• Database

• Data collection

• Data analysis

These can be facts, figures, statistics, and numbers

• Information

• Statistics

• Census

• Data

• Knowledge

Highest value can be achieved from what level in the knowledge pyramid?

• Data

• Wisdom

• Knowledge

• Information

• Action

Which of the following are roles of a database in a business?

• Analyze data for reports

• Enables transforming data

• Collect data in a central place

• Produce data required for business

A database is a collection of ____ data.

Data in a vacuum (without context) is ____

• worth it

• useful

• meaningless

• processed

Databases should represent some aspects of the real world or a collection of data elements representing real-world information

• False

• True

• Partially False

A data item is stored in a column, which is also called

• a table

• a record

• a field

• an element