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

Which of the following is a type of data warehouse technology?

  1. Oracle

  2. SQL Server

  3. Teradata

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

Oracle, SQL Server, and Teradata are all types of data warehouse technologies. Oracle is a relational database management system that is used to store and manage data in a data warehouse. SQL Server is a relational database management system that is also used to store and manage data in a data warehouse. Teradata is a data warehouse appliance that is specifically designed for storing and analyzing large amounts of data.

Multiple choice

Which of the following is a common approach for representing text data in NLP?

  1. Bag-of-Words (BOW)

  2. Term Frequency-Inverse Document Frequency (TF-IDF)

  3. Word Embeddings

  4. N-grams
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Bag-of-Words (BOW) is a simple yet effective method for representing text data by converting it into a vector of word frequencies.

Multiple choice

Which of the following is NOT a key aspect of digital curation?

  1. Selection and Appraisal

  2. Organization and Description

  3. Preservation and Access

  4. Data Mining and Analysis
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Data mining and analysis, while valuable for extracting insights from digital data, is not a core aspect of digital curation, which focuses on the management and preservation of digital assets.

Multiple choice

Which of the following is NOT a key consideration for evaluating the trustworthiness of digital archives?

  1. Transparency and Accountability

  2. Data Provenance and Lineage

  3. Security and Access Control

  4. Cost-Effectiveness
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Cost-effectiveness, while important for resource allocation, is not a key consideration for evaluating the trustworthiness of digital archives, which focuses on factors such as transparency, accountability, data provenance, and security.

Multiple choice

What is the primary cause of data heterogeneity?

  1. Different data formats

  2. Different data sources

  3. Different data types

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

Data heterogeneity is caused by a combination of different data formats, data sources, and data types.

Multiple choice

Which data integration approach involves combining data from multiple sources into a single, unified view?

  1. Data federation

  2. Data warehousing

  3. Data virtualization

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

Data federation provides a unified view of data from multiple sources without physically moving the data.

Multiple choice

Which of the following is a common data quality issue that can hinder data integration?

  1. Missing values

  2. Inconsistent data formats

  3. Duplicate data

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

Missing values, inconsistent data formats, and duplicate data are all common data quality issues that can make data integration challenging.

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.