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 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 in a timely manner and is not a dimension of data quality.

Multiple choice

What is the term used to describe the degree to which data is free from errors?

  1. Data accuracy

  2. Data completeness

  3. Data consistency

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

Data accuracy refers to the extent to which data is free from errors and represents the true value of the attribute it represents.

Multiple choice

Which of the following is a common cause of data inaccuracy?

  1. Data entry errors

  2. Data transmission errors

  3. Data storage errors

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

Data entry errors occur when data is incorrectly entered into a system, leading to inaccurate data.

Multiple choice

Which of the following is a technique used to ensure data consistency?

  1. Data validation

  2. Data profiling

  3. Data standardization

  4. Data integration
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Data standardization involves converting data into a consistent format to ensure uniformity and comparability.

Multiple choice

What is the term used to describe the degree to which data is complete and contains all the necessary information?

  1. Data accuracy

  2. Data completeness

  3. Data consistency

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

Data completeness refers to the extent to which data contains all the necessary information and is not missing any important values.

Multiple choice

Which of the following is a common cause of data incompleteness?

  1. Data entry errors

  2. Data transmission errors

  3. Data storage errors

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

Data entry errors can lead to missing values or incorrect data, resulting in data incompleteness.

Multiple choice

What is the process of combining data from different sources into a single, consistent dataset called?

  1. Data validation

  2. Data cleansing

  3. Data integration

  4. Data harmonization
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Data integration involves combining data from different sources into a single, consistent dataset to improve its usability and accessibility.

Multiple choice

What is the term used to describe the degree to which data is consistent with itself and with other related data?

  1. Data accuracy

  2. Data completeness

  3. Data consistency

  4. Data integrity
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Data consistency refers to the extent to which data is consistent with itself and with other related data, ensuring that it is reliable and trustworthy.

Multiple choice

Which of the following is a common cause of data inconsistency?

  1. Data entry errors

  2. Data transmission errors

  3. Data storage errors

  4. Data processing errors
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Data processing errors can lead to inconsistencies in data, such as incorrect calculations or missing values.

Multiple choice

What is the term used for the use of big data analytics in financial services?

  1. Big Data Finance

  2. Data-Driven Finance

  3. Analytics-Powered Finance

  4. Information-Based Finance
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Big Data Finance refers to the use of big data analytics in financial services to extract insights from large volumes of data to improve decision-making, risk management, and customer targeting.

Multiple choice

Which of the following is a key principle of the NDSF?

  1. Data should be shared in a timely and efficient manner.

  2. Data should be shared in a secure and privacy-preserving manner.

  3. Data should be shared in a non-discriminatory manner.

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

All of the above are key principles of the NDSF.

Multiple choice

Which of the following is a key element of the NDSP?

  1. Data sharing agreements

  2. Data security measures

  3. Data privacy measures

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

All of the above are key elements of the NDSP.

Multiple choice

Which of the following is a key element of the NDSS?

  1. Data formats

  2. Data exchange mechanisms

  3. Data quality standards

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

All of the above are key elements of the NDSS.

Multiple choice

What types of data are typically collected and managed in coastal and marine data management systems?

  1. Physical data, such as water temperature, salinity, and wave height.

  2. Biological data, such as species distribution and abundance.

  3. Chemical data, such as nutrient concentrations and pollutants.

  4. Socioeconomic data, such as population density and economic activity.

  5. All of the above.
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

Coastal and marine data management systems typically collect and manage a wide range of data types, including physical, biological, chemical, and socioeconomic data. This data is used to provide a comprehensive understanding of coastal and marine environments and to inform decision-making.

Multiple choice

Which of the following is a common security threat to data warehouses?

  1. SQL injection

  2. Cross-site scripting

  3. Buffer overflow

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

Data warehouses are often targeted by attackers because they contain valuable data. SQL injection, cross-site scripting, and buffer overflow are all common security threats that can be used to compromise data warehouses.