Chapt 25 Flashcards
____________ is a question that can be answered from the contents of a database
A query
A _______ is a formatted list of the information in one or more database files
Report
A ________ database stores all information in a single table
Flat file
_______ is suitable if all of the information you need to track is closely related
Flat file database
if you need to relate different types of information to each other, such as customers, purchases, suppliers, and shippers, using a ___________ is a better choice.
Relational database
A _______________ is one in which two or more tables are related to each other through a common field that is unique to each record
A relational database
A table type that supports saving or completely rolling back a transaction is referred to as _______
Transaction safe
_________ refers to the ability of a database to handle increasing numbers of records, users, and transactions
Scalability
the InnoDB database engine now standard in MySQL can support up to _____ of data
64Tb
the MyISAM database engine, also supported by MySQL, supports up to ______ of data
256Tb
________ are generally faster when many transactions and lookups are required
Nonrelational databases
the three factors (3Vs) in “big data,” are:
Variety, velocity, volume
______ refers to how quickly data can be accessed, updated, and analyzed.
Velocity
______ refers to the amount of data stored
Volume
In a spreadsheet program such as Microsoft Excel or LibreOffice/OpenOffice Calc, the first row is generally the ________ for the database and each row after the first is a record
Field label
