Question 1

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

Accepted Answer

The variety dimension of big data refers to the combination of structured data (e.g. data stored in a database with a well-defined schema) and unstructured data (e.g. text, images, videos) which do not have a predefined format or schema. A, B, and D are not related to the variety dimension of big data.

Question 2

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.

Accepted Answer

The answer of For each database, there:
A) is only one...

Question 3

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

Accepted Answer

The answer of Business analytics uses _____ to gain insight...

Question 4

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

Accepted Answer

In a hierarchical model, data is organized in a tree-like structure where each parent can have multiple children/branches. Nodes with the same parents are referred to as twins or siblings in this model. The network model also allows for nodes to have multiple parents, making it more complex than the hierarchical model. The relational model and object-based model do not use a parent-child hierarchy to organize data.

Question 5

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

Accepted Answer

Variable psychographics provide insights into the motivations and beliefs of a buyer, which can help explain why they make certain purchasing decisions.

Question 6

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

Accepted Answer

The database engine is responsible for data storage, manipulation, and retrieval in a DBMS. The other options are not directly related to these functions.

Question 7

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

Accepted Answer

A data-driven website uses a database to store and retrieve data for users. It allows users to enter data into the database through a user interface. This is in contrast to a static website or flat web page, which displays the same content for all users and does not allow for user input into a database. A stationary web page is not a commonly used term in web development.

Question 8

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

Accepted Answer

The project operation in a relational database model is used to select only certain columns or attributes from a table, based on specified criteria. This helps to reduce the amount of data that needs to be accessed or processed, improving performance and efficiency. Join operations are used to combine data from multiple tables, find operations are used to search for specific values in a table, and insert operations are used to add new data to a table.

Question 9

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

Accepted Answer

The physical view of a database refers to how the data is stored on and retrieved from storage media. This includes details such as the location of storage, the type of storage device used, and how the data is organized physically. The other choices (logical view, rational view, analytical view) refer to different ways of conceptualizing and accessing the data in the database, but do not specifically relate to how the data is physically stored.

Question 10

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

Accepted Answer

The allocation approach combines both fragmentation and replication techniques to balance the advantages and disadvantages of both. In this approach, the database is fragmented into different subsets, and each subset is then replicated and distributed across different locations. This approach enhances availability, reliability, and performance scalability while reducing the risk of data loss and providing local autonomy. Therefore, the best choice is option B, the allocation approach.

Question 11

__________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

Accepted Answer

Online analytical processing (OLAP) tools are designed to analyze large volumes of data from different perspectives, allowing users to "drill up" or navigate from lower-level data to higher-level summaries or aggregates. This functionality enables users to gain insights into complex data sets and identify trends or patterns that may not be visible at lower levels.

Question 12

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

Accepted Answer

The answer of Which of the following is a key...

Question 13

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

Accepted Answer

Metadata is information about data, including its content, quality, condition, origin, and other characteristics. It provides context and helps facilitate the management, organization, and use of data in data warehousing. Big data refers to vast amounts of data that cannot be easily managed or analyzed using traditional methods, while summary data refers to aggregated or condensed data that has been processed for specific purposes. Raw data, on the other hand, is unprocessed and unstructured data that requires further analysis and manipulation.

Question 14

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

Accepted Answer

Demographic information includes variables such as gender, age, income, and marital status. It is frequently used in database marketing to segment customers based on their characteristics and target specific groups with tailored messaging and promotions.

Question 15

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

Accepted Answer

A primary key is a unique identifier for each record in a relational database. It must be unique, non-null, and should not change over time. No two records in a table can have the same primary key value. This makes it ideal for use in accessing and indexing data.

Question 16

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

Accepted Answer

Sequential access file structure is designed to handle data that can be sorted and processed in a particular sequence. The records in an ordered sequential file are stored one after the other in numerical order, and you can access any record in the file only by reading through all the records that appear before it.

Question 17

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.

Accepted Answer

A database uses more sophisticated security measures compared to a flat file system. The data in a database is organized and can be secured at a granular level, whereas in a flat file system, the entire file may need to be secured.

Question 18

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

Accepted Answer

The data manipulation component of a DBMS is responsible for adding, deleting, modifying, and retrieving records from a database. This component allows users to interact with the data stored in the database and perform various operations on it. The other components listed - data generation, data definition, and data administration - are important parts of a DBMS, but they are not directly involved in manipulating the data stored in the database.

Question 19

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

Accepted Answer

The volume dimension of big data refers to the amount of data, measured in petabytes or exabytes. Velocity refers to the speed at which data is generated and processed, while area and time are not dimensions of big data.

Question 20

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

Accepted Answer

Operations describe the methods and calculations that can be performed on data, such as updating and querying data. Data structure describes how the data is organized, integrity rules define constraints on the data, and file structure describes how the data is stored on a disk.

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

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

For each database, there:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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?