Databases Flashcards
A(n) _________ database is used to collect, modify, and maintain data on a daily basis.
B:operational
A(n) _________ database is used to collect data that will be used for spotting trends that offer insights for tactical and strategic business decisions.
C:analytical
Access to databases is usually open to anyone within an organization or business.
False
In a database, a(n) __________ contains the smallest unit of meaningful information
B:field
In a relational database, relationships are specified by joining common data stored in records from different tables.
True
Enterprise database applications tend to have some flexibility for customization,
True
A(n) _________ sort uses one field, to arrange records. A(n) _________ sort arranges information by more than one field.
A:single-level, multi-level
The acronym ____________ refers to software that manages data stored in a database.
D:DBMS
FileMaker Pro and Microsoft Access are DBMSs.
True
A(n) _______________ is a field that contains data unique to a record.
C:primary key
In a case-sensitive database, uppercase letters are equivalent to their lowercase counterparts.
False
The goal of normalization is to minimize data redundancy.
True
SQL works behind the scenes as an intermediary between the database client software provided to users and the database itself.
True
Relational databases store unstructured data.
False
