Deck 3: Database Systems,data Centers,and Business Intelligence

Question 1

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

Answer 1

False

Question 2

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

Answer 2

False

Question 3

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

Answer 3

True

Question 4

The goal of a Structured Query Language (SQL)database is to provide faster performance and greater scalability.

Question 5

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

Question 6

By separating descriptions of the characteristics of an object,activity,or individual,a record can provide a complete description of it.

Question 7

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

Question 8

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

Question 9

A database installed on a personal computer is typically meant for a single user.

Question 10

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

Question 11

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 12

A NoSQL database is highly scalable,meaning that a large database may be distributed across hundreds,thousands,or even tens of thousands of servers running the same NoSQL database management system.

Question 13

Several records can share the same primary key.

Question 14

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

Question 15

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

Question 16

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

Question 17

A field represents a circuit that is either on or off.

Question 18

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

Question 19

A database should be designed to store all data relevant to a business and provide quick access and easy modification.

Question 20

One data cleansing solution is to identify and correct the data by cross-checking it against a validated data set.

Question 21

A business intelligence dashboard cannot be tailored to display metrics targeted for a single point or department.

Question 22

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 23

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 24

A(n)_____ is a person,place,or thing (object)for which data is collected,stored,and maintained.

A) entity
B) record
C) field
D) character

Question 25

Data warehouses keep the same data for long periods of time so the probability that the sources contain "dirty data" is low.

Question 26

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

Question 27

In-memory databases (IMDBs )perform best on multiple multicore central processing units (CPUs)that can process parallel requests to the data.

Question 28

The role of a data administrator is to plan,design,create,operate,secure,monitor,and maintain databases.

Question 29

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

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

Question 30

In a relational database,_____ is the ability to combine two or more tables through common data attributes to form a new table with only the unique data attributes.

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

Question 31

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

Question 32

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

Question 33

A(n)_____ is typically a name,number,or combination of characters that describes an aspect of a business object or activity.

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

Question 34

In a database management system (DBMS),a front-end application interacts with other programs or applications;it only indirectly interacts with people or users.

Question 35

One of the most effective competitive intelligence measures is to define "trade secret" information relevant to a company and control its dissemination.

Question 36

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

Question 37

A(n)_____ is a basic building block of most information,consisting of upper-case letters,lowercase letters,numeric digits,or special symbols.

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

Question 38

_____ is an approach to data management whereby each distinct operational system uses data files dedicated to that system.

A) Company approach to data management
B) Database approach to data management
C) Enterprise approach to data management
D) Traditional approach to data management

Question 39

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

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

Question 40

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 41

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) diagram
B) model
C) schema
D) register

Question 42

_____ fields include the total,average,maximum,and minimum value.

Question 43

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 44

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 45

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 46

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

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

Question 47

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) database manipulation language

Question 48

One of the most effective counterintelligence measures is to define _____ information relevant to a company and control its dissemination.

A) grapevine
B) trade secret
C) public
D) data loss

Question 49

_____ is a data visualization technique in which data is represented as networks where the vertices are the individual data points and the edges are the connections among them.

A) Entity graph analysis
B) Performance analysis
C) Social graph analysis
D) Predictive analysis

Question 50

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

A) Social graph analysis
B) Online analytical processing
C) Data warehousing
D) Data mining

Question 51

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 52

_____ databases rely upon concurrency control by locking database records to ensure that other transactions do not modify the database until the first transaction succeeds or fails,and as a result,can suffer from slow performance.

A) Query by Example (QBE)
B) Access
C) Structured Query Language (SQL)
D) Data manipulation language (DML)

Question 53

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

Question 54

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 55

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 56

_____ 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) Datamart
C) Big data
D) Knowledge base

Question 57

_____ 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 58

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

Question 59

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

Question 60

_____ 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 61

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

Question 62

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

Question 63

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

Question 64

_____ 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 65

The specific value of an attribute,called a(n)_____,can be found in the fields of a record describing an entity.

Question 66

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 67

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

Question 68

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

Question 69

The _____ is a simple but highly useful way to organize data into collections of two-dimensional tables called relations.

Question 70

_____ is an approach to data management where multiple information systems share a pool of related data.
​

Question 71

One of the best ways to gain insights into data is through _____ techniques that can help quickly draw conclusions and see relationships among the data.

Question 72

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

Question 73

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

Question 74

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

Question 75

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

Question 76

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

Question 77

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 78

Small,midsize,and large businesses need _____ database management systems (DBMSs)to share information throughout the organization over a network.

Question 79

The key element in predictive analytics is the _____,one or more variables that can be measured for an individual to predict future behavior.

Question 80

_____ is one aspect of business intelligence and encompasses information about competitors and the ways that knowledge affects strategy,tactics,and operations.