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
Which data integration technique involves using a mediator to translate queries and access data from multiple sources?
-
Data Warehousing
-
Data Federation
-
Data Migration
-
Extract, Transform, Load (ETL)
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.
Which data integration technique involves using a data bus to transfer data between different systems?
-
Data Warehousing
-
Data Federation
-
Data Migration
-
Extract, Transform, Load (ETL)
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.
Which data integration technique involves using a data lake to store and process large volumes of data?
-
Data Warehousing
-
Data Federation
-
Data Migration
-
Extract, Transform, Load (ETL)
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.
Which data integration technique involves using a data mesh to distribute data across multiple domains and services?
-
Data Warehousing
-
Data Federation
-
Data Migration
-
Data Mesh
D
Correct answer
Explanation
Data mesh is a technique for distributing data across multiple domains and services, allowing for decentralized data management and governance.
Which data integration technique involves using a hybrid approach that combines multiple data integration techniques?
-
Data Warehousing
-
Data Federation
-
Data Migration
-
Hybrid Data Integration
D
Correct answer
Explanation
Hybrid data integration involves using a combination of multiple data integration techniques to achieve the desired level of data integration.
Which type of replication involves creating multiple copies of data on different servers within a single data center?
-
Synchronous replication
-
Asynchronous replication
-
Local replication
-
Remote replication
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.
Which replication method is commonly used in distributed database systems?
-
Synchronous replication
-
Asynchronous replication
-
Local replication
-
Remote replication
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.
Which of the following is an example of a common data format?
-
Text
-
Audio
-
Video
-
Vector graphics
A
Correct answer
Explanation
Text is an example of a common data format. It is used to represent written language in a digital form.
Which of the following is a common source of data for library and information research?
-
Library catalogs
-
Bibliographic databases
-
Online resources
-
All of the above
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.
Which of the following is NOT a dimension of data quality?
-
Accuracy
-
Completeness
-
Consistency
-
Relevance
D
Correct answer
Explanation
Relevance is not a dimension of data quality. The dimensions of data quality are accuracy, completeness, consistency, and timeliness.
Which of the following is NOT a method for assessing data consistency?
-
Data profiling
-
Data validation
-
Data mining
-
Data consistency analysis
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.
Which of the following is NOT a tool for data quality assessment and evaluation?
-
Data profiling tools
-
Data validation tools
-
Data mining tools
-
Data visualization tools
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.
Which of the following is NOT a responsibility of data quality managers?
-
Developing data quality standards
-
Monitoring data quality
-
Improving data quality
-
Using data quality tools
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.
Which type of data replication involves maintaining multiple copies of data at different physical locations?
-
Synchronous Replication
-
Asynchronous Replication
-
Semi-synchronous Replication
-
Logical Replication
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.
Which type of replication is commonly used for disaster recovery scenarios?
-
Active-Active Replication
-
Active-Passive Replication
-
Semi-synchronous Replication
-
Logical Replication
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.