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 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 NOT a common type of data used in Systems Biology research?

  1. Gene expression data

  2. Protein-protein interaction data

  3. Metabolic flux data

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

Weather data is not commonly used in Systems Biology research, which primarily focuses on molecular interactions and behaviors within biological systems.

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.

Multiple choice

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

  1. Data-centric approach

  2. Accountability and responsibility

  3. Transparency and communication

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

Data Governance is guided by key principles such as a data-centric approach, accountability and responsibility for data management, and transparency and communication among stakeholders to ensure effective data governance practices.

Multiple choice

Which of the following is a common data warehouse architecture?

  1. Single-tier architecture

  2. Two-tier architecture

  3. Three-tier architecture

  4. Four-tier architecture
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

A three-tier data warehouse architecture consists of a data source tier, a data warehouse tier, and a client tier, providing scalability, flexibility, and improved performance.

Multiple choice

What is the process of extracting, transforming, and loading data into a data warehouse called?

  1. Data integration

  2. Data cleansing

  3. Data warehousing

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

Data integration involves extracting data from various sources, transforming it to a consistent format, and loading it into the data warehouse, ensuring data accuracy and consistency.

Multiple choice

Which of the following is a common data modeling technique used in data warehousing?

  1. Star schema

  2. Snowflake schema

  3. Fact constellation schema

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

Dimensional modeling is a widely used data modeling technique in data warehousing that organizes data into fact tables and dimension tables, making it suitable for efficient data analysis and reporting.

Multiple choice

What is the role of a data mart in a data warehousing environment?

  1. To store detailed data for specific business units

  2. To provide real-time data access to users

  3. To facilitate data mining and analysis

  4. To integrate data from multiple sources
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

A data mart is a subset of a data warehouse that stores detailed data relevant to a specific business unit or department, enabling faster and more focused data analysis and reporting.

Multiple choice

Which of the following is a key component of business intelligence?

  1. Data visualization

  2. Data mining

  3. Data warehousing

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

Data visualization is a crucial component of business intelligence that involves presenting data in a graphical or visual format, making it easier for users to understand and derive insights from complex data.

Multiple choice

Which of the following is a common database management system used in web application development?

  1. MySQL

  2. PostgreSQL

  3. MongoDB

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

MySQL, PostgreSQL, and MongoDB are all popular database management systems used in web application development.