Database Management Systems Quiz

A relational database management system (RDBMS) is ideal for handling large volumes of unstructured data.

• True

• False

Answer explanation

False. RDBMSs are designed for structured data with predefined schemas, making them less suitable for large volumes of unstructured data, which are better handled by NoSQL databases.

NoSQL databases are known for their rigid schema designs.

• True

• False

Answer explanation

NoSQL databases are characterized by flexible schema designs, allowing for dynamic data structures. This flexibility contrasts with traditional relational databases, which have rigid schemas. Therefore, the statement is false.

MongoDB is an example of a relational database.

• True

• False

Answer explanation

MongoDB is a NoSQL database, not a relational database. It stores data in flexible, JSON-like documents rather than structured tables, making the statement false.

Hierarchical databases are commonly used in modern applications.

• True

• False

Answer explanation

Hierarchical databases are less common in modern applications due to their limitations in flexibility and scalability. Most applications now prefer relational or NoSQL databases, making the statement false.

Graph databases are ideal for social network analysis.

• True

• False

Answer explanation

True. Graph databases excel in social network analysis due to their ability to efficiently model and query relationships between users, making it easier to analyze connections and interactions.

In-memory databases are used for long-term data storage.

• True

• False

Answer explanation

In-memory databases store data temporarily for fast access, not for long-term storage. Therefore, the statement is false.

Time-series databases are optimized for storing historical data.

• True

• False

Answer explanation

True. Time-series databases are specifically designed to efficiently store and manage historical data, making them ideal for applications that require tracking changes over time.

RDBMS supports horizontal scaling easily.

• True

• False

Answer explanation

RDBMS (Relational Database Management Systems) typically rely on vertical scaling, which involves adding more power to a single server. Horizontal scaling, which adds more servers, is more challenging for RDBMS due to data consistency and transaction management.

Cassandra is an example of a relational database.

• True

• False

Answer explanation

Cassandra is a NoSQL database, not a relational database. It uses a different data model based on wide-column storage, which is distinct from the table-based structure of relational databases. Therefore, the statement is false.

Object-oriented databases are widely used in enterprise applications.

• True

• False

Answer explanation

Object-oriented databases are not as widely used in enterprise applications as relational databases, which dominate the market due to their maturity and support for complex queries. Therefore, the statement is false.