Databases Flashcards Preview

CIS 150 > Databases > Flashcards

Flashcards in Databases Deck (14)
Loading flashcards...
1
Q

A(n) _________ database is used to collect, modify, and maintain data on a daily basis.

A

B:operational

2
Q

A(n) _________ database is used to collect data that will be used for spotting trends that offer insights for tactical and strategic business decisions.

A

C:analytical

3
Q

Access to databases is usually open to anyone within an organization or business.

A

False

4
Q

In a database, a(n) __________ contains the smallest unit of meaningful information

A

B:field

5
Q

In a relational database, relationships are specified by joining common data stored in records from different tables.

A

True

6
Q

Enterprise database applications tend to have some flexibility for customization,

A

True

7
Q

A(n) _________ sort uses one field, to arrange records. A(n) _________ sort arranges information by more than one field.

A

A:single-level, multi-level

8
Q

The acronym ____________ refers to software that manages data stored in a database.

A

D:DBMS

9
Q

FileMaker Pro and Microsoft Access are DBMSs.

A

True

10
Q

A(n) _______________ is a field that contains data unique to a record.

A

C:primary key

11
Q

In a case-sensitive database, uppercase letters are equivalent to their lowercase counterparts.

A

False

12
Q

The goal of normalization is to minimize data redundancy.

A

True

13
Q

SQL works behind the scenes as an intermediary between the database client software provided to users and the database itself.

A

True

14
Q

Relational databases store unstructured data.

A

False