Question 1

_____ are quantifiable measurements that assess progress toward organizational goals and reflect the critical success factors of an organization.
A) Business intelligence matrices
B) Social graphs
C) Key performance indicators (KPIs)
D) Dashboards

Accepted Answer

Key performance indicators (KPIs) are specific, measurable metrics that help organizations track progress towards achieving their goals. They reflect the critical success factors of an organization and are often used in performance management systems to ensure that employees are contributing to the overall success of the organization. Business intelligence matrices, social graphs, and dashboards are all tools that can be used to visualize and analyze KPI data, but they are not KPIs themselves.

Question 2

_____ is a special-purpose programming language for accessing and manipulating data stored in a relational database.
A) Query by Example (QBE)
B) Access
C) Structured Query Language (SQL)
D) Java

Accepted Answer

Structured Query Language (SQL) is specifically designed to interact with relational databases. Its commands and syntax allow users to create, update, delete, and retrieve data from the database. While other programming languages, such as Java, can also access databases, SQL is the primary language used for this purpose. Query by Example (QBE) and Access are database management tools, but not programming languages like SQL.

Question 3

_____ is the term used to describe enormous and complex data collections that traditional data management software, hardware, and analysis processes are incapable of dealing with them.
A) Data warehouse
B) Data mart
C) Big data
D) Knowledge base

Accepted Answer

Big data refers to extremely large and complex data sets that traditional data management tools and processes cannot handle. These data sets are typically characterized by the 3Vs: volume, velocity, and variety. Data warehouses and data marts are more traditional approaches to data management and may still struggle with big data. A knowledge base is a database used for knowledge management or artificial intelligence applications, but it is not necessarily related to big data.

Question 4

With _____, the database is stored on a service provider's server and accessed by the client over a network, typically the Internet.
A) Internet access
B) Database as a Service
C) Software as a Service
D) Oracle

Accepted Answer

Database as a Service (DBaaS) is a cloud computing model where the database is hosted and maintained by a third-party provider. The client accesses the database over a network, typically the Internet. This model offers benefits such as scalability, accessibility, and cost-effectiveness.

Question 5

Together, bits, characters, fields, records, files, and databases form the ______.

Accepted Answer

The answer of Together, bits, characters, fields, records, files, and...

Question 6

Some databases use ______, which is a visual approach to developing queries and requests.
A) Query by Example (QBE)
B) user views
C) Structured Query Language (SQL)
D) data manipulation language (DML)

Accepted Answer

Query by Example (QBE) is a visual database query language where users can create queries by selecting tables, fields, and the relationships between them using a graphical user interface. It allows users to specify search conditions by filling in an example form rather than writing queries using SQL.

Question 7

Social graph analysis is a(n) _____ technique in which data is represented as networks where the vertices are the individual data points (social network users) and the edges are the connections among them.
A) data mining
B) online analytical processing
C) data visualization
D) predictive analysis

Accepted Answer

The answer of Social graph analysis is a(n) _____ technique...

Question 8

A collection of related records is called a(n) _____.

Accepted Answer

The answer of A collection of related records is called...

Question 9

The term _____ describes the steps an organization takes to protect information sought by "hostile" intelligence gathers.
A) data loss prevention
B) trade secret
C) counterintelligence
D) competitive intelligence

Accepted Answer

Counterintelligence refers to the actions an organization takes to protect information from foreign or hostile intelligence agencies. Data loss prevention, trade secret, and competitive intelligence are related terms, but they describe different aspects of information security and strategy.

Question 10

A _____ is a description that involves "telling" the database management system (DBMS) the logical and physical structure of the data and the relationships among the data for each user.
A) query
B) record
C) schema
D) field

Accepted Answer

A schema is a way of describing the logical and physical structure of data in a database. It includes information on the tables, columns, relationships, and constraints that make up the database. Each user may have their own schema tailored to their specific needs for accessing the data. Queries, records, and fields are all parts of the data itself and do not describe the structure of the data in the same way a schema does.

Question 11

_____ is a form of data mining that combines historical data with assumptions about future conditions to forecast the outcomes of events.
A) Business intelligence
B) Social graph analysis
C) Online analytical processing
D) Predictive analysis

Accepted Answer

Predictive analysis is a type of data mining that uses historical data along with assumptions about future conditions to forecast potential outcomes. It is commonly used in areas such as finance, marketing, and healthcare to anticipate future events and make informed decisions. Business intelligence and online analytical processing are related concepts that involve the use of data to gain insights into business operations and performance, while social graph analysis refers specifically to the study of relationships between individuals and groups in social networks.

Question 12

Data warehouses allow managers to _____ to get increasing levels of detail about business conditions.
A) roll up
B) drill down
C) slice and dice
D) extract data

Accepted Answer

Drill down refers to the process of exploring detailed data that is contained in a data warehouse, allowing managers to gain more specific insights into business conditions.

Question 13

The position of a _____ is a nontechnical position responsible for defining and implementing consistent principles for setting data standards and data definitions that apply across all the databases in an organization.
A) data analyst
B) data administrator
C) database administrator
D) data owner

Accepted Answer

A data administrator is responsible for defining and implementing consistent principles for setting data standards and data definitions. The other options do not specifically mention this responsibility.

Question 14

A ______ is a collection of instructions and commands used to define and describe data and relationships in a specific database.
A) data dictionary
B) schema
C) data definition language
D) data manipulation language

Accepted Answer

The answer of A ______ is a collection of instructions...

Question 15

Most of the data that an organization must deal with is _____ data, meaning that it is not organized in any predefined manner.

Accepted Answer

The answer of Most of the data that an organization...

Question 16

______ is a form of database processing that supports top-down, query-driven data analysis.
A) Database normalization
B) Online analytical processing (OLAP)
C) Data warehousing
D) Data mining

Accepted Answer

Online analytical processing (OLAP) is a form of database processing that supports top-down, query-driven data analysis. It enables users to analyze data from multiple perspectives and dimensions, making it ideal for decision-making and business intelligence. Database normalization is a technique to eliminate data redundancies and inconsistencies, data warehousing is a process of storing large volumes of data for analysis, and data mining involves discovering hidden patterns and trends in data.

Question 17

A(n) ______ consists of a group of programs that manipulate the database and provide an interface between the database and its users and other application programs.

Accepted Answer

The answer of A(n) ______ consists of a group of...

Question 18

A(n) _____ is a field or set of fields that uniquely identifies a record.

Accepted Answer

The answer of A(n) _____ is a field or set...

Question 19

_____ is an information-analysis tool that involves the automated discovery of patterns and relationships in a data warehouse.
A) Data mining
B) Counterintelligence
C) Competitive intelligence
D) Enterprise data modeling

Accepted Answer

Data mining is the process of using statistical techniques and algorithms to extract useful insights and patterns from large datasets. It is widely used in various industries, including marketing, finance, healthcare, and retail, to uncover hidden patterns, relationships, and trends in data warehouses. Counterintelligence and competitive intelligence are not directly related to data analysis, while enterprise data modeling is a process of creating a conceptual representation of data objects and their relationships within a business organization.

Question 20

A _____ is a subset of a data warehouse that is used by small- and medium-sized businesses and departments within large companies to support decision making.
A) data dictionary
B) data model
C) data mart
D) data mine

Accepted Answer

A data mart is a smaller subset of a data warehouse that focuses on a particular department or business function. It contains only relevant data and is designed to support decision-making at a smaller scale. Data dictionaries and data models are related to the development and management of databases, while data mining is the process of analyzing data to extract meaningful insights.

Quiz 5: Database Systems and Applications

_____ are quantifiable measurements that assess progress toward organizational goals and reflect the critical success factors of an organization.

_____ is a special-purpose programming language for accessing and manipulating data stored in a relational database.

_____ is the term used to describe enormous and complex data collections that traditional data management software, hardware, and analysis processes are incapable of dealing with them.

With _____, the database is stored on a service provider's server and accessed by the client over a network, typically the Internet.

Together, bits, characters, fields, records, files, and databases form the ______.

Some databases use ______, which is a visual approach to developing queries and requests.

Social graph analysis is a(n) _____ technique in which data is represented as networks where the vertices are the individual data points (social network users) and the edges are the connections among them.

A collection of related records is called a(n) _____.

The term _____ describes the steps an organization takes to protect information sought by "hostile" intelligence gathers.

A _____ is a description that involves "telling" the database management system (DBMS) the logical and physical structure of the data and the relationships among the data for each user.

_____ is a form of data mining that combines historical data with assumptions about future conditions to forecast the outcomes of events.

Data warehouses allow managers to _____ to get increasing levels of detail about business conditions.

The position of a _____ is a nontechnical position responsible for defining and implementing consistent principles for setting data standards and data definitions that apply across all the databases in an organization.

A ______ is a collection of instructions and commands used to define and describe data and relationships in a specific database.

Most of the data that an organization must deal with is _____ data, meaning that it is not organized in any predefined manner.

______ is a form of database processing that supports top-down, query-driven data analysis.

A(n) ______ consists of a group of programs that manipulate the database and provide an interface between the database and its users and other application programs.

A(n) _____ is a field or set of fields that uniquely identifies a record.

_____ is an information-analysis tool that involves the automated discovery of patterns and relationships in a data warehouse.

A _____ is a subset of a data warehouse that is used by small- and medium-sized businesses and departments within large companies to support decision making.