Section 1: Database Fundamentals (6-1)
Which represents the smallest unit of data a computer can handle?
b) Bit
Which of the following is a DBMS for desktop systems?
Answer: c) Microsoft Access
Big Data is often characterized by the "3Vs," which are:
Answer: b) Volume, Variety, Velocity
A group of related fields that describes a person, place, or thing is called a:
c) Record
MySQL is an example of:
Answer: b) An open-source DBMS
How much data can a single jet engine generate in 30 minutes?
Answer: c) 10 terabytes
In the data hierarchy, which is the correct order from smallest to largest?
Answer: b) Bit → Byte → Field → Record → File → Database
Which operation in a relational database creates a subset of rows that meet certain criteria?
Answer: c) Select
A database that stores current and historical data for decision makers throughout the company is called a:
Answer: b) Data warehouse
What are the specific characteristics of an entity called?
Answer: c) Attributes
The _____ operation creates a subset consisting of columns in a table.
Answer: b) Project
Data in a data warehouse originate from:
b) Core operational transaction systems
The most common type of database today is:
Answer: c) Relational database
Which operation combines relational tables to provide more information than available in individual tables?
Answer: c) Join
A _____ is a subset of a data warehouse for a specific population of users.
Answer: c) Data mart