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

Question 1

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

Answer 1

True

Question 2

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

Answer 2

True

Question 3

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

Answer 3

False

Question 4

Identify an advantage of using a database over a flat file system.

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

Question 5

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

Question 6

The use of the OR operator means that only one of the conditions in a structured query language (SQL)statement must be met.

Question 7

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

Question 8

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

Question 9

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

Question 10

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

Question 11

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

Question 12

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 13

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

Question 14

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

Question 15

Identify a true statement about a database.

A)A database is similar to a filing cabinet where data can be retrieved faster.
B)A database is an alternative for developing information systems.
C)A database is the core of any global information system.
D)A database is a crucial tool for managing overseas subsidiaries.

Question 16

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

Question 17

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

Question 18

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

Question 19

Identify a true statement about a flat file system.

A)Data in a flat file system may not be updated in all files consistently.
B)Data in a flat file system can be easily managed.
C)Data in a flat file system can be updated efficiently.
D)Data duplication in a flat file system is very efficient.

Question 20

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

Question 21

The _____ 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 22

In a relational database 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 23

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 24

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 25

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

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

Question 26

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 27

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

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

Question 28

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

_____,a component 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)Product line

Question 30

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

A)external and internal
B)aggregated and disaggregated
C)qualitative and quantitative
D)slicing and dicing

Question 31

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 32

Identify the number of physical views of data for a database.

A)Only one
B)Only two
C)Multiple
D)Zero

Question 33

Identify a file structure that is similar to a book index that lists page numbers where certain topics can be found.

A)Indexed sequential access method
B)Indexed network access structure
C)Indexed random access file structure
D)Indexed hierarchical model method

Question 34

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 35

In a relational database model,the rows are known as _____.

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

Question 36

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

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

Question 37

In a relational database model,the columns are known as _____.

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

Question 38

Which of the following is an example of a source for external data?

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

Question 39

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

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

Question 40

The _____ method 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 41

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 42

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 43

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

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

Question 44

In data warehouses,_____ is information in its original form.

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

Question 45

The _____ operator,discussed in data manipulation,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 46

In the context of data administration component,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 47

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 48

The _____ component of a database management system (DBMS)is responsible for data storage,manipulation,and retrieval.

A)database storage
B)database output
C)database extraction
D)database engine

Question 49

The component that is used to design elements of an application using a database,such as data entry screens,interactive menus,and interfaces,with other programming languages is the _____ component.

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

Question 50

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 51

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

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

Question 52

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)optimization
D)aggregation

Question 53

A database administrator is responsible for _____.

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

Question 54

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 55

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 56

A(n)_____ is not limited by the data's physical location.

A)distributed database
B)relational database
C)object-oriented database
D)semi-structured database

Question 57

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 58

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

A)Hyper Text Markup Language (HTML)
B)Java
C)Python
D)C#

Question 59

In contrast to data in a database,discussed in data warehouses,the subject-oriented characteristic _____.

A)captures raw transaction data
B)manages data transactions
C)focuses on a specific area
D)keeps recent activity in memory

Question 60

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

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

Question 61

_________,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)Instance

Question 62

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

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

Question 63

Business analytics uses _____ to support decision-making activities.

A)data mining tools
B)dashboards
C)query reports
D)application generators

Question 64

A _________ is a collection of related data that is stored in a central location or multiple locations.

A)database
B)data mart
C)data warehouse
D)data hierarchy​

Question 65

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

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

Question 66

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

A)administrator
B)server
C)mapper
D)developer​

Question 67

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

A)primary
B)super
C)foreign
D)candidate​

Question 68

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

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

Question 69

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

A)data warehouses and data marts
B)raw data and metadata
C)structured data and unstructured data
D)data definition and data manipulation

Question 70

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

A)indexed sequential access method (ISAM)
B)sequential access method
C)direct access method
D)random access method

Question 71

A _________ is software for creating,storing,maintaining,and accessing database files.

A)database management system
B)data hierarchy
C)data model
D)data warehouse

Question 72

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

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

Question 73

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

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

Question 74

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

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

Question 75

_________ is used to facilitate and manage transaction-oriented applications,such as point-of-sale,data entry,and retrieval transaction processing.
A.Online transaction processing (OLTP)
B.Online analytical processing (OLAP)
C.Extraction,transformation,and loading (ETL)
D.Business analytics (BA)

Question 76

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 77

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 78

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

A)logical
B)physical
C)catalog
D)complex​

Question 79

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 80

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.