Quiz On Chapters 6 & 9
(10).jpg "Quiz On Chapters 6 & 9 - Quiz")
.
Questions and Answers
- 1.
Which of the following represents the different information formats?
- A.
Detail, summary, aggregate
- B.
Document, presentation, spreadsheet, database
- C.
Individual, department, enterprise
- D.
None of the above
Correct Answer
B. Document, presentation, spreadsheet, databaseExplanation
The different information formats mentioned in the options are document, presentation, spreadsheet, and database. These formats represent different ways of organizing and presenting information. A document is a file that contains text and can include images, tables, and other elements. A presentation is a visual slideshow that is used to present information to an audience. A spreadsheet is a file that organizes data in rows and columns, allowing for calculations and analysis. A database is a collection of related data that is organized and stored for easy access and retrieval. These formats serve different purposes and are used in various contexts to convey information effectively.Rate this question:
-
- 2.
What encompasses all of the information contained within a single business or unit of work its primary purpose is to support the performing of daily operational tasks?
- A.
Transactional information
- B.
Analytical information
- C.
Timeliness
- D.
Quality
Correct Answer
A. Transactional informationExplanation
Transactional information encompasses all of the information contained within a single business or unit of work and its primary purpose is to support the performing of daily operational tasks. It includes data related to specific transactions, such as sales, purchases, and inventory levels. This information is crucial for the day-to-day operations of the business and enables efficient decision-making and task execution. Analytical information, on the other hand, refers to data that is used for analysis and decision-making at a higher level. Timeliness and quality are important aspects of both transactional and analytical information, but they do not encompass all of the information within a single business or unit of work.Rate this question:
-
- 3.
What provides real-time information in response to query requests?
- A.
Real-time information
- B.
Real-time systems
- C.
Information level
- D.
All of the above
Correct Answer
B. Real-time systemsExplanation
Real-time systems provide real-time information in response to query requests. These systems are designed to process and deliver information instantly, without any delay. They are capable of continuously monitoring and updating data in real-time, ensuring that the information provided is up-to-date and accurate. Therefore, real-time systems are the correct answer as they specifically cater to the need for real-time information.Rate this question:
-
- 4.
What is a real-time system?
- A.
Provides immediate, up-to-date information
- B.
Provides real-time information in response to query requests
- C.
Encompasses all organization information, and its primary purpose is to support the performing of managerial analysis tasks
- D.
Encompasses all of the information contained within a single business process or unit of work, and its primary purpose is to support the performing of daily operational tasks
Correct Answer
B. Provides real-time information in response to query requestsExplanation
A real-time system is a system that provides information in real-time, meaning it responds to query requests immediately and provides up-to-date information. This type of system is designed to provide timely and accurate information to users. It is different from a system that encompasses all organization information or supports managerial analysis tasks, as its primary purpose is to support the performing of daily operational tasks by providing real-time information.Rate this question:
-
- 5.
Which of the following implies that aggregate or summary information is in agreement with detailed information?
- A.
Uniqueness
- B.
Completeness
- C.
Consistency
- D.
Accuracy
Correct Answer
C. ConsistencyExplanation
Consistency implies that aggregate or summary information is in agreement with detailed information. This means that the overall data and the specific data align and are coherent with each other. Consistency ensures that there are no discrepancies or contradictions between the summarized information and the detailed information, indicating that the aggregate information accurately represents the underlying details.Rate this question:
-
- 6.
All of the following are advantages of database-stored information, except:
- A.
Increased flexibility
- B.
Increased performance
- C.
Increased information redundancy
- D.
Increased information integrity
Correct Answer
C. Increased information redundancyExplanation
Database-stored information provides increased flexibility as it allows for easy retrieval, manipulation, and analysis of data. It also offers increased performance as databases are designed to efficiently handle large amounts of data and perform complex queries. Additionally, it ensures increased information integrity by enforcing data validation and consistency rules. However, increased information redundancy is not an advantage of database-stored information. Redundancy refers to the unnecessary duplication of data, which can lead to storage and maintenance issues.Rate this question:
-
- 7.
Which of the following is correct in reference to a database?
- A.
A database can support only one logical view
- B.
A database can support many physical views
- C.
A database can support many logical views
- D.
A database can support up to 3 logical views
Correct Answer
C. A database can support many logical viewsExplanation
A database can support many logical views because it allows users to define and access data in different ways. Each user or application can have their own logical view of the data, which means they can see and manipulate the data in a way that makes sense to them. This flexibility is important for accommodating the diverse needs and preferences of different users or applications accessing the database.Rate this question:
-
- 8.
What are rules that enforce basic and fundamental information-based constraints?
- A.
Information integrity
- B.
Integrity constraint
- C.
Business-critical integrity constraint
- D.
Relational integrity constraint
Correct Answer
D. Relational integrity constraintExplanation
Relational integrity constraints are rules that enforce basic and fundamental information-based constraints in a relational database. These constraints ensure that data is accurate, consistent, and valid within the database. They define rules such as primary key constraints, foreign key constraints, and uniqueness constraints, which help maintain the integrity and reliability of the data stored in the database. By enforcing these constraints, relational databases can ensure the accuracy and consistency of the information they store.Rate this question:
-
- 9.
What type of integrity constraint does not allow someone to create an order for a nonexistent customer?
- A.
Relational integrity constraint
- B.
Business-critical integrity constraint
- C.
Information-critical integrity constraint
- D.
None of the above
Correct Answer
A. Relational integrity constraintExplanation
A relational integrity constraint is a type of constraint that ensures the consistency and accuracy of data in a relational database. In this case, the constraint would prevent the creation of an order for a nonexistent customer, which helps maintain the integrity of the database by ensuring that all orders are associated with valid and existing customer records.Rate this question:
-
- 10.
Which of the following statements is true regarding customer information?
- A.
Customer information can exist in several operational systems
- B.
Customer information in each operational system could change
- C.
Customer information in each operational system can be different
- D.
All of the above
Correct Answer
D. All of the aboveExplanation
The statement "All of the above" is the correct answer because customer information can indeed exist in several operational systems, meaning that it can be stored and accessed from multiple sources. Additionally, customer information in each operational system could change, as it may be updated or modified over time. Lastly, customer information in each operational system can be different, as there may be variations or inconsistencies in how the information is stored or recorded across different systems.Rate this question:
-
- 11.
Which of the following occurs during data cleansing?
- A.
Clean missing records
- B.
Clean redundant records
- C.
Clean inaccurate data
- D.
All of the above
Correct Answer
D. All of the aboveExplanation
During data cleansing, all of the mentioned tasks occur. Cleaning missing records involves identifying and removing any data entries that are incomplete or have missing values. Cleaning redundant records involves identifying and removing any duplicate data entries. Cleaning inaccurate data involves identifying and correcting any errors or inconsistencies in the data. Therefore, all of these tasks are part of the data cleansing process.Rate this question:
-
- 12.
Which of the following statements is true?
- A.
The more complete an organization wants to get its information, the less it costs
- B.
The more accurate an organization wants to get its information, the less it costs
- C.
The less accurate an organization wants to get its information, the more it costs
- D.
The more complete and accurate an organization wants to get its information, the more it costs
Correct Answer
D. The more complete and accurate an organization wants to get its information, the more it costsExplanation
The answer is that the more complete and accurate an organization wants to get its information, the more it costs. This is because obtaining complete and accurate information often requires investing in advanced technology, hiring skilled professionals, conducting thorough research, and implementing comprehensive data collection and analysis processes. All of these factors contribute to increased costs for the organization.Rate this question:
-
- 13.
What is information that people use to support their decision-making efforts?
- A.
Information cleansing and scrubbing
- B.
Data-mining tools
- C.
Data mining
- D.
Business intelligence
Correct Answer
D. Business intelligenceExplanation
Business intelligence refers to the information that people use to support their decision-making efforts. It encompasses a variety of tools, technologies, and processes that help collect, analyze, and present data in a meaningful way. Business intelligence allows individuals to gain insights, identify trends, and make informed decisions based on the available information. It helps organizations improve their performance, optimize processes, and achieve their goals.Rate this question:
-
- 14.
When does information cleansing occur in the data warehouse?
- A.
During the ETL process
- B.
On the information, once it is in the data warehouse
- C.
During the ETL process and once it is in the data warehouse
- D.
During the ETL process and before it is in the data warehouse
Correct Answer
C. During the ETL process and once it is in the data warehouseExplanation
Information cleansing occurs during the ETL process to ensure that the data being loaded into the data warehouse is accurate, consistent, and reliable. Once the data is in the data warehouse, further cleansing may also occur to maintain data quality and integrity.Rate this question:
-
- 15.
Timely information must be up-to-the-second to be accurate.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
The statement is false because timely information does not necessarily have to be up-to-the-second to be accurate. Timely information refers to information that is provided or received at the right time or within a reasonable timeframe. While up-to-the-second information may be more current and potentially more accurate, timely information can still be accurate even if it is not up-to-the-second.Rate this question:
-
- 16.
What focuses on keeping suppliers satisfied by evaluating and categorizing suppliers for different projects, which optimizes supplier selection?
- A.
Supplier relationship management
- B.
Partner relationship management
- C.
Employee relationship management
- D.
None of the above
Correct Answer
A. Supplier relationship managementExplanation
Supplier relationship management focuses on keeping suppliers satisfied by evaluating and categorizing suppliers for different projects, which optimizes supplier selection. This involves managing and nurturing relationships with suppliers to ensure that they meet the organization's needs and expectations. By evaluating and categorizing suppliers, organizations can identify the most suitable suppliers for specific projects, leading to improved efficiency and effectiveness in the procurement process. Supplier relationship management helps organizations build strong and mutually beneficial relationships with suppliers, ultimately resulting in better quality products or services and reduced costs.Rate this question:
-
- 17.
What focuses on keeping vendors satisfied by managing alliance partner and reseller relationships that provide customers with the optimal sales channel?
- A.
Supplier relationship management
- B.
Partner relationship management
- C.
Employee relationship management
- D.
None of the above
Correct Answer
B. Partner relationship managementExplanation
Partner relationship management focuses on keeping vendors satisfied by managing alliance partner and reseller relationships that provide customers with the optimal sales channel. It involves developing and maintaining strong relationships with partners, ensuring effective communication, and collaborating to achieve mutual goals. This helps to enhance sales and customer satisfaction by leveraging the strengths and resources of the partners in the sales channel.Rate this question:
-
- 18.
What is the primary problem most organizations face today concerning information?
- A.
Business intelligence rich, information rich
- B.
Data poor, information rich
- C.
Business intelligence poor, information rich
- D.
Data rich, information poor
Correct Answer
D. Data rich, information poorExplanation
Most organizations today have access to a large amount of data, but they struggle to extract meaningful information from it. This means that they are data rich, but information poor. They may have the tools and technology to collect and store data, but they lack the ability to analyze and interpret it effectively. This can hinder decision-making processes and prevent organizations from gaining valuable insights from their data.Rate this question:
-
- 19.
What types of BI decisions include predicting sales, determining correct inventory levels and distribution schedules among outlets, and loss prevention?
- A.
Retail and sales BI decisions
- B.
Banking BI decisions
- C.
Operations management BI decisions
- D.
Insurance BI decisions
Correct Answer
A. Retail and sales BI decisionsExplanation
Retail and sales BI decisions involve predicting sales, determining correct inventory levels and distribution schedules among outlets, and loss prevention. These decisions are specific to the retail industry and involve analyzing data to make informed decisions regarding sales strategies, inventory management, and preventing losses. This type of BI decision-making is crucial for the success and profitability of retail businesses.Rate this question:
-
- 20.
What types of BI decisions include forecasting levels of bad loans and fraudulent credit card use, credit card spending by new customers, and which kinds of customers will best respond to new loan offers?
- A.
Retail and sales BI decisions
- B.
Banking BI decisions
- C.
Operations management BI decisions
- D.
Insurance BI decisions
Correct Answer
B. Banking BI decisionsExplanation
Banking BI decisions involve forecasting levels of bad loans and fraudulent credit card use, credit card spending by new customers, and determining which kinds of customers will best respond to new loan offers. This type of decision-making is specific to the banking industry and focuses on managing risks, optimizing credit card usage, and identifying potential customers for loan offers.Rate this question:
-
Back to top