object-oriented databases

Which of the following is a primary advantage of object-oriented databases over relational databases?

• Better support for complex data types

• Simpler to set up and manage

• Higher performance for simple queries

• More widely adopted in the industry

In which scenario is a relational database likely to be more advantageous than an object-oriented database?

• Managing a complex multimedia database

• Storing customer records in a standardized format

• Implementing a scientific simulation with complex objects

• Handling complex hierarchical data relationships

Which of the following best describes "impedance mismatch" in the context of object-oriented and relational databases?

• The difference in performance between the two database types

• The incompatibility between object-oriented programming and relational databases

• The challenge of migrating data from an object-oriented database to a relational database

• The difficulty in securing object-oriented databases compared to relational databases

What is a data warehouse primarily used for?

• Real-time transaction processing

• Storing unstructured data for quick retrieval

• Centralized storage of historical data for analysis

• Managing small datasets for departmental use

Which characteristic is most commonly associated with data warehouses?

• They store real-time data from operational systems.

• They are optimized for online transaction processing (OLTP).

• They focus on storing and analyzing historical data.

• They are designed for unstructured data management.

Which statement best describes a data mart?

• A smaller, more focused version of a data warehouse

• A database designed for real-time data processing

• A system for managing complex data types

• A repository for storing transactional data

Data marts are typically designed for:

• Organization-wide data storage

• Specific departments or business units

• Storing raw, unprocessed data

• Handling real-time transactions

Which of the following is NOT a suitable situation for implementing a data warehouse?

• Analyzing long-term sales trends across multiple regions

• Managing real-time inventory levels in a retail store

• Tracking customer purchase histories for targeted marketing

• Consolidating financial data from multiple departments for annual reports

A company wants to analyze customer behavior over the past five years to improve its marketing strategies. Which of the following would be the most suitable solution?

• Implement a relational database

• Use a data mart focused on customer data

• Build a data warehouse to store and analyze historical data

• Utilize an object-oriented database for real-time analysis

Why is time dependency important in data warehousing?

• Because data warehouses store only real-time data

• Because they rely on capturing and analyzing historical trends over time

• Because they are updated in real-time based on transaction logs

• Because time-dependent data is easier to retrieve than non-time-dependent data