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
Each cell in a spreadsheet row after the first row is a ?
Field
Relational database systems often refer to fields as ?
Tuples
DBA
database administrator (DBA)
SAN
Storage area network
_____ is accessed as if it were a local drive by a server but uses fast fiber optic connections
SAN
ACID
ACID (Atomicity, Consistency, Isolation, durability
_______ means that database updates must be entirely completed or rolled back to their previous condition
Atomicity
_______ means that a database transaction cannot make invalid changes to a database
Consistency
_______ means that transactions must be processed independently and the data in a transaction cannot be read until the transaction is complete
Isolation
________ means that the database is designed to store transactions that are completed even if the system crashes afterward.
Durability
________ refers to data that remains available after the process that creates it is finished
Data persistence
