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 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 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

What is the role of data lineage in Big Data Analytics Governance?

  1. To track the movement of data across systems

  2. To identify the source and transformation of data

  3. To ensure data quality and accuracy

  4. To facilitate data discovery and exploration
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Data lineage provides a historical record of data movement, allowing organizations to trace the origin, transformation, and usage of data assets.

Multiple choice

What is the purpose of data classification in Big Data Analytics Governance?

  1. To identify and categorize data based on its sensitivity and criticality

  2. To ensure data is stored and processed in appropriate systems

  3. To facilitate data access and sharing among authorized users

  4. To optimize data storage and processing costs
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Data classification involves categorizing data into different levels of sensitivity, such as public, internal, confidential, or highly confidential, to determine appropriate security measures and access controls.

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.

Multiple choice

Which of the following is NOT a typical component of 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.

Multiple choice

Which of the following is NOT a typical component of 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.

Multiple choice

Which of the following is a common method for storing environmental data?

  1. Relational databases

  2. NoSQL databases

  3. Data warehouses

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

Data lakes are commonly used for storing environmental data due to their ability to handle large volumes of data in various formats.