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

Question 1

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

Answer 1

A

Question 2

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

Answer 2

False

Question 3

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

Answer 3

False

Question 4

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

Question 5

Which statement 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 6

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 7

What is one 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 8

Which statement 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 9

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

Question 10

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 11

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

Question 12

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

Question 13

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

Question 14

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 15

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

Question 16

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

Question 17

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

Question 18

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

Question 19

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

Question 20

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

Question 21

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

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

Question 22

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

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

Question 23

In a relational database model,which operation 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 24

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 25

Which component 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 26

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

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

Question 27

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 28

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 29

Which file structure 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 rows are called _____.

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

Question 31

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

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

Question 32

In a relational database model,which operation pares down a table by eliminating columns according to certain criteria?

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

Question 33

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 34

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

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 36

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 37

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

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 41

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 42

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 43

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 44

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

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

Question 45

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 46

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

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

Question 47

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

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

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 statement 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 _____ 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 51

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 52

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

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

Question 53

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 54

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 55

Which component 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)application generation
B)application definition
C)application administration
D)application manipulation

Question 56

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 57

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

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

Question 58

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

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

Question 59

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

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

Question 60

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 61

The _____ view of a database involves how information appears to users and how it can be organized and retrieved.

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

Question 62

Which statement 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 63

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 64

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

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

Question 65

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

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

A)sequential
B)random
C)indexed
D)direct

Question 67

Which 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 68

Which statement 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 69

A data _____ is the structure and organization of data,which involves fields,records,and files.

A)mine
B)mart
C)warehouse
D)hierarchy

Question 70

Which statement 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 71

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

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

Question 72

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 73

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 74

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 75

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 76

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

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

Question 77

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

A)indexed sequential
B)progressive
C)direct random
D)random-serialized

Question 78

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 79

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

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

Question 80

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