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 integration approach involves physically moving data from multiple sources into a central repository?

  1. Data federation

  2. Data warehousing

  3. Data virtualization

  4. Extract, transform, load (ETL)
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Data warehousing involves physically moving data from multiple sources into a central repository for analysis and reporting.

Multiple choice

Which data integration approach involves creating a logical layer on top of multiple data sources to provide a unified view of data?

  1. Data federation

  2. Data warehousing

  3. Data virtualization

  4. Extract, transform, load (ETL)
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Data virtualization creates a logical layer on top of multiple data sources to provide a unified view of data without physically moving the data.

Multiple choice

Which of the following is NOT a common data integration pattern?

  1. Hub-and-spoke

  2. Star schema

  3. Snowflake schema

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

Spaghetti schema is not a common data integration pattern. It refers to a poorly designed data model with tangled relationships between tables.

Multiple choice

Which of the following is NOT a common data integration architecture?

  1. Batch processing

  2. Real-time processing

  3. Lambda architecture

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

Spaghetti architecture is not a common data integration architecture. It refers to a poorly designed architecture with tangled data flows and dependencies.

Multiple choice

Which of the following is a data reduction technique that involves removing duplicate records from a dataset?

  1. Aggregation

  2. Dimensionality Reduction

  3. Sampling

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

Deduplication is a data reduction technique that involves identifying and removing duplicate records from a dataset, resulting in a smaller and more concise dataset.

Multiple choice

Which of the following is a data reduction technique that involves selecting a subset of records from a dataset that is representative of the entire dataset?

  1. Aggregation

  2. Dimensionality Reduction

  3. Sampling

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

Sampling is a data reduction technique that involves selecting a subset of records from a dataset that is representative of the entire dataset, allowing for analysis of a smaller and more manageable dataset.

Multiple choice

Which of the following is a data reduction technique that involves grouping records based on common attributes and aggregating their values?

  1. Aggregation

  2. Dimensionality Reduction

  3. Sampling

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

Aggregation is a data reduction technique that involves grouping records based on common attributes and aggregating their values, resulting in a smaller and more concise dataset.

Multiple choice

Which of the following is a data reduction technique that involves removing irrelevant or redundant attributes from a dataset?

  1. Aggregation

  2. Dimensionality Reduction

  3. Sampling

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

Dimensionality Reduction is a data reduction technique that involves removing irrelevant or redundant attributes from a dataset, resulting in a smaller and more manageable dataset.

Multiple choice

Which of the following is a data summarization technique that involves calculating the sum of all values of a numerical attribute across a group of records?

  1. Mean

  2. Median

  3. Mode

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

Sum is a data summarization technique that involves calculating the sum of all values of a numerical attribute across a group of records, providing a measure of total value.

Multiple choice

What is the purpose of a database caching mechanism?

  1. To reduce the number of requests to the database

  2. To improve the performance of the application

  3. To reduce bandwidth usage

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

A database caching mechanism is used to reduce the number of requests to the database, improve the performance of the application, and reduce bandwidth usage by storing frequently accessed data in memory.

Multiple choice

Which of the following is not a common approach to ensuring the interoperability of digital historical resources?

  1. Data conversion

  2. Metadata mapping

  3. Data harmonization

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

Digital libraries are not a common approach to ensuring the interoperability of digital historical resources. They are online repositories that provide access to digital resources, but they do not typically address the challenges of interoperability.

Multiple choice

Which of the following is a common data integration architecture in healthcare?

  1. Hub-and-spoke

  2. Point-to-point

  3. Data warehouse

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

The hub-and-spoke architecture is a common data integration architecture in healthcare. It involves a central hub that serves as a repository for data from various sources, and spokes that connect the hub to the individual data sources.

Multiple choice

Which of the following is a common data integration tool in healthcare?

  1. Health Level Seven (HL7)

  2. Fast Healthcare Interoperability Resources (FHIR)

  3. Clinical Document Architecture (CDA)

  4. Structured Query Language (SQL)
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Health Level Seven (HL7) is a widely used data integration tool in healthcare. It provides a standardized format for exchanging electronic health information between different healthcare systems.

Multiple choice

Which of the following is a key component of Data Quality Management?

  1. Data Profiling

  2. Data Cleansing

  3. Data Standardization

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

Data Quality Management encompasses various activities such as data profiling, data cleansing, data standardization, and data validation to ensure the accuracy, consistency, and completeness of data.

Multiple choice

Which of the following is a common approach to Data Quality Improvement?

  1. Data Profiling

  2. Data Cleansing

  3. Data Standardization

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

Data Quality Improvement typically involves a combination of data profiling to identify data issues, data cleansing to correct errors and inconsistencies, and data standardization to ensure consistency in data formats and values.