Deck 3: Database Systems, Data Warehouses, and Data Marts

Question 1

The use of the OR operator in a query form, when using query by example (QBE), means that only one of the conditions must be met.

Answer 1

True

Question 2

A select operation pares down a table in a relational database by eliminating columns according to certain criteria.

Answer 2

False

Question 3

A database engine converts logical requests from users into their physical equivalents by interacting with other components of the database management system (DBMS).

Answer 3

True

Question 4

Business intelligence (BI) uses scorecards and dashboards to support decision-making activities, whereas business analytics (BA) uses data mining tools and predictive modeling.

Question 5

Disks are sequential access devices, whereas tapes are random access devices.

Question 6

A__________converts logical requests from users into their physical equivalents by interacting with other components of the database management system (DBMS).

A) database engine
B) data-driven site
C) static site
D) database mine
E) Select

Question 7

Which of the following statements is true of big data?

A) It eliminates unethical actions based on interpretations.
B) It can be efficiently processed and managed by conventional computing methods.
C) It has three dimensions, which are value, density, and uniformity.
D) It is the result of the exponential growth of data in both public and private organizations.

Question 8

A _____ is usually a smaller version of a data warehouse, used by a single department or function.

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

Question 9

Labor and population statistics are examples of sources for internal data that are accessed by a database.

Question 10

A network model is similar to a hierarchical data model because in both data models records are organized in the same way.

Question 11

In contrast to the query languages used to interact with a relational database, interaction with an object-oriented database takes places via methods, which are called by sending a message to an object.

Question 12

In the context of the data administration component of a database management system (DBMS), the acronym CRUD stands for _____.

A) create, read, update, and delete
B) copy, revise, undo, and define
C) create, repeat, undo, and develop
D) copy, read, update, and define

Question 13

Static Web sites are useful for e-commerce sites that need frequent updates.

Question 14

In comparison with a flat file system, _____ in a database.

A) storage space is reduced
B) programs and data are interdependent
C) complex requests cannot be handled easily
D) data redundancy is introduced

Question 15

With the indexed sequential access method (ISAM), records cannot be accessed randomly.

Question 16

Consolidating information from different departments or functional areas is easier in data marts than in data warehouses.

Question 17

Data in a database is used for analytical purposes, whereas data in a data warehouse is used for capturing and managing transactions.

Question 18

Although a database can consist of only a single file, it is usually a group of files.

Question 19

A database is a critical component of information systems because any type of analysis that is done is based on data available in the database.

Question 20

Database marketing works by using multivariate analysis, data segmentation, and automated tools to transform marketing from a proactive to a reactive process.

Question 21

The variety dimension of big data refers to the combination of _____.

A) data warehouses and data marts
B) object-oriented data models and relational data models
C) structured data and unstructured data
D) data definition and data manipulation

Question 22

For each database, there:

A) is only one physical view of data.
B) are only two logical views of data.
C) are multiple physical views of data.
D) is only one logical view of data.

Question 23

Business analytics uses _____ to gain insight into data and provide decision makers with information they can act on.

A) predictive modeling
B) dashboards
C) query reports
D) application generators

Question 24

In a(n) _____, nodes with the same parents are called twins or siblings.

A) hierarchical model
B) network model
C) relational model
D) object-based model

Question 25

In the context of database marketing, when a buyer is segmented on the basis of variable psychographics, it explains _____.

A) why the buyer buys a product or service
B) who the buyer is
C) how the buyer buys a product or service
D) where the buyer is

Question 26

Which of the following components of a database management system (DBMS) is responsible for data storage, manipulation, and retrieval?

A) The database storage
B) The data mine
C) The data mart
D) The database engine

Question 27

A _____ acts as an interface to a database, retrieving data for users and allowing users to enter data in the database.

A) data-driven Web site
B) flat Web page
C) stationary Web page
D) static Web site

Question 28

In a relational database model, a(n) _____ pares down a table by eliminating columns according to certain criteria.

A) project operation
B) join operation
C) find operation
D) insert operation

Question 29

In the context of how information is viewed in a database, the _____ involves how data is stored on and retrieved from storage media.

A) physical view
B) logical view
C) rational view
D) analytical view

Question 30

Which of the following approaches to set up a distributed database management system (DDBMS) combines the fragmentation approach and the replication approach?

A) The optimization approach
B) The allocation approach
C) The encapsulation approach
D) The normalization approach

Question 31

__________tools are capable of "drilling up," proceeding from the smallest unit of data to higher levels.

A) Online analytical processing
B) Online transaction processing
C) Extraction, transformation, and loading
D) Business analytics
E) Select

Question 32

Which of the following is a key factor that has contributed to the growth and popularity of big data?

A) Implosion in data growth
B) Brick and mortar businesses
C) Mobile and wireless technology
D) Exponential decay of organizational data

Question 33

In data warehouses, _____ is information about data-its content, quality, condition, origin, and other characteristics.

A) metadata
B) big data
C) summary data
D) raw data

Question 34

In the context of segmentation of customers in database marketing,__________is a variable that includes gender, age, income, and marital status.

A) strategical information
B) geographical information
C) psychographic information
D) demographic information
E) Select

Question 35

In a relational database, every record must be uniquely identified by a__________.

A) primary key
B) super key
C) remote key
D) candidate key
E) Select

Question 36

In a(n)__________, records in files are organized and processed in numerical order.

A) sequential access file structure
B) random access file structure
C) indexed access file structure
D) direct access file structure
E) Select

Question 37

Which of the following is an advantage of a database over a flat file system?

A) Hardware and software start-up costs are low when using a database.
B) A database is simple and easy to design.
C) Programs and data are interdependent in a database.
D) A database uses more sophisticated security measures.

Question 38

The _____ component of a database management system (DBMS) is used to add, delete, modify, and retrieve records from a database.

A) data manipulation
B) data generation
C) data definition
D) data administration

Question 39

The _____ dimension of big data refers to the sheer quantity of transactions, measured in petabytes or exabytes.

A) velocity
B) volume
C) area
D) time

Question 40

Which of the following components of a data model describes methods and calculations that can be performed on data, such as updating and querying data?

A) Data structure
B) Operations
C) Integrity rules
D) File structure

Question 41

Which of the following statements is true of database marketing?

A) It works by using univariate analysis to transform marketing from a proactive to a reactive process.
B) It works by utilizing information that can be found outside the organizational database.
C) It makes an organization responsive to the needs of its customers.
D) It allows an organization to resist changes in the marketplace.

Question 42

The _____ stores data types for fields, default values for fields, and validation rules for data in each field.

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

Question 43

In object-oriented databases, grouping objects along with their attributes and methods into a class is called__________.

A) encapsulation
B) fragmentation
C) allocation
D) optimization
E) Select

Question 44

When using query by example (QBE) in the data manipulation component of a database management system (DBMS), the _____ is used when all the conditions in the QBE form must be met.

A) NOT operator
B) AND operator
C) OR operator
D) NOR operator

Question 45

In a(n) _____, each record can have multiple parent and child records.

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

Question 46

The _____ component of a database management system (DBMS) is used for tasks such as backup and recovery, security, and change management.

A) data manipulation
B) data generation
C) data definition
D) data administration

Question 47

__________, used in object-oriented databases, refers to new objects being created faster and more easily by entering new data in attributes.

A) Inheritance
B) Encapsulation
C) Fragmentation
D) Counterbalance
E) Select

Question 48

Data warehouses are sometimes called hypercubes because they _____.

A) are function oriented
B) store multidimensional data
C) capture raw transaction data
D) manage transactions

Question 49

A__________is the structure and organization of data, which involves fields, records, and files.

A) data hierarchy
B) data mart
C) data warehouse
D) data mine
E) Select

Question 50

In a relational database model, a(n) _____ searches data in a table and retrieves records based on certain criteria.

A) insert operation
B) join operation
C) find operation
D) select operation

Question 51

Which of the following components of a database management system (DBMS) is used to design elements of an application using a database, such as data entry screens, interactive menus, and interfaces with other programming languages?

A) The application generation component
B) The application definition component
C) The application administration component
D) The application manipulation component

Question 52

In contrast to data in a database, data in a data warehouse is described as subject oriented, which means that it _____.

A) captures aggregated data
B) manages data transactions
C) focuses on a specific area
D) categorizes based on time

Question 53

Which of the following file structures is similar to a book index that lists page numbers where certain topics can be found?

A) The indexed sequential access method
B) The indexed network access structure
C) The indexed random access file structure
D) The indexed hierarchical access method

Question 54

In a(n)__________, records can be accessed in any order, regardless of their physical locations in storage media.

A) sequential access file structure
B) random access file structure
C) indexed access file structure
D) direct access file structure
E) Select

Question 55

The__________of a database involves how information appears to users and how it can be organized and retrieved.

A) logical view
B) physical view
C) rational view
D) analytical view
E) Select

Question 56

Which of the following types of databases is not limited by the data's physical location?

A) A distributed database
B) A relational database
C) A multi-structured database
D) A semi-structured database

Question 57

In large organizations, database design and management is handled by a__________.

A) database administrator
B) database evaluator
C) database synchronizer
D) database developer
E) Select

Question 58

Which of the following statements is true of a flat file system?

A) Same data can be stored in more than one file.
B) Programs and data are independent.
C) Complex requests can be handled easily.
D) It requires very less storage space.

Question 59

A__________is software for creating, storing, maintaining, and accessing database files.

A) database management system
B) data hierarchical system
C) database modelling tool
D) data warehousing tool
E) Select

Question 60

A _____ is a collection of data from a variety of sources used to support decision-making applications and generate business intelligence.

A) data dictionary
B) data pattern
C) data mine
D) data warehouse

Question 61

In a__________, the relationships among records form a treelike structure.

A) hierarchical model
B) relational model
C) network model
D) spiral model
E) Select

Question 62

In a relational database model, the rows are called _____.

A) tuples
B) attributes
C) branches
D) roots

Question 63

In a relational database model, a _____ is a field in a relational table that matches the primary key column of another table.

A) secondary key
B) foreign key
C) serial key
D) domain key

Question 64

In a data warehouse, _____ is the process of collecting data from a variety of sources and converting it into a format that can be used in transformation processing.

A) extraction
B) transformation
C) optimization
D) aggregation

Question 65

The first step in database design is defining a _____, which determines how data is created, represented, organized, and maintained.

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

Question 66

_____ can be described as using an organization's database of customers and potential customers in order to promote products or services that an organization offers.

A) Database mining
B) Database marketing
C) Data encapsulation
D) Data normalization

Question 67

A database administrator (DBA) is responsible for _____.

A) developing recovery procedures in case data is lost or corrupted
B) keeping an organization's computer network up to date
C) writing computer programs that allow a system to perform a specific task
D) designing and implementing an organization's information systems

Question 68

__________is used to discover patterns and relationships.

A) Data-mining analysis
B) Data mart analysis
C) Data pattern analysis
D) Data-toggling analysis
E) Select

Question 69

In the context of the types of data in a database, which of the following is a source of internal data?

A) Tax records
B) Sales records
C) Distribution networks
D) Economic indicators

Question 70

The advantage of the__________is that both sequential and random access can be used to access records, depending on the number being accessed.

A) indexed sequential access method
B) progressive access method
C) direct random access method
D) random-serialized access method
E) Select

Question 71

In a relational database model, the columns are called _____.

A) attributes
B) tuples
C) branches
D) roots

Question 72

In the context of the input component of a data warehouse, _____ collect, integrate, and process data that can be used by all functional areas in an organization.

A) online analytical processing systems
B) online transaction management systems
C) enterprise resource planning systems
D) data mining analysis systems

Question 73

_____ improves database efficiency by eliminating redundant data and ensuring that only related data is stored in a table.

A) Triangulation
B) Fragmentation
C) Normalization
D) Encapsulation

Question 74

_____ is a component of a data model that defines the boundaries of a database, such as maximum and minimum values allowed for a field, constraints, and access methods.

A) Data structure
B) Schema diagrams
C) Integrity rules
D) File procedure

Question 75

Which of the following statements is true of a database?

A) It allows more than one program to use the same data.
B) It comprises data that cannot be linked.
C) It consists of a segregated set of files.
D) It is a crucial tool for managing overseas subsidiaries.

Question 76

The _____ component of a database management system (DBMS) is used to create and maintain the data dictionary.

A) data manipulation
B) data generation
C) data definition
D) data administration

Question 77

Which of the following statements is true of data marts and data warehouses?

A) Consolidating information from different departments is easier in data marts than in data warehouses.
B) Data marts have more extended scope than data warehouses.
C) Access to data is often slower in data marts than in data warehouses.
D) Data marts usually perform the same types of analysis as data warehouses.

Question 78

In the context of the types of data in a database, which of the following is a source of external data?

A) Tax records
B) Sales records
C) Transaction records
D) Personnel records

Question 79

The _____ method for accessing files is effective when a large number of records are processed less frequently, perhaps on a quarterly or yearly basis.

A) sequential access file structure
B) random access file structure
C) indexed sequential access
D) physical view access

Question 80

To begin designing a relational database, you must define the _____ by defining each table and the fields in it.

A) physical structure
B) logical structure
C) primary key
D) foreign key