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 NOT a common data profiling technique?

  1. Data Summarization

  2. Data Visualization

  3. Data Lineage Analysis

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

Data integration is not a common data profiling technique. Data summarization, data visualization, and data lineage analysis are all common data profiling techniques used to understand the characteristics and quality of data.

Multiple choice

Which of the following is an example of a common standard developed by the IVOA to address data security and privacy challenges?

  1. The IVOA Data Access Layer (DAL)

  2. The IVOA Resource Metadata Schema (RMS)

  3. The IVOA Security Profile (SP)

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

The DAL, the RMS, and the SP are all examples of common standards developed by the IVOA to address data security and privacy challenges.

Multiple choice

Which of the following factors can affect the choice of data resolution for a particular application?

  1. The purpose of the application

  2. The availability of data

  3. The cost of data

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

The choice of data resolution for a particular application can be influenced by several factors, including the purpose of the application, the availability of data, and the cost of data.

Multiple choice

Which of the following is an example of a data integration technique?

  1. Spatial join

  2. Buffering

  3. Interpolation

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

Spatial join is an example of a data integration technique. It involves combining two or more data layers based on their spatial relationships.

Multiple choice

Which of the following is an example of a data transformation technique?

  1. Normalization

  2. Standardization

  3. Aggregation

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

Normalization is an example of a data transformation technique. It involves rescaling data to a common range or distribution.

Multiple choice

Which of the following is NOT a type of health data?

  1. Vital statistics

  2. Hospital discharge data

  3. Behavioral risk factor data

  4. Environmental health data

  5. Genomic data
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

Genomic data is not typically considered health data, as it is not directly related to the health status of an individual or population.

Multiple choice

Which of the following is NOT a dimension of data quality?

  1. Accuracy

  2. Completeness

  3. Timeliness

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

Relevance is not a dimension of data quality. The three main dimensions of data quality are accuracy, completeness, and timeliness.

Multiple choice

What are the key components of GDI?

  1. Data

  2. Metadata

  3. Services

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

The key components of GDI include data, metadata, services, and standards.

Multiple choice

Which of the following is NOT a best practice for GDI implementation?

  1. Data Sharing

  2. Metadata

  3. Data Integration

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

Data security is not a best practice for GDI implementation. Instead, data sharing, metadata, and data integration are considered best practices.

Multiple choice

Which of the following is NOT a key component of GDI?

  1. Data

  2. Metadata

  3. Technology

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

Technology is not a key component of GDI. Instead, data, metadata, and people are considered key components.

Multiple choice

Which of the following is NOT a best practice for metadata management in GDI implementation?

  1. Use standardized metadata schemas

  2. Provide comprehensive metadata

  3. Keep metadata up-to-date

  4. Store metadata in a central repository
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Storing metadata in a central repository is not a best practice for metadata management in GDI implementation. Instead, using standardized metadata schemas, providing comprehensive metadata, and keeping metadata up-to-date are considered best practices.

Multiple choice

Which of the following is a common strategy for preserving digital historical records?

  1. Migration

  2. Emulation

  3. Encapsulation

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

Migration, emulation, and encapsulation are all common strategies for preserving digital historical records. Migration involves transferring the records to a new storage medium or format. Emulation involves creating a software environment that simulates the original hardware and software used to create the records. Encapsulation involves wrapping the records in a self-contained package that includes all of the necessary information to access and interpret them.

Multiple choice

Which of the following is a common type of metadata used in the preservation of digital historical records?

  1. Descriptive metadata

  2. Administrative metadata

  3. Technical metadata

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

Descriptive metadata provides information about the content and structure of the records, administrative metadata provides information about the management and control of the records, and technical metadata provides information about the format and technical characteristics of the records.

Multiple choice

Which of the following is a common standard used in the preservation of digital historical records?

  1. The Open Archival Information System (OAIS) model

  2. The Metadata Encoding and Transmission Standard (METS)

  3. The Dublin Core Metadata Initiative (DCMI)

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

The OAIS model provides a framework for the management and preservation of digital records, METS is a standard for encoding and transmitting metadata, and DCMI is a standard for describing digital resources.

Multiple choice

Which of the following costs is typically NOT included in a data warehousing cost-benefit analysis?

  1. Hardware and software costs

  2. Data acquisition costs

  3. Data integration costs

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

Data acquisition costs are typically not included in a data warehousing cost-benefit analysis because they are considered to be sunk costs, which are costs that have already been incurred and cannot be recovered.