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 data integration technique involves using a mediator to translate queries and access data from multiple sources?

  1. Data Warehousing

  2. Data Federation

  3. Data Migration

  4. Extract, Transform, Load (ETL)

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Data federation involves using a mediator to translate queries and access data from multiple sources, allowing users to access data from various sources without requiring a common data model.

Multiple choice

Which data integration technique involves using a data bus to transfer data between different systems?

  1. Data Warehousing

  2. Data Federation

  3. Data Migration

  4. Extract, Transform, Load (ETL)

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Data migration involves using a data bus to transfer data between different systems, typically used when replacing an old system with a new one.

Multiple choice

Which data integration technique involves using a data lake to store and process large volumes of data?

  1. Data Warehousing

  2. Data Federation

  3. Data Migration

  4. Extract, Transform, Load (ETL)

Reveal answer Fill a bubble to check yourself
Correct answer
Explanation

Data lake is a technique for storing and processing large volumes of data in its raw format, typically used for big data analytics.

Multiple choice

Which data integration technique involves using a data mesh to distribute data across multiple domains and services?

  1. Data Warehousing

  2. Data Federation

  3. Data Migration

  4. Data Mesh

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Data mesh is a technique for distributing data across multiple domains and services, allowing for decentralized data management and governance.

Multiple choice

Which data integration technique involves using a hybrid approach that combines multiple data integration techniques?

  1. Data Warehousing

  2. Data Federation

  3. Data Migration

  4. Hybrid Data Integration

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Hybrid data integration involves using a combination of multiple data integration techniques to achieve the desired level of data integration.

Multiple choice

Which type of replication involves creating multiple copies of data on different servers within a single data center?

  1. Synchronous replication

  2. Asynchronous replication

  3. Local replication

  4. Remote replication

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Local replication creates multiple copies of data within a single data center, typically on different servers, to improve data availability and performance.

Multiple choice

Which replication method is commonly used in distributed database systems?

  1. Synchronous replication

  2. Asynchronous replication

  3. Local replication

  4. Remote replication

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Synchronous replication is often preferred in distributed database systems to ensure immediate data consistency, guaranteeing that all database transactions are committed successfully on all replicas.

Multiple choice

Which of the following is an example of a common data format?

  1. Text

  2. Audio

  3. Video

  4. Vector graphics

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Text is an example of a common data format. It is used to represent written language in a digital form.

Multiple choice

Which of the following is a common source of data for library and information research?

  1. Library catalogs

  2. Bibliographic databases

  3. Online resources

  4. All of the above

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Library and information researchers often rely on a variety of data sources, including library catalogs, bibliographic databases, online resources, surveys, interviews, and observational data, to gather information relevant to their research topic.

Multiple choice

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

  1. Accuracy

  2. Completeness

  3. Consistency

  4. Relevance

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

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

Multiple choice

Which of the following is NOT a method for assessing data consistency?

  1. Data profiling

  2. Data validation

  3. Data mining

  4. Data consistency analysis

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Data mining is not a method for assessing data consistency. Data profiling, data validation, and data consistency analysis are all methods that are used to assess data consistency.

Multiple choice

Which of the following is NOT a tool for data quality assessment and evaluation?

  1. Data profiling tools

  2. Data validation tools

  3. Data mining tools

  4. Data visualization tools

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Data mining tools are not tools for data quality assessment and evaluation. Data profiling tools, data validation tools, and data visualization tools are all tools that are used for data quality assessment and evaluation.

Multiple choice

Which of the following is NOT a responsibility of data quality managers?

  1. Developing data quality standards

  2. Monitoring data quality

  3. Improving data quality

  4. Using data quality tools

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Using data quality tools is not a responsibility of data quality managers. Developing data quality standards, monitoring data quality, and improving data quality are all responsibilities of data quality managers.

Multiple choice

Which type of data replication involves maintaining multiple copies of data at different physical locations?

  1. Synchronous Replication

  2. Asynchronous Replication

  3. Semi-synchronous Replication

  4. Logical Replication

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Asynchronous replication involves creating multiple copies of data at different physical locations, but the updates to the data are not immediately propagated to all copies. This allows for faster write operations and reduced network traffic, but it also introduces the possibility of data inconsistency between copies.

Multiple choice

Which type of replication is commonly used for disaster recovery scenarios?

  1. Active-Active Replication

  2. Active-Passive Replication

  3. Semi-synchronous Replication

  4. Logical Replication

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Active-Passive replication involves maintaining one primary copy of the data that is actively used for read and write operations, and one or more secondary copies that are kept in a standby state. In the event of a failure of the primary copy, one of the secondary copies is activated to become the new primary.