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

What is the name of the open-source platform for building and managing data lakes?

  1. Apache Hudi

  2. Delta Lake

  3. Iceberg

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

Apache Hudi, Delta Lake, and Iceberg are all open-source platforms for building and managing data lakes.

Multiple choice

Which of the following is NOT a common format for disseminating health data?

  1. Tables and spreadsheets.

  2. Interactive dashboards and visualizations.

  3. Narrative reports and summaries.

  4. Raw data files.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Raw data files are typically not disseminated directly to the public or stakeholders. Instead, data is usually presented in more accessible and user-friendly formats, such as tables, spreadsheets, interactive dashboards, and narrative reports, to facilitate understanding and interpretation.

Multiple choice

Which digital preservation standard defines the technical requirements for the long-term preservation of digital cultural resources?

  1. ISO 14721

  2. ISO 16363

  3. ISO 23081

  4. ISO 28500
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

ISO 16363 is the international standard that defines the technical requirements for the long-term preservation of digital cultural resources, including the use of appropriate file formats, metadata, and storage systems.

Multiple choice

What is the term used to describe the process of converting digital cultural resources into a standard format that is widely recognized and supported by various software applications?

  1. Data standardization

  2. Data normalization

  3. Data harmonization

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

Data standardization refers to the process of converting digital cultural resources into a standard format that is widely recognized and supported by various software applications. This involves adhering to established standards and guidelines to ensure the interoperability and accessibility of digital resources across different platforms and systems.

Multiple choice

The diverse nature of data in Big Data Analytics, including structured, unstructured, and semi-structured data, can lead to which of the following challenges?

  1. Data Integration and Harmonization

  2. Data Cleaning and Preprocessing

  3. Data Analysis and Interpretation

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

The diverse nature of data in Big Data Analytics poses challenges in terms of integration and harmonization, cleaning and preprocessing, and analysis and interpretation.

Multiple choice

The diverse nature of data in Big Data Analytics, including structured, unstructured, and semi-structured data, can lead to which of the following limitations?

  1. Data Integration and Harmonization Challenges

  2. Data Cleaning and Preprocessing Challenges

  3. Data Analysis and Interpretation Challenges

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

The diverse nature of data in Big Data Analytics can lead to challenges in terms of integration and harmonization, cleaning and preprocessing, and analysis and interpretation.

Multiple choice

The diverse nature of data in Big Data Analytics, including structured, unstructured, and semi-structured data, can lead to which of the following challenges?

  1. Data Integration and Harmonization

  2. Data Cleaning and Preprocessing

  3. Data Analysis and Interpretation

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

The diverse nature of data in Big Data Analytics poses challenges in terms of integration and harmonization, cleaning and preprocessing, and analysis and interpretation.

Multiple choice

The diverse nature of data in Big Data Analytics, including structured, unstructured, and semi-structured data, can lead to which of the following limitations?

  1. Data Integration and Harmonization Challenges

  2. Data Cleaning and Preprocessing Challenges

  3. Data Analysis and Interpretation Challenges

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

The diverse nature of data in Big Data Analytics can lead to challenges in terms of integration and harmonization, cleaning and preprocessing, and analysis and interpretation.

Multiple choice

Which of the following is a common type of database management system?

  1. Relational Database

  2. NoSQL Database

  3. Hierarchical Database

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

A relational database is a widely used type of database management system that organizes data into tables, where each table consists of rows and columns. It allows for efficient data storage, retrieval, and manipulation.

Multiple choice

Which data processing model is suitable for handling high-velocity and continuous data streams in real-time analytics?

  1. Batch processing

  2. Lambda architecture

  3. Kappa architecture

  4. Data warehousing
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Lambda architecture is designed to handle both real-time and historical data processing, combining batch processing for historical data and real-time processing for streaming data.

Multiple choice

Which technology is commonly used for real-time data warehousing in big data analytics?

  1. Hadoop

  2. Spark

  3. Cassandra

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

Cassandra is a popular NoSQL database known for its scalability, high availability, and real-time data processing capabilities, making it suitable for real-time data warehousing.

Multiple choice

Which data format is commonly used for storing and exchanging astroinformatics data?

  1. FITS (Flexible Image Transport System)

  2. CSV (Comma-Separated Values)

  3. JSON (JavaScript Object Notation)

  4. XML (Extensible Markup Language)
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

FITS (Flexible Image Transport System) is a commonly used data format for storing and exchanging astroinformatics data. It is a standardized format specifically designed for astronomical data, supporting various data types, including images, spectra, and catalogs.

Multiple choice

Which data management technique is used to organize and structure large-scale astroinformatics data?

  1. Data warehousing

  2. Data mining

  3. Data visualization

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

Data warehousing is a data management technique used to organize and structure large-scale astroinformatics data. It involves centralizing data from various sources into a single repository, making it easier for researchers to access, query, and analyze the data.

Multiple choice

Which data management practice ensures the long-term preservation and accessibility of astroinformatics data?

  1. Data archiving

  2. Data backup

  3. Data replication

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

Data archiving is a data management practice that ensures the long-term preservation and accessibility of astroinformatics data. It involves storing data in a secure and reliable repository, following established standards and protocols, to guarantee its availability for future research and analysis.

Multiple choice

Which data management approach enables researchers to access and analyze data from multiple sources without physically moving the data?

  1. Data federation

  2. Data warehousing

  3. Data replication

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

Data federation is a data management approach that enables researchers to access and analyze data from multiple sources without physically moving the data. It creates a virtual view of the data, allowing users to query and integrate data from different sources as if they were stored in a single location.