Deck 5: Database Systems, Data Centers, and Business Intelligence

Question 1

The relational model describes data using a standard tabular format; all data elements are placed in three-dimensional tables called relations, which are the logical equivalent of files.

Answer 1

False

Question 2

The specific value of an attribute is called a data entity.

Answer 2

False

Question 3

An attribute is a general class of people, places, or things for which data is collected, stored, and maintained.

Answer 3

False

Question 4

Selecting involves combining two or more tables.

Question 5

One of the final steps in installing and using a large database involves "telling" the DBMS the logical and physical structure of the data and the relationships among the data for each user.

Question 6

When organizing a database, key considerations include determining what data to collect, who will have access to it, how they might want to use it, and how to monitor database performance.

Question 7

A database, a database management system, and the application programs that use the data make up a database environment.

Question 8

Climate control is an important component of modern data centers..

Question 9

A collection of fields about a specific object is a record.

Question 10

The relational database model is by far the most widely used..

Question 11

Today, few organizations use the database approach to data management, where multiple information systems share a pool of related data.

Question 12

Business and technology vendors are working to develop blue data centers that run more efficiently and require less energy for processing and cooling.

Question 13

A database scientist is a skilled and trained IS professional who directs all activities related to an organization's database, including providing security from intruders.

Question 14

Projecting involves eliminating columns in a table.

Question 15

Oracle is currently the market leader in general purpose databases, with about three-fourths of the multibillion dollar database market.

Question 16

Microsoft built a data center taking up 16 football fields of space filled with 220 shipping containers packed with servers.

Question 17

In the relational model, each row of a table represents a data entity or row and each column of the table represents an attribute or field.

Question 18

Due to their size, databases must be stored on mainframe computers or other large, powerful computers.

Question 19

One of the primary advantages of a relational database is that it allows tables to be linked to reduce data redundancy and allow data to be organized more logically.

Question 20

A data model is a diagram of data attributes and their relationships.

Question 21

A ________ is a climate-controlled building or set of buildings that houses database servers and the systems that deliver mission-critical information and services.

A) data warehouse
B) data center
C) shipping container
D) data hierarchy

Question 22

A collection of fields all related to a single object, activity, or individual is a(n) _____.

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

Question 23

The Database Administrator is an important non-technical responsible for defining and implementing consistent principles for a variety of data issues, including setting data standards and data definitions that apply across all the databases in an organization.

Question 24

A ________ is s field or set of fields in a record that uniquely defines the record.

A) attribute
B) key
C) primary key
D) data item

Question 25

The smallest piece of data used by a computer is the _____.

A) entity
B) byte
C) bit
D) character

Question 26

The DBMS serves as an interface between an application program and the database.

Question 27

As long as the tables in a relational database share one common _____, the tables can be linked to provide useful information and reports.

A) primary key
B) file
C) characteristic
D) attribute

Question 28

Big data refers to large amounts of unstructured data from sources such as the Internet, photos, videos, audio, social networks, and sensors that is difficult to capture, store, and manipulate using traditional database management systems.

Question 29

Predictive analysis is a form of data mining that combines historical data with assumptions about future conditions to predict the outcome of events.

Question 30

Basic data manipulations include _____ which involves eliminating rows in a relational database.

A) selecting
B) joining
C) projecting
D) linking

Question 31

A database is a collection of integrated and related _____.

A) fields
B) attributes
C) records
D) files

Question 32

The DBA must have a clear understanding of the fundamental business of the organization, be proficient in the use of selected database management systems, and stay abreast of emerging technologies and new design approaches.

Question 33

Counterintelligence turns data into useful information that then is kept closely guarded to avoid this information from falling into the hands of the wrong employees.

Question 34

The _____ is a description that involves "telling" the DBMS the logical and physical structure of the data and the relationships among the data for each user.

A) entity relationship diagram
B) data model
C) schema
D) data manipulation language

Question 35

Business intelligence is gained through industrial espionage and the gathering of this information often includes illegal or unethical means.

Question 36

A database _____.

A) is accessed primarily for use by the organization's database administrator and data administrator
B) provides an essential foundation for an organization's knowledge management and artificial intelligence systems
C) is a collection of unstructured data
D) helps companies reduce costs, increase profits, track past business activities, and open new market opportunities

Question 37

A tool that database designers use to show the logical relationships among data is a(n) _____.

A) data model
B) entity-relationship diagram
C) relational model
D) all of the above

Question 38

Data query involves the automated discovery of patterns and relationships in a data warehouse.

Question 39

Online Analytical Processing and data mining are essentially the same thing.

Question 40

A data warehouse stores historical data that has been extracted from operational systems, external sources, and, sometimes, even unique sources.

Question 41

Data warehouses allow managers to _____ to get increasing levels of detail about business conditions.

A) roll up
B) drill down
C) slice and dice
D) extract data

Question 42

With _____, the database is stored on a service provider's server and accessed by the client over a network, typically the Internet.

A) Internet access
B) Database as a Service
C) Software as a Service
D) Oracle

Question 43

A(n) _____ is a field or set of fields that uniquely identifies a record.

Question 44

_____ describes the steps an organization takes to protect information sought by "hostile" intelligence gathers.

A) Data loss prevention
B) Trade secret
C) Counterintelligence
D) Competitive intelligence

Question 45

A form of database that holds a duplicate set of frequently used data and that helps reduce telecommunications costs.

A) Relational
B) Distributed
C) Replicated
D) Virtual

Question 46

Without a well-designed, accurate ______, executives, managers, and others do not have access to the information they need to make good decisions.

Question 47

Developing a seamless integration of databases with the Internet is something called a(n) ______.

A) Web page
B) social network
C) semantic Web
D) business intelligence

Question 48

_____ combines historical data with assumptions about future conditions to predict the outcomes of events.

A) Business intelligence
B) Data mining
C) Online analytical processing
D) Predictive analysis

Question 49

Together, bits, characteristics, fields, records, files, and databases form the ______.

Question 50

_____ is an information-analysis tool that involves the automated discovery of patterns and relationships in a data warehouse.

A) Data mining
B) DBMS
C) Competitive intelligence
D) Data loss prevention

Question 51

______ is a form of database processing that supports top-down, query-driven data analysis.

A) Distributed databases
B) Online analytical processing (OLAP)
C) Data warehousing
D) Data mining

Question 52

A ______ consists of a group of programs that manipulate the database and provide an interface between the database and its users and other application programs.

Question 53

_____ represents huge amounts of unstructured data that is difficult to capture, store, and manipulate using traditional database management systems.

A) Data warehouse
B) Datamart
C) Big data
D) Knowledge base

Question 54

______ is a collection of instructions and commands used to define and describe data and relationships in a specific database.

A) user view
B) schema
C) data definition language
D) data manipulation language

Question 55

A(n) _____ contains a subset of data for a single aspect of a company's business and are used by smaller groups who want to access detailed data for business analysis.

A) OLTP database
B) data warehouse
C) data mart
D) data mine

Question 56

A collection of related records is called a(n) _____.

Question 57

_____ is a standardized data manipulation language developed in the 1970s that allows programmers to use one powerful language and use it on a variety of systems.

A) Query by example
B) Access
C) SQL
D) DML

Question 58

Some databases use ______, which is a visual approach to developing queries and requests.

A) Query by Example (QBE)
B) user views
C) structured query language (SQL)
D) data manipulation language

Question 59

A(n) _____ is a simple database program whose records have no relationship to one another.

A) flat file
B) schema
C) relational system
D) user view

Question 60

The _____ position is a non-technical position responsible for defining and implementing consistent principles for setting data standards and data definitions that apply across all the databases in an organization.

A) data analyst
B) data administrator
C) database administrator
D) data owner

Question 61

A(n) ______ is an individual responsible for defining and implementing consistent principles for a variety of data issues.

Question 62

______ uses virtual servers and operating systems, to allow two or more database systems, including servers and database management systems, to act like a single unified database system.

Question 63

______ use basic graphical symbols to show the organization of and relationships between data.

Question 64

When creating backup databases, some companies use software to eliminate any duplicated data to save storage capacity and reduce costs, an approach some call data ______ .

Question 65

The commands that are used to manipulate the database are part of the _____ language.

Question 66

A(n) ______ is an individual who is expected to have a clear understanding of the fundamental business of the organization, be proficient in the use of selected database management systems, and stay abreast of emerging technologies and new design approaches.

Question 67

The _____ is a collection of instructions and commands used to describe the logical and physical structure of the data and the relationships among the data for each user.

Question 68

_____ lets programmers learn one powerful query language and use it on systems ranging from PCs to the largest mainframe computers.

Question 69

The data _____ is a detailed description of all data used in the database.

Question 70

Developing a seamless integration of databases with the Internet is sometimes called a _____.

Question 71

In the relational data model, each row of a table represents a(n) _____.

Question 72

Traditional data centers consist of warehouses filled with row upon row of ______ racks and powerful cooling systems to compensate for the heat generated by the processors.

Question 73

_____ involves eliminating columns in a table.

Question 74

_____ control can be used to avoid potential problems when two or more users attempt to access the same record at the same time.

Question 75

The _____ data model has become the most popular database model.

Question 76

As data centers continue to expand in terms of the quantity of data that they store and process, their ______ demands are increasing.

Question 77

A description that tells the DBMS the logical and physical structure of the data and the relationships among the data for each user is called a(n) _____.

Question 78

The allowable values for an attribute is called its _____.

Question 79

_____ is a form of data mining that combines historical data with assumptions about future conditions to predict outcomes of events.

Question 80

The purpose of _____ is to develop data that is accurate, complete, economical, flexible, reliable, relevant, simple, timely, verifiable, accessible, and secure.