Question 1

The disadvantage of using a Web interface for a database is that it typically requires substantial changes to the internal database.

Accepted Answer

A web interface for a database usually interacts with the database through queries and does not require substantial changes to the internal database structure.

Question 2

OLAP enables users to obtain online answers to ad-hoc questions in a fairly rapid amount of time, except when the data are stored in very large databases.

Accepted Answer

OLAP is specifically designed to handle large volumes of data and provide quick responses to complex queries, even when the data is stored in very large databases.

Question 3

A data dictionary is a language associated with a database management system that end users and programmers use to manipulate data in the database.

Accepted Answer

A data dictionary is a tool that provides metadata about the data in a database, such as definitions, relationships, and formats, but it is not a language used to manipulate data.

Question 4

Data governance deals with the policies and processes for managing the integrity and security of data in a firm.

Accepted Answer

Data governance is indeed concerned with the policies, standards, and processes for ensuring the quality, accuracy, consistency, and security of data within an organization or enterprise. It involves establishing roles and responsibilities, defining data standards and policies, setting data quality metrics and controls, ensuring compliance with regulatory and legal requirements, and promoting data awareness and literacy across the organization.

Question 5

A grouping of characters into a word, a group of words, or a complete number is called a record.

Accepted Answer

A grouping of characters into a word, a group of words, or a complete number is typically called a "field" in database terminology, while a "record" is a collection of related fields.

Question 6

A DBMS separates the logical and physical views of data.

Accepted Answer

A DBMS separates the logical view, which is the way users perceive the data, from the physical view, which is the way data is actually stored on a computer. This separation allows for greater flexibility and easier management of the data.

Question 7

In a relational database, complex groupings of data must be streamlined to eliminate awkward many-to-many relationships.

Accepted Answer

Many-to-many relationships in a relational database can cause redundancy and inefficiencies, so it is important to streamline the data and eliminate them. This can be done through techniques such as normalization and using intermediary tables to simplify relationships.

Question 8

Every record in a file should contain at least one key field.

Accepted Answer

A key field is a field that uniquely identifies each record in a file. Every record should have at least one key field to ensure that it can be easily accessed and manipulated when needed.

Question 9

Each characteristic or quality describing a particular entity is called an attribute.

Accepted Answer

This statement is true. An attribute is a characteristic or quality that describes a particular entity or object. In database terminology, attributes are the columns of a table that define the specific information about each record or data point.

Question 10

Data administration is a special organizational function that manages the policies and procedures through which data can be managed as an organizational resource.

Accepted Answer

This statement accurately describes data administration as a function within an organization.

Question 11

A data warehouse is typically comprised of several smaller data marts.

Accepted Answer

A data warehouse is typically comprised of several smaller data marts, which are then used to create reports and analysis.

Question 12

A data warehouse may be updated by a legacy system.

Accepted Answer

It is possible for a legacy system to update a data warehouse. However, this may require additional integration efforts to ensure the data is consistent and accurate.

Question 13

NoSQL technologies are used to manage sets of data that don't require the flexibility of tables and relations.

Accepted Answer

NoSQL technologies are designed to work with unstructured, semi-structured, and/or structured data that does not necessarily require a fixed table schema or pre-defined relations. They offer flexible data models that allow for scalability, performance, and simplified development of applications.

Question 14

Because HTML was designed as a cross-platform language, it is the preferred method of communicating with back-end databases.

Accepted Answer

While HTML can be used to display data from back-end databases, it is not the preferred method of communicating with them. Instead, programming languages such as PHP, Python, Ruby, and Java are commonly used for back-end database communication.

Question 15

Data cleansing is the same process as data scrubbing.

Accepted Answer

Data cleansing and data scrubbing are interchangeable terms that refer to the process of identifying and removing errors, inconsistencies, and inaccuracies from a dataset.

Question 16

With in-memory computing, a computer's primary memory (RAM) is used for processing.

Accepted Answer

In-memory computing uses a computer's primary memory (RAM) for processing instead of using slower, secondary storage devices like hard drives or solid-state drives. This allows for faster data access and processing, resulting in improved performance and scalability for certain applications.

Question 17

OLAP is used for multidimensional data analysis.

Accepted Answer

OLAP (Online Analytical Processing) is designed for multidimensional data analysis, allowing users to quickly and flexibly analyze data from different perspectives. It allows for complex queries and aggregations, and is commonly used in business intelligence and decision support systems.

Question 18

Program-data dependence refers to the coupling of data stored in files and software programs that use this data such that changes in programs require changes to the data.

Accepted Answer

Program-data dependence means that changes in programs require changes to the data that is stored in files.

Question 19

In a Web-based database, middleware is used to transfer information from the organization's internal database back to the Web server for delivery in the form of a Web page to the user.

Accepted Answer

Middleware acts as a bridge between the internal database and the Web server, facilitating the transfer of information to be presented on the Web page.

Question 20

Common Gateway Interface is a specification for processing data on a Web server.

Accepted Answer

Common Gateway Interface (CGI) is indeed a specification for processing data on a Web server. It defines how a Web server communicates with scripts or other programs to produce dynamic content.

Quiz 6: Foundations of Business Intelligence: Databases and Information Management