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

What is the term for a software program that helps users manage and organize data?

  1. Word Processor

  2. Spreadsheet

  3. Presentation Software

  4. Database Management System
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

A database management system is a software program that helps users manage and organize data.

Multiple choice

What types of data are used in Legal Analytics?

  1. Legal documents.

  2. Financial data.

  3. Social media data.

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

Legal analytics can use a variety of data types, including legal documents, financial data, social media data, and more.

Multiple choice

What types of data are used in Business Intelligence?

  1. Financial data.

  2. Sales data.

  3. Marketing data.

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

Business intelligence can use a variety of data types, including financial data, sales data, marketing data, and more.

Multiple choice

Which of the following is NOT a common component of an EDSS?

  1. Data management module

  2. Modeling module

  3. Visualization module

  4. Decision support module
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Decision support modules are not typically included in EDSSs, as the primary purpose of an EDSS is to provide information and tools to support decision-making, rather than to make decisions itself.

Multiple choice

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

  1. Accuracy

  2. Completeness

  3. Consistency

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

Timeliness refers to the availability of data within a reasonable time frame, while accuracy, completeness, and consistency are all dimensions of data quality.

Multiple choice

What is the term used to describe the massive volume of data generated by various sources?

  1. Big Data

  2. Data Mining

  3. Data Warehousing

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

Big Data refers to the vast amount of data that is generated from various sources, such as social media, sensors, and business transactions.

Multiple choice

What is the term used to describe the process of storing and managing large datasets in a distributed manner?

  1. Data Warehousing

  2. Data Lake

  3. Data Mart

  4. Data Vault
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Data Lake refers to a central repository for storing large volumes of raw data in its native format, enabling flexible and scalable data storage.

Multiple choice

Which of the following is a popular open-source distributed database for storing and processing large datasets?

  1. MongoDB

  2. Cassandra

  3. HBase

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

MongoDB is a widely used open-source distributed database designed for storing and processing large volumes of data in a flexible and scalable manner.

Multiple choice

What is the principle of 'data minimization' in the context of data privacy?

  1. Collecting only the personal data that is absolutely necessary for a specific purpose

  2. Storing personal data for no longer than necessary

  3. Ensuring that personal data is accurate and up-to-date

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

The principle of data minimization in data privacy encompasses collecting only the personal data that is absolutely necessary for a specific purpose, storing personal data for no longer than necessary, and ensuring that personal data is accurate and up-to-date.

Multiple choice

What is the concept of 'data portability' in the context of data privacy?

  1. The right of individuals to obtain a copy of their personal data in a commonly used and machine-readable format

  2. The right of individuals to transfer their personal data from one organization to another without hindrance

  3. The right of individuals to request that their personal data be erased

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

The concept of data portability in data privacy encompasses the right of individuals to obtain a copy of their personal data in a commonly used and machine-readable format, the right of individuals to transfer their personal data from one organization to another without hindrance, and the right of individuals to request that their personal data be erased.

Multiple choice

Which of the following is NOT a type of migration data?

  1. Census data

  2. Survey data

  3. Administrative data

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

Qualitative data is not a type of migration data.

Multiple choice

Which of the following is NOT a factor to consider when planning the capacity of a data warehouse?

  1. Data volume

  2. Data growth rate

  3. Hardware specifications

  4. User concurrency
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Hardware specifications are not a factor to consider when planning the capacity of a data warehouse, as they are typically determined by the data volume and growth rate, as well as the desired performance level.

Multiple choice

Which estimation technique is commonly used to determine the initial capacity requirements of a data warehouse?

  1. Top-down approach

  2. Bottom-up approach

  3. Workload analysis

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

The top-down approach is commonly used to determine the initial capacity requirements of a data warehouse by estimating the total data volume and growth rate, and then applying a capacity buffer to account for future growth and unexpected spikes in data usage.

Multiple choice

Which of the following is NOT a strategy for optimizing the capacity of a data warehouse?

  1. Data partitioning

  2. Data compression

  3. Data aggregation

  4. Hardware upgrades
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Hardware upgrades are not a strategy for optimizing the capacity of a data warehouse, as they involve replacing or expanding the existing hardware infrastructure, which can be costly and time-consuming.

Multiple choice

What is the primary goal of data partitioning in a data warehouse?

  1. To improve data locality and reduce I/O operations

  2. To distribute data across multiple storage devices

  3. To enhance data security and access control

  4. To optimize query performance
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Data partitioning is primarily used in a data warehouse to improve data locality and reduce I/O operations by dividing the data into smaller, manageable chunks and distributing them across multiple storage devices.