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

Question 1

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

Answer 1

False

Question 2

Updating a flat file system is efficient and consumes less time.

Answer 2

False

Question 3

The integrity rules component of a data model defines the boundaries of a database,constraints,and access methods.

Answer 3

True

Question 4

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

Question 5

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

Question 6

The network data model is similar to the hierarchical data model because records are organized in the same way.

Question 7

An advantage that a database has over a flat file system is that more information can be generated from the same data.

Question 8

Any changes to a database's structure,such as adding a field,deleting a field,changing a field's size,or changing the data type stored in a field,are made with the data manipulation component.

Question 9

Redundant data is eliminated by a process called normalization.

Question 10

The sequential access file structure method is effective when a large number of records are processed less frequently,perhaps on a quarterly or yearly basis.

Question 11

The indexed sequential access method (ISAM) is slow and becomes increasingly useful as the number of records becomes larger.

Question 12

The database component of an information system can generate sufficient business intelligence by accessing just the internal data of an organization.

Question 13

Data redundancy is eliminated or minimized in a flat file system.

Question 14

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

Question 15

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

Question 16

In a relational model,the rows are called attributes and the columns are called tuples.

Question 17

For each database,there can be more than one physical view of data.

Question 18

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 19

In a hierarchical data model,nodes with the same parents are called siblings.

Question 20

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

Question 21

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

Question 22

To begin designing a relational database,one 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 23

Business intelligence uses scorecards and query reports to support decision-making activities,whereas business analytics uses data mining tools and predictive modeling.

Question 24

In contrast to the query languages used to interact with a relational database,interaction with an object-oriented database takes places via methods.

Question 25

A database administrator is responsible for developing recovery procedures in case data is lost or corrupted.

Question 26

As compared to data warehouses,consolidating information from different departments or functional areas is easier in data marts.

Question 27

The popularity of social networks has contributed to the growth of big data.

Question 28

The _____ of a data model defines the boundaries of a database,such as maximum and minimum values allowed for a field.

A) data structure
B) operations
C) integrity rules
D) file structure

Question 29

The _____ view of a database involves how data is stored on and retrieved from storage media.

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

Question 30

Which of the following is a source of external data?

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

Question 31

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

A) complex requests can be difficult to handle
B) more storage space is required
C) programs and data are interdependent
D) more sophisticated security measures can be seen

Question 32

In well-designed data-driven Web sites,changes are made to the HTML code every time a Web site's data content changes.

Question 33

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

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

Question 34

In the context of data administration component,the acronym CRUD stands for copy,revise,undo,and define.

Question 35

A distributed database is not limited by the data's physical location.

Question 36

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

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

Question 37

Which of the following is a source of internal data?

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

Question 38

The use of OR operator means that only one of the conditions in an SQL statement must be met.

Question 39

An e-commerce site that needs frequent updates would benefit from the use of a static Web site.

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

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 42

The _____ operator is used when all the conditions in a query by example (QBE) form are required to be met.

A) NOT
B) AND
C) OR
D) MIS

Question 43

_____ gives users subtotals of various categories,which can be useful.

A) Summary data
B) Raw data
C) Open data
D) Metadata

Question 44

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

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

Question 45

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

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

Question 46

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 47

In a relational model,when a primary key for one table appears in another table,it is called a _____ key.

A) secondary
B) foreign
C) surrogate
D) domain

Question 48

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 49

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

A) Metadata
B) Big data
C) Summary data
D) Raw data

Question 50

The _____ component is responsible for data storage,manipulation,and retrieval.

A) data definition
B) data administration
C) application generation
D) database engine

Question 51

In a data warehouse,_____ means 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) loading
D) aggregation

Question 52

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

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

Question 53

A(n) _____ operation pares down a table by eliminating columns according to certain criteria.

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

Question 54

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

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

Question 55

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) application generation
C) data definition
D) data administration

Question 56

_____ is information in its original form.

A) Summary data
B) Raw data
C) Paradata
D) Metadata

Question 57

Data in a data warehouse can be differentiated from data in a database in that the former _____.

A) captures raw transaction data
B) is used for capturing and managing transactions
C) is focused on a specific area
D) only keeps recent activity in memory

Question 58

Which of the following data sources provides the input a data warehouse needs to perform analyses and generate reports?

A) Online analytical processing
B) Online transaction processing
C) Enterprise resource planning systems
D) Data mining analysis

Question 59

A _____ stores definitions,such as data types for fields,default values,and validation rules for data in each field.

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

Question 60

The _____ approach to setting up a distributed database management system (DDBMS) combines fragmentation and replication.

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

Question 61

Which of the following factors has made big data analytics accessible to nearly all types of organizations?

A) Significant improvements in storage technology
B) Flat file organization of data
C) Significant increase in costs
D) Increase in the volume of business data

Question 62

A(n) _____ is software for creating,storing,maintaining,and accessing database files.

Question 63

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

Question 64

A(n) _____ is a collection of related data that is stored in a central location or multiple locations.

Question 65

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

Question 66

Which of the following statements is true of big data?

A) It is a consequence of geometric decay of data in data warehouses.
B) It can be efficiently processed and managed by conventional computing methods.
C) Its three dimensions are value, density, and uniformity.
D) It is a result of exponential growth of data in both public and private organizations.

Question 67

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

Question 68

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

Question 69

In a(n) _____ data model,the relationships among records form a treelike structure.

Question 70

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) Despite being smaller, data marts can usually perform the same type of analysis as data warehouses.

Question 71

Grouping objects along with their attributes and methods into a class is called _____.

Question 72

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 73

The advantage of _____ is that both sequential and random access can be used,depending on the situation and the user's needs.

Question 74

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

Question 75

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

Question 76

_____ refers to new objects being created faster and more easily by entering new data in attributes.

Question 77

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

A) viscosity
B) volume
C) variety
D) velocity

Question 78

Business analytics uses _____ to support decision-making activities.

A) data mining tools
B) dashboards
C) query reports
D) OLAP

Question 79

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

A) data warehouse and data mart
B) raw data and metadata
C) structured data and unstructured data
D) data definition and data manipulation

Question 80

_____ is used to facilitate and manage transaction-oriented applications,such as point-of-sale,data entry,and retrieval transaction processing.