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 process of ensuring that data is consistent across different systems and applications called?

  1. Data integration

  2. Data warehousing

  3. Data governance

  4. Data quality management

  5. Data mining
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Data integration is the process of ensuring that data is consistent across different systems and applications.

Multiple choice

Which data quality management strategy focuses on preventing errors from entering the data in the first place?

  1. Data profiling

  2. Data cleansing

  3. Data integration

  4. Data governance

  5. Data mining
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Data governance focuses on preventing errors from entering the data in the first place by establishing policies, standards, and procedures for data management.

Multiple choice

Which data quality management strategy focuses on monitoring data quality and taking corrective actions when necessary?

  1. Data profiling

  2. Data cleansing

  3. Data integration

  4. Data governance

  5. Data quality monitoring
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

Data quality monitoring focuses on monitoring data quality and taking corrective actions when necessary.

Multiple choice

Which data quality management strategy focuses on improving the overall quality of data over time?

  1. Data profiling

  2. Data cleansing

  3. Data integration

  4. Data governance

  5. Data quality improvement
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

Data quality improvement focuses on improving the overall quality of data over time by implementing continuous improvement initiatives.

Multiple choice

Which data quality management strategy focuses on establishing a common understanding of data quality requirements?

  1. Data profiling

  2. Data cleansing

  3. Data integration

  4. Data governance

  5. Data quality standardization
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

Data quality standardization focuses on establishing a common understanding of data quality requirements.

Multiple choice

What was the name of the first commercially successful database management system for personal computers?

  1. dBASE II

  2. Oracle

  3. Microsoft Access

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

dBASE II, developed by Ashton-Tate, was the first commercially successful database management system for personal computers, released in 1983.

Multiple choice

Which of the following is a common data cleaning technique?

  1. Data scrubbing

  2. Data validation

  3. Data standardization

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

Data scrubbing, data validation, and data standardization are all common data cleaning techniques. Data scrubbing involves removing errors and inconsistencies from the data, data validation involves checking the accuracy and consistency of data, and data standardization involves converting data into a consistent format.

Multiple choice

Which of the following is a common data preprocessing technique for dealing with categorical variables?

  1. One-hot encoding

  2. Label encoding

  3. Binary encoding

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

One-hot encoding, label encoding, and binary encoding are all common data preprocessing techniques for dealing with categorical variables. One-hot encoding involves creating a new column for each category, label encoding involves assigning a unique integer to each category, and binary encoding involves creating a new column for each category and assigning a 1 or 0 to indicate the presence or absence of the category.

Multiple choice

Which of the following is a key component of Data Governance?

  1. Data Quality Management

  2. Data Security and Privacy

  3. Data Lineage and Provenance

  4. Data Integration and Interoperability
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Data Quality Management is a crucial aspect of Data Governance, as it focuses on ensuring the accuracy, completeness, consistency, and validity of data.

Multiple choice

Which of the following is a common data quality dimension?

  1. Accuracy

  2. Completeness

  3. Consistency

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

Accuracy, Completeness, Consistency, and Timeliness are all fundamental dimensions of data quality.

Multiple choice

Which of the following is a common Data Governance framework?

  1. Data Management Body of Knowledge (DMBOK)

  2. ISO/IEC 38500:2019

  3. COBIT 2019

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

DMBOK, ISO/IEC 38500:2019, and COBIT 2019 are widely recognized Data Governance frameworks.

Multiple choice

Which of the following is a common Data Quality tool?

  1. Data Profiling Tools

  2. Data Validation Tools

  3. Data Cleansing Tools

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

Data Profiling Tools, Data Validation Tools, and Data Cleansing Tools are commonly used for Data Quality improvement.

Multiple choice

Which of the following is an example of a data exchange format commonly used in digital archives?

  1. XML

  2. JSON

  3. CSV

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

XML (Extensible Markup Language), JSON (JavaScript Object Notation), and CSV (Comma-Separated Values) are widely used data exchange formats in digital archives due to their flexibility, interoperability, and ease of use.

Multiple choice

Which of the following is a common data transformation technique used in ETL processes?

  1. Data cleansing

  2. Data standardization

  3. Data aggregation

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

Common data transformation techniques used in ETL processes include data cleansing (correcting errors and inconsistencies), data standardization (converting data into a consistent format), and data aggregation (combining multiple data records into a single record).

Multiple choice

Which of the following is a common data integration architecture?

  1. Hub-and-spoke architecture

  2. Data federation architecture

  3. Data warehouse architecture

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

Common data integration architectures include hub-and-spoke architecture (centralized data warehouse with multiple data sources), data federation architecture (data sources remain independent but are integrated through a virtual layer), and data warehouse architecture (centralized repository of data from multiple sources).