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

Multiple choice

Which type of replication technique involves replicating changes to the data at the logical level?

  1. Physical Replication

  2. Logical Replication

  3. Synchronous Replication

  4. Asynchronous Replication

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

Logical replication involves replicating changes to the data at the logical level, meaning that the actual data values are not replicated. Instead, the changes are captured as a series of operations (e.g., INSERT, UPDATE, DELETE) and applied to the replica.

Multiple choice

Which type of replication technique is commonly used for data warehousing and business intelligence applications?

  1. Physical Replication

  2. Logical Replication

  3. Synchronous Replication

  4. Asynchronous Replication

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

Logical replication is commonly used for data warehousing and business intelligence applications because it allows for the replication of data from multiple sources into a central repository. This enables the creation of a single, consistent view of the data for analysis and reporting purposes.

Multiple choice

Which documentation technique involves creating a visual representation of data?

  1. Graph

  2. Chart

  3. Table

  4. Diagram

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

A graph is a visual representation of data that shows the relationship between two or more variables.

Multiple choice

Which of the following is NOT a typical phase in the Data Lifecycle Management process?

  1. Data Creation

  2. Data Storage

  3. Data Archiving

  4. Data Destruction

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

Data Archiving is not a typical phase in the DLM process. Instead, it is a specific storage strategy used to manage inactive data.

Multiple choice

What is the purpose of data classification in DLM and ILM?

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

  2. To determine the appropriate storage and retention policies for different types of data

  3. To facilitate data access and retrieval

  4. To protect data from unauthorized access

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

Data classification is used in DLM and ILM to identify and categorize data based on its sensitivity and importance, which helps in determining the appropriate storage and retention policies, as well as the level of security required.

Multiple choice

What is the role of metadata in DLM and ILM?

  1. To provide information about the data and its lifecycle stages

  2. To facilitate data discovery and retrieval

  3. To ensure data integrity and consistency

  4. To protect data from unauthorized access

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

Metadata plays a crucial role in DLM and ILM by providing information about the data, its lifecycle stages, and its characteristics, which helps in managing and tracking the data throughout its lifecycle.

Multiple choice

What is the primary goal of data migration in DLM and ILM?

  1. To move data from one storage system to another

  2. To improve data accessibility and performance

  3. To ensure data integrity and consistency

  4. To comply with regulatory requirements

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

The primary goal of data migration in DLM and ILM is to move data from one storage system to another, often to improve data accessibility, performance, or to comply with regulatory requirements.

Multiple choice

What is the best way to ensure the integrity of research data?

  1. Use data validation techniques

  2. Back up research data regularly

  3. Store research data in a secure location

  4. All of the above

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

All of the above are important steps for ensuring the integrity of research data. Data validation techniques help to identify and correct errors in research data. Backing up research data regularly helps to protect against accidental data loss or destruction. Storing research data in a secure location helps to prevent unauthorized access and accidental data loss or destruction.

Multiple choice

Which of the following is a key factor to consider when planning a data migration project?

  1. Data volume

  2. Data type

  3. Data sensitivity

  4. All of the above

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

When planning a data migration project, it is essential to consider various factors such as data volume, data type, data sensitivity, and the complexity of the migration process.