Deck 7: Database Systems

Question 1

Data consists of raw facts, like sales or weather statistics.

Answer 1

True

Question 2

Data integrity means that data stored in the database was accurate when it was entered, but may or may not be accurate now.

Answer 2

False

Question 3

Sky computing refers to accessing data and information services from the Internet utilizing a standard Web-based interface.

Answer 3

False

Question 4

Every field has a field name and must also be assigned a fixed length.

Question 5

Database syntax typically allows field names to include spaces.

Question 6

Transaction files often cause changes to master files.

Question 7

Attributes are usually selected to capture the relevant characteristics of entities.

Question 8

No other record can have the same primary key.

Question 9

Multiple fields can never be combined as a primary key.

Question 10

A centralized database approach increases data redundancy.

Question 11

Data that is inaccurate can be more dangerous to an organization or individual than no data at all.

Question 12

In the relational model, all data elements are placed in three-dimensional tables.

Question 13

Databases are best designed using small, logically interconnected tables to reduce data redundancy.

Question 14

Databases and spreadsheet software can read a .csv file, using the line breaks and commas to interpret the data as a table.

Question 15

Since the Newtonian revolution, scientific inquiry has been defined by experimentation tested by hypotheses.

Question 16

Databases for personal computers are most often designed for a single user.

Question 17

An example of a general-purpose database is QuickBooks, an accounting program for small businesses.

Question 18

Open-source database management systems offer the same advantages as all open-source software: there is strong community support, they are completely customizable, and they are free.

Question 19

To users, distributed databases appear to be several small databases.

Question 20

The high cost of cooling data centers has become a growing concern to environmentalists and business owners.

Question 21

Search engines are based on database technologies. _________________________

Question 22

An important step in creating a database is to establish a data file, a detailed description of all data used in the database. _________________________

Question 23

Together, characters, fields, records, files, and databases form the data hierarchy. _________________________

Question 24

Credit card companies use the customer's credit card expiration date as the primary key. _________________________

Question 25

A home budget software package is an example of a simple data management system. _________________________

Question 26

In a(n) distributed database approach to data management, multiple application programs share a pool of related data. _________________________

Question 27

When inaccurate data is entered into a database, the results are inaccurate output. This is sometimes referred to as garbage in, garbage out. _________________________

Question 28

Primary data is difficult to manage because any required change must be applied to all copies of the data, but a copy is often overlooked and becomes inaccurate. _________________________

Question 29

Object-relational databases combine features of the object-oriented model with the relational model. _________________________

Question 30

Two common data manipulations are selecting data and separating tables. _________________________

Question 31

Division usually involves breaking one table into two or more tables in order to correct a data problem or anomaly. _________________________

Question 32

The most common type of flat file format is called CSV for colon-separated values. _________________________

Question 33

Microsoft Outlook and Quicken are examples of popular single-user DBMSs used to store and manipulate personal data. _________________________

Question 34

MindManager, mind mapping software, is a(n) special-purpose database used to organize projects and people's thoughts and ideas. _________________________

Question 35

A(n) structured database contains data that is difficult or impossible to place in a traditional database system. _________________________

Question 36

A(n) ____ consists of a group of programs that manipulate the database and provide an interface between the database and the user or the database and application programs.

A) DBA
B) DBMS
C) GIGO
D) SQL

Question 37

-The figure above illustrates the data ____.

A) schema
B) hierarchy
C) management system
D) mining system

Question 38

-Referring to the figure above, it is clear that ____ are combined to make a field.

A) characters
B) records
C) files
D) databases

Question 39

A database, a DBMS, and the application programs that utilize the data in the database make up a database ____.

A) system
B) environment
C) either a. or b.
D) neither a. nor b.

Question 40

The functions of a DBMS include all of the following EXCEPT: ____.

A) Ensuring that the data is protected and safe from attacks and unauthorized access
B) Providing artificial intelligence to help with structured and unstructured decisions
C) Storing important data for individuals, groups, and organizations
D) Performing routine tasks

Question 41

Individuals use personal databases to ____.

A) store addresses and contact information
B) keep track of important dates
C) keep track of valuables for possible insurance claims
D) all of the above

Question 42

In a database, characters are put together to form a(n) ____, the smallest practical unit in most databases.

A) field
B) entity
C) key
D) attribute

Question 43

Every field has a field name and a ____ length.

A) fixed
B) variable
C) either a. or b.
D) neither a. nor b.

Question 44

A collection of related records is a file, also called a ____ in some databases.

A) table
B) chart
C) set
D) query

Question 45

____ files are permanent database files that are updated over time.

A) Programmed
B) Unprogrammed
C) Master
D) Transaction

Question 46

____ files are temporary files that hold data that needs to be processed.

A) Programmed
B) Unprogrammed
C) Master
D) Transaction

Question 47

Fields are combined to make a ____.

A) file
B) database
C) record
D) character

Question 48

Examples of ____ include music CDs, the contents of an apartment, employees, inventory, and customers.

A) keys
B) entities
C) properties
D) attributes

Question 49

Most organizations store data about entities, which are represented as ____ in a database.

A) records
B) fields
C) characters
D) parameters

Question 50

A(n) ____ is a characteristic of an entity.

A) key
B) attribute
C) field
D) record

Question 51

Employee number, last name, first name, hire date, and department number are ____ for an employee.

A) attributes
B) keys
C) characters
D) entities

Question 52

Federal databases often include the results of DNA tests as a(n) ____ in databases of convicted criminals.

A) attribute
B) key
C) character
D) entity

Question 53

A(n) ____ is a field in a record that is used to identify the record.

A) key
B) entity
C) character
D) attribute

Question 54

You can use ____ information managers to keep track of phone numbers, addresses, Web sites, and e-mail addresses.

A) personal
B) individual
C) private
D) pocket

Question 55

All of the following are benefits of a centralized database approach EXCEPT: ____.

A) Reduced data redundancy
B) Improved data integrity
C) Easier modification and updating
D) Data and program dependence

Question 56

All of the following are benefits of a centralized database approach EXCEPT: ____.

A) Better access to data and information
B) Individualized methods of data access
C) Better overall protection of the data
D) Shared data and information resources

Question 57

In building a database, careful consideration must be given to all of these questions EXCEPT: ____.

A) Content: Who will be responsible for writing the content?
B) Access: What data is to be provided to which users when appropriate?
C) Logical structure: How is the data to be arranged so that it makes sense to users?
D) Physical organization: Where is the data to be physically located?

Question 58

The object-oriented model encapsulates ____ functionality in software objects.

A) data
B) database functionality
C) both a. and b.
D) neither a. nor b.

Question 59

The database model that is by far most popular is the ____ model.

A) network
B) object-oriented
C) relational
D) hierarchical

Question 60

The tables in relational databases organize data in ____, simplifying data access and manipulation.

A) rows
B) columns
C) both a. and b.
D) neither a. nor b.

Question 61

____ involves choosing data based on certain criteria.

A) Selecting
B) Choosing
C) Picking
D) Getting

Question 62

____ involves combining two or more tables.

A) Combining
B) Joining
C) Adding
D) Transitioning

Question 63

The ability to connect data in different tables through a common field is sometimes referred to as a ____.

A) relationship
B) friendship
C) dependency
D) network

Question 64

-Referring to the figure above, an example of a primary key would be ____.

A) 005-10-6321
B) Hassam
C) 257
D) 10-7-2003

Question 65

-Referring to the figure above, the attributes of the entities shown in the table are ____.

A) last name
B) first name
C) hire date
D) all of the above

Question 66

-Referring to the figure above, the entities in the table are the ____.

A) employees
B) company
C) employee numbers
D) employee hire dates

Question 67

Relationships between tables can be illustrated through a(n) ____ relationship diagram.

A) entity
B) database
C) attribute
D) key

Question 68

The 1 and infinity symbols used on the relationship lines of a database indicate a special kind of relationship called a ____ relationship.

A) one-to-infinity
B) one-to-many
C) many-to-many
D) one-to-one

Question 69

Good data should be all of these EXCEPT: ____.

A) redundant
B) flexible
C) simple
D) adaptable to different applications

Question 70

The process of correcting data problems or anomalies is called ____.

A) normalization
B) equalization
C) transition
D) calculation

Question 71

____ of data is a measure of the changes, such as additions, deletions, or modifications, typically required in a given period of time.

A) Normalization
B) Depth
C) Breadth
D) Volatility

Question 72

____ of data is a measure of how rapidly changes must be made to data.

A) Urgency
B) Immediacy
C) Control
D) Timing

Question 73

A ____ file database typically stores each record as a line of text, and uses commas, tabs,
Or other indicators within the line to separate the fields within the record.

A) flat
B) special-purpose
C) general-purpose
D) relationship

Question 74

____ science is a line of inquiry that applies mathematical analysis and statistics to large amounts of data to interpret the relationship between natural phenomena.

A) Hypotheses-driven
B) Data-driven
C) either a. or b.
D) neither a. nor b.

Question 75

Most businesses require multiuser DBMSs that allow multiple employees to access and edit data simultaneously. These are typically referred to as database ____ platforms since they allow you to create a database and a DBMS for accessing and manipulating data in the database.

A) development
B) creation
C) application
D) storage

Question 76

Oracle, Sybase, and IBM databases are examples of ____ database software that can be used by most organizations for many different types of applications.

A) special-purpose
B) general-purpose
C) industry-specific
D) relationship-specific

Question 77

A(n) ____ database is designed for one purpose or a limited number of applications.

A) special-purpose
B) general-purpose
C) industry-specific
D) relationship-specific

Question 78

One study found that the open-source DMBS MySQL is deployed ____ percent more frequently that Oracle, SQL Server, or DB2.

A) 10
B) 20
C) 30
D) 40

Question 79

Before data can be stored, manipulated, and retrieved, the database must be logically designed. At a minimum, this requires field, record, and ____ design.

A) chart
B) table
C) entity
D) report

Question 80

The field type that holds alphanumeric or character data includes characters or numbers that ____.

A) can be manipulated or used in calculations
B) cannot be manipulated or used in calculations
C) both a. and b.
D) neither a. nor b.