Deck 5: Database Systems and Applications

Question 1

In the context of relational database model, selecting involves combining two or more tables.

Answer 1

False

Question 2

A database management system (DBMS) serves as an interface between an application program and a database.

Answer 2

True

Question 3

When organizing a database, one of the key considerations includes determining who will have access to the collected data.

Answer 3

True

Question 4

In the relational model, each row in a table represents an entity, and each column represents an attribute of that entity.

Question 5

To use the database approach to data management, no additional software is required.

Question 6

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 7

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

Question 8

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

Question 9

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

Question 10

In the context of relational database model, projecting involves eliminating columns in a table.

Question 11

A database must reflect the business processes of an organization.

Question 12

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.

Question 13

Often, distinct yet related databases are linked to provide enterprise-wide databases.

Question 14

A field is typically a name, number, or combination of characters that describes an aspect of a business object.

Question 15

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

Question 16

A collection of data fields all related to one object, activity, or individual is called a file.

Question 17

The relational database model is currently the most widely used.

Question 18

Two sets of fields can have a common primary key.

Question 19

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

Question 20

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

Question 21

A _____ 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 22

Basic data manipulations include _____ that involves eliminating rows in a relational database according to certain criteria.

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

Question 23

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

Question 24

The smallest piece of data used by a computer is a(n) _____.

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

Question 25

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

Question 26

A database is a collection of integrated and related _____.

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

Question 27

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

Question 28

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

Question 29

Online analytical processing and data mining are essentially the same thing.

Question 30

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 31

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

Question 32

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) foreign key
D) data attribute

Question 33

Which of the following statements is true of a database?

A) It is accessed primarily for use by an organization's database administrator and data administrator.
B) It provides an essential foundation for an organization's knowledge management and artificial intelligence systems.
C) It is a collection of unstructured data.
D) It helps companies analyze information to open new market opportunities.

Question 34

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

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

Question 35

A database administrator is an important nontechnical position 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 36

Online analytical processing involves the automated discovery of patterns and relationships in a data warehouse.

Question 37

Each attribute in a relational database model can be constrained to a range of allowable values called a _____.

A) bandwidth
B) scope
C) slot
D) domain

Question 38

_____ is an approach that starts by investigating the general data and information needs of an organization at the strategic level and then examines more specific data and information needs for the functional areas and departments within the organization.

A) Data selecting
B) Enterprise data modeling
C) Data cleansing
D) Social graph analysis
​

Question 39

Competitive intelligence is espionage.

Question 40

Unstructured data comes from sources such as word-processing documents and scientific research.

Question 41

_____ are quantifiable measurements that assess progress toward organizational goals and reflect the critical success factors of an organization.

A) Business intelligence matrices
B) Social graphs
C) Key performance indicators (KPIs)
D) Dashboards

Question 42

_____ is a special-purpose programming language for accessing and manipulating data stored in a relational database.

A) Query by Example (QBE)
B) Access
C) Structured Query Language (SQL)
D) Java

Question 43

_____ is the term used to describe enormous and complex data collections that traditional data management software, hardware, and analysis processes are incapable of dealing with them.

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

Question 44

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 45

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

Question 46

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 (DML)

Question 47

Social graph analysis is a(n) _____ technique in which data is represented as networks where the vertices are the individual data points (social network users) and the edges are the connections among them.

A) data mining
B) online analytical processing
C) data visualization
D) predictive analysis

Question 48

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

Question 49

The term _____ 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 50

A _____ is a description that involves "telling" the database management system (DBMS) the logical and physical structure of the data and the relationships among the data for each user.

A) query
B) record
C) schema
D) field

Question 51

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

A) Business intelligence
B) Social graph analysis
C) Online analytical processing
D) Predictive analysis

Question 52

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 53

The position of a _____ is a nontechnical 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 54

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

A) data dictionary
B) schema
C) data definition language
D) data manipulation language

Question 55

Most of the data that an organization must deal with is _____ data, meaning that it is not organized in any predefined manner.

Question 56

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

A) Database normalization
B) Online analytical processing (OLAP)
C) Data warehousing
D) Data mining

Question 57

A(n) ______ 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 58

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

Question 59

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

A) Data mining
B) Counterintelligence
C) Competitive intelligence
D) Enterprise data modeling

Question 60

A _____ is a subset of a data warehouse that is used by small- and medium-sized businesses and departments within large companies to support decision making.

A) data dictionary
B) data model
C) data mart
D) data mine

Question 61

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

Question 62

The _____ model has become the most popular database model.

Question 63

In the context of a database management system (DBMS), a(n) _____ interacts with other programs or applications and only indirectly interacts with people or users.

Question 64

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

Question 65

A(n) _____ is designed to store and retrieve data in a manner that does not rigidly enforce the atomic conditions associated with the relational database model in order to provide faster performance and greater scalability.

Question 66

A(n) _____ is a diagram of entities and their relationships.

Question 67

In a relational database model, the range of allowable values for a data attribute is called its _____.

Question 68

A business intelligence _____ is a data visualization tool that displays the current status of the key performance indicators (KPIs) for an organization.

Question 69

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

Question 70

Data modeling done at the level of an entire enterprise is called _____.

Question 71

Oracle, IBM DB2, Microsoft SQL Server, Microsoft Access, MySQL, and Sybas are databases based on the _____ model.

Question 72

In a relational database model, _____ involves combining two or more tables.

Question 73

_____ is a method of dealing with a situation in which two or more users or applications need to access the same record at the same time.

Question 74

A(n) _____ is a collection of instructions and commands used to define and describe data and relationships in a specific database.

Question 75

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

Question 76

_____ is the process of detecting and then correcting or deleting incomplete, incorrect, inaccurate, irrelevant records that reside in a database.

Question 77

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

Question 78

A(n) _____ is a database management system that stores the entire database in random access memory (RAM).

Question 79

A(n) _____ is a detailed description of all data used in a database.

Question 80

The _____ is a specific language, provided with a database management system (DBMS) that allows users to access and modify the data, to make queries, and to generate reports.