Question 1

When information is stored about a purchase or sale, what is stored in a database?

Accepted Answer

When information is stored about a purchase or sale, it is typically stored as a transaction in a database. The transaction includes details such as the date, time, products or services purchased or sold, and the price. It is then recorded in a database for future reference and analysis.

B, C, and D are not accurate choices because they do not specifically describe what is stored in the database related to a purchase or sale.

Question 2

Which of the following are large electronic repositories of very detailed information?

Accepted Answer

Libraries, data compilations, and data collections are all broad terms that can refer to physical or digital collections of information. Databases, on the other hand, specifically refer to electronic repositories with detailed and organized information, often searchable and able to be manipulated using software tools.

Question 3

If your phone number was used in a clothing store to uniquely identify you as a customer, the phone number would be considered a(n) _____.

Accepted Answer

A primary key is a field in a database that uniquely identifies each record. In this scenario, the phone number serves as a unique identifier for the customer, making it a primary key. Option A and B are not technically accurate terms in database design, and option D is not a recognized term at all.

Question 4

What application enables your organization to analyze competitor, customer, environmental, and internal data?

Accepted Answer

Business intelligence is the application that enables an organization to analyze competitor, customer, environmental, and internal data. Business intelligence tools provide advanced analytics capabilities that allow businesses to explore complex data sets and gain insights that can inform decision-making. Query-by-example (A) and SQL (D) are specific query languages used to extract data from databases, but they do not offer the same level of analysis and visualization capabilities as business intelligence tools. Information analysis (B) is a broad term that can refer to any process of examining and interpreting data, but it does not necessarily imply the use of advanced analytics tools.

Question 5

Which type of application requires that you know the physical location of information before you are able to access it?

Accepted Answer

Spreadsheets require you to know the physical location (such as the cell address) of information before you can access or manipulate it.

Question 6

What is the type of field, or group of fields, that can uniquely identify each record in a database?

Accepted Answer

The primary key is a field or group of fields that can uniquely identify each record in a database. It serves as a reference for all other tables in the database and ensures data integrity by preventing duplicates or null values.

Question 7

Which of the following terms represent an organized and structured collection of information?

Accepted Answer

A database is an organized and structured collection of information. A database management system (A) is software that allows users to create, access, and manage a database. A data dictionary (C) is a tool within a database management system that describes the meaning, purpose, and usage of data elements in a database. A structured query system (D) is a tool within a database management system that allows users to query and manipulate data in a database. However, only a database itself fits the description of an organized and structured collection of information.

Question 8

Which part of a relational database contains the logical structure for the information?

Accepted Answer

The data dictionary contains the logical structure for the information in a relational database. It provides information such as data types, relationships between tables, and other constraints on the data. Relations are tables within the database, queries are used to retrieve specific data from the database, and SQL is the language used to interact with the database. None of these contain the logical structure for the information.

Question 9

Which term refers to a specific piece of data that is stored in a database file?

Accepted Answer

An attribute refers to a specific piece of data that is stored in a database file. A relation refers to a table in a database that contains related information, a category is a grouping or classification of data, and a class typically refers to a programming language construct for creating objects.

Question 10

What is the objective of business intelligence (BI)?

Accepted Answer

The objective of business intelligence (BI) is to provide timely and quality information to decision makers. Processing transactional information efficiently and effectively and processing external information are both functions of BI, but they do not fully capture its objective. BI is ultimately about providing decision makers with the information they need to make informed decisions.

Question 11

Which type of database model organizes and accesses information according to its logical structure rather than its physical structure?

Accepted Answer

Relational database model organizes data in tables with columns and rows, and information is accessed based on the logical relationships between tables rather than physical storage location. Hierarchical and file-based models organize data based on physical storage, and conventional models are not a specific type of database model.

Question 12

To succeed in business and to enable your organization to extract meaningful information from its information repositories, you need which type of application?

Accepted Answer

Business intelligence is the best choice as it includes tools and techniques for analyzing and interpreting data to support decision-making and business strategies. It allows organizations to extract meaningful information from their information repositories, enabling them to make data-driven decisions to succeed in business. Query-by-example and SQL are specific query techniques, while information analysis is a broader concept that includes various techniques for analyzing data.

Question 13

What is another name for a database that supports OLTP?

Accepted Answer

An operational database is a type of database that supports online transaction processing (OLTP), which means it is optimized for handling a high volume of transactions in real-time. It is also known as a transactional database or an OLTP database. A, B, and C are not appropriate answers as they all refer to different types of databases that do not specifically support OLTP.

Question 14

Which application supports the manipulation of information to support decision making?

Accepted Answer

Online analytical processing (OLAP) supports the manipulation of large sets of data and enables the analysis and interpretation of information in order to support decision making. OLAP applications are designed for complex queries and data mining, and are therefore the best choice for supporting decision-making processes.

Question 15

Which type of database stores data in a series of logically related two-dimensional tables or files?

Accepted Answer

Relational databases store data in tables that are related to each other based on common fields or keys. This structure allows for efficient storage and retrieval of data, as well as the ability to perform complex queries and analysis. Hierarchical and file-based databases have limitations in terms of flexibility and scalability compared to relational databases, and conventional databases are not a recognized type of database.

Question 16

Your student ID is an example of a(n) _____.

Accepted Answer

A student ID is an example of an attribute, which refers to a characteristic or property of an entity (in this case, the entity is a student). A table would be a collection of related attributes or entities, while a relation would describe how two tables or entities are connected. A business rule would be a guideline or constraint that defines how a business should operate.

Question 17

Which system allows your organization to gather, process, and update transactional information?

Accepted Answer

Online transaction processing (OLTP) systems are designed to capture, process, and update transactional data in real-time. This system is used to track, record and store transactions like sales or payments as they occur. OLTP is important for day-to-day business operations, it is one of the basic systems of record keeping, gathering raw data to use later to make business decisions or strategic plans.

Question 18

What is another name for a database?

Accepted Answer

The answer of What is another name for a database?
...

Question 19

A senior manager who analyzes internal and external information to analyze marketing campaigns and their affect on customer buying habits is using which type of application?

Accepted Answer

The senior manager is using OLAP applications to analyze marketing campaigns and their effect on customer buying habits. OLAP applications use multidimensional data analysis techniques to analyze large amounts of data and provide insights into business performance.

Question 20

If you needed to store facts about information that you were collecting, you would store these facts in the _____.

Accepted Answer

A data dictionary is a centralized repository that contains information about the data in a database. It stores facts such as data types, definitions, and relationships between tables. Storing information in a data dictionary helps ensure consistency and accuracy in the database.

Quiz 3: Databases and Data Warehouses