Computer Knowledge

Database Management Systems

5,344 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

Which data management technique involves creating a central repository for storing and managing astroinformatics data?

  1. Data warehousing

  2. Data federation

  3. Data virtualization

  4. Data replication
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Data warehousing is a data management technique that involves creating a central repository for storing and managing astroinformatics data. It consolidates data from various sources into a single, structured format, making it easier for researchers to access, query, and analyze the data.

Multiple choice

Which of the following is NOT a common tool or technology used in Big Data Analytics?

  1. Hadoop

  2. Spark

  3. Tableau

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

While Hadoop, Spark, and Tableau are widely used in Big Data Analytics, SQL is primarily a relational database management system and not specifically designed for Big Data Analytics.

Multiple choice

Which of the following is a commonly used data storage model for geographical data warehousing?

  1. Relational Model

  2. Hierarchical Model

  3. Network Model

  4. Object-Oriented Model
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The relational model is widely used for geographical data warehousing due to its ability to represent complex relationships between different geographical entities.

Multiple choice

Which of the following is a common technique for managing large volumes of spatial data in a geographical data warehouse?

  1. Data partitioning

  2. Data replication

  3. Data compression

  4. Data aggregation
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Data partitioning is a technique for dividing large datasets into smaller, more manageable chunks, which can be stored on different servers or nodes.

Multiple choice

Which of the following is a common data storage technology used for storing large volumes of spatial data in a geographical data warehouse?

  1. Relational Database Management Systems (RDBMS)

  2. Spatial Database Management Systems (SDBMS)

  3. NoSQL Databases

  4. Cloud Storage Platforms
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Spatial Database Management Systems (SDBMS) are specialized databases designed to handle and manage spatial data efficiently.

Multiple choice

Which of the following is NOT a common technique used for digital preservation?

  1. Data migration

  2. Data compression

  3. Data encryption

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

Data encryption is not typically used for digital preservation, as it can make it difficult to access the data in the future if the encryption key is lost.

Multiple choice

Which of the following is NOT a common tool used for digital preservation?

  1. Data migration tools

  2. Data compression tools

  3. Data encryption tools

  4. Data duplication tools
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Data encryption tools are not typically used for digital preservation, as they can make it difficult to access the data in the future if the encryption key is lost.

Multiple choice

What is the name of the open source project that provides a distributed database for storing and querying large amounts of data?

  1. Cassandra

  2. MongoDB

  3. Elasticsearch

  4. HBase
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Cassandra is an open source project that provides a distributed database for storing and querying large amounts of data.

Multiple choice

What is the name of the open source project that provides a distributed data warehousing platform?

  1. Hive

  2. Presto

  3. Impala

  4. Drill
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Hive is an open source project that provides a distributed data warehousing platform.

Multiple choice

Which of the following is an example of a DSS?

  1. A spreadsheet

  2. A database

  3. A simulation model

  4. All of the above
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

All of the above are examples of DSSs.

Multiple choice

Which of the following is NOT a characteristic of Big Data?

  1. Volume

  2. Variety

  3. Velocity

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

Veracity refers to the accuracy and reliability of data, which is not a defining characteristic of Big Data. The three main characteristics of Big Data are Volume, Variety, and Velocity.

Multiple choice

What is the primary benefit of using Apache Druid for time-series data analysis?

  1. Fast query performance

  2. Scalability and fault tolerance

  3. Support for real-time data ingestion

  4. All of the above
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Apache Druid is a specialized distributed system designed for time-series data analysis. It offers fast query performance, scalability, fault tolerance, and support for real-time data ingestion, making it a suitable choice for analyzing large volumes of time-series data.

Multiple choice

Which distributed database is commonly used for storing and querying large-scale structured data?

  1. Apache Cassandra

  2. Apache HBase

  3. MongoDB

  4. PostgreSQL
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Apache Cassandra is a widely used distributed database designed for handling large-scale structured data. It provides high scalability, fault tolerance, and efficient query performance, making it suitable for applications that require fast access to large data sets.

Multiple choice

Which classification system is widely used in public libraries in the United States?

  1. Dewey Decimal Classification

  2. Library of Congress Classification

  3. Universal Decimal Classification

  4. Bliss Bibliographic Classification
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The Dewey Decimal Classification (DDC) is a widely used library classification system that organizes books and other library materials by subject. It is used in many public libraries, school libraries, and academic libraries in the United States and other countries.

Multiple choice

Which classification system is used to organize books in the Library of Congress?

  1. Dewey Decimal Classification

  2. Library of Congress Classification

  3. Universal Decimal Classification

  4. Bliss Bibliographic Classification
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The Library of Congress Classification (LCC) is a classification system that is used to organize books and other library materials in the Library of Congress. It is also used in many other libraries around the world.