Computer Knowledge

Database Management Systems

5,543 Questions

Database Management Systems (DBMS) form the core framework for data storage, retrieval, and security in modern software applications. Concepts such as the E-R model, backup planning, SQL integration, and big data architecture are essential for computer knowledge sections. This hub offers a comprehensive set of practice questions to master DBMS fundamentals and advanced database operations.

E-R Model ConceptsBackup and RecoverySQL Server UpgradesJDBC and ODBCBig Data CharacteristicsData VirtualizationOracle Database

Database Management Systems Questions

Multiple choice

What is the primary data structure used in document stores?

  1. Tables

  2. Rows

  3. Documents

  4. Columns
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Document stores utilize documents as their primary data structure, where each document is a self-contained unit of data.

Multiple choice

Which NoSQL database is known for its column-family data model?

  1. MongoDB

  2. Apache CouchDB

  3. Cassandra

  4. DynamoDB
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Cassandra is a column-family NoSQL database that provides high scalability and fault tolerance.

Multiple choice

Which NoSQL database is designed for real-time applications and provides low latency?

  1. MongoDB

  2. Apache CouchDB

  3. Cassandra

  4. DynamoDB
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

DynamoDB is an Amazon Web Services (AWS) NoSQL database optimized for real-time applications and high throughput.

Multiple choice

What is the concept of denormalization in the context of NoSQL databases?

  1. Storing duplicate data across multiple documents to improve performance.

  2. Breaking down complex data structures into simpler ones.

  3. Creating multiple tables for different types of data.

  4. Using a hierarchical data model to organize data.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Denormalization in NoSQL involves duplicating data across multiple documents to enhance performance and reduce the need for joins.

Multiple choice

Which NoSQL database is known for its ability to handle large volumes of unstructured data?

  1. MongoDB

  2. Apache CouchDB

  3. Cassandra

  4. Elasticsearch
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Elasticsearch is a NoSQL database designed specifically for handling large amounts of unstructured data and is commonly used for search and analytics applications.

Multiple choice

What is the primary data structure used in Cassandra?

  1. Tables

  2. Rows

  3. Documents

  4. Columns
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Cassandra utilizes a column-family data model, where data is organized into column families and columns.

Multiple choice

Which NoSQL database is known for its automatic sharding and replication features?

  1. MongoDB

  2. Apache CouchDB

  3. Cassandra

  4. DynamoDB
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

DynamoDB offers automatic sharding and replication, making it a highly scalable and fault-tolerant NoSQL database.

Multiple choice

What is the primary data structure used in MongoDB?

  1. Tables

  2. Rows

  3. Documents

  4. Columns
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

MongoDB uses a document-oriented data model, where data is stored in JSON-like documents.

Multiple choice

Which NoSQL database is known for its ACID (Atomicity, Consistency, Isolation, Durability) properties?

  1. MongoDB

  2. Apache CouchDB

  3. Cassandra

  4. DynamoDB
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Cassandra provides ACID guarantees, ensuring data integrity and consistency across multiple nodes.

Multiple choice

What is the primary data structure used in Apache CouchDB?

  1. Tables

  2. Rows

  3. Documents

  4. Columns
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Apache CouchDB utilizes a document-oriented data model, similar to MongoDB.

Multiple choice

Which NoSQL database is known for its ability to handle large volumes of time-series data?

  1. MongoDB

  2. Apache CouchDB

  3. Cassandra

  4. InfluxDB
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

InfluxDB is a NoSQL database specifically designed for storing and analyzing time-series data.

Multiple choice

What is the concept of a 'collection' in MongoDB?

  1. A group of related documents.

  2. A table-like structure.

  3. A field within a document.

  4. A database within a MongoDB instance.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In MongoDB, a collection is a logical grouping of related documents, similar to a table in a relational database.

Multiple choice

What is the role of metadata in data preservation?

  1. To describe the content, structure, and context of data

  2. To facilitate data discovery and retrieval

  3. To ensure data integrity and consistency

  4. To protect data from unauthorized access
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Metadata provides information about data, such as its origin, format, usage rights, and relationships with other data, making it easier to understand, manage, and preserve the data.

Multiple choice

What is the role of data curation in data archiving?

  1. To select, organize, and maintain data for long-term preservation

  2. To facilitate data discovery and retrieval

  3. To ensure data integrity and consistency

  4. To protect data from unauthorized access
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Data curation involves selecting, organizing, and maintaining data to ensure its long-term preservation, including activities such as data cleaning, standardization, and documentation.

Multiple choice

What is the primary limitation of VAEs in terms of the types of data they can generate?

  1. VAEs can only generate discrete data

  2. VAEs can only generate continuous data

  3. VAEs can only generate structured data

  4. VAEs can generate any type of data
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

VAEs are primarily designed to generate continuous data, such as images, audio, and text. They may struggle to generate discrete data, such as categorical variables or sequences.