Deck 3: Database Systems, Data Warehouses and Data Marts

Question 1

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.

Answer 1

True

Question 2

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

Answer 2

True

Question 3

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

Answer 3

False

Question 4

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

Question 5

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

Question 6

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

Question 7

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 8

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

Question 9

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

Question 10

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 11

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

Question 12

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 13

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

Question 14

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

Question 15

In comparison with flat file systems, databases:

A) minimize data redundancy.
B) are easier to design.
C) have less sophisticated security measures.
D) require more storage space.

Question 16

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 17

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

Question 18

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 19

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

Question 20

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

Question 21

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 22

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 23

In the context of data models, relationships among records in a hierarchical model are called _____.

A) nodes
B) branches
C) roots
D) segments

Question 24

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

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 26

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 27

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

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 29

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 30

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

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

Question 31

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 32

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 33

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 34

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 35

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 36

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

Question 37

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

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

Question 38

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 39

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 40

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 41

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 42

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 43

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 44

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 45

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 46

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 47

Unlike data in databases, data in data warehouses is:

A) function oriented.
B) raw transaction data.
C) collected from a single source.
D) used for analytical purposes.

Question 48

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 49

Which of the following statements is true of distributed databases?

A) They store data on one central server in an organization.
B) They are limited by the data's physical location.
C) In distributed databases, local storage of data increases response time.
D) In distributed databases, local storage of data increases communication costs.

Question 50

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 51

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 52

In the context of the operators used in a query by example (QBE) form, the _____ is used when only one of the conditions in the QBE form must be met.

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

Question 53

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 54

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 55

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 56

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 57

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 58

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 59

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 60

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 61

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 62

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 63

In a _____, the relationships among records form a treelike structure. ​

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

Question 64

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

Question 65

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 66

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

Question 67

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

Question 68

A data hierarchy_____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

Question 69

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

Question 70

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 71

In large organizations, database design and management is handled by a _____. ​

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

Question 72

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

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

Question 74

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 75

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 76

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

Question 77

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 78

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 79

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

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

Question 80

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