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 of the following is a common data quality issue?

  1. Missing values

  2. Inconsistent data

  3. Duplicate data

  4. Outdated data

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

All of the above are common data quality issues.

Multiple choice

Which of the following is a data quality metric?

  1. Accuracy

  2. Completeness

  3. Consistency

  4. Timeliness

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

Accuracy, completeness, consistency, and timeliness are all data quality metrics.

Multiple choice

Which of the following is a data quality best practice?

  1. Use data profiling to identify data quality issues

  2. Use data cleansing to correct data quality issues

  3. Use data validation to ensure that data is accurate

  4. Use data governance to manage data quality

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

All of the above are data quality best practices.

Multiple choice

What are the three main types of data quality issues?

  1. Accuracy, completeness, and consistency

  2. Timeliness, relevance, and usability

  3. Security, privacy, and compliance

  4. All of the above

  5. None of the above
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The three main types of data quality issues are accuracy, completeness, and consistency.

Multiple choice

What are the four main dimensions of data quality?

  1. Accuracy, completeness, consistency, and timeliness

  2. Relevance, usability, value, and trustworthiness

  3. Security, privacy, compliance, and auditability

  4. All of the above

  5. None of the above
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The four main dimensions of data quality are accuracy, completeness, consistency, and timeliness.

Multiple choice

What is the role of Recovery Point Objective (RPO) in IaaS Backup and Recovery?

  1. It defines the maximum acceptable amount of data loss that can occur before a backup is considered successful.

  2. It defines the maximum amount of time that can elapse between the occurrence of a data loss event and the restoration of data from a backup.

  3. It defines the maximum amount of time that can elapse between the creation of a backup and the expiration of the backup.

  4. It defines the maximum number of backups that can be stored before older backups are deleted.
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Recovery Point Objective (RPO) defines the maximum acceptable amount of data loss that can occur before a backup is considered successful. It is a critical metric in IaaS Backup and Recovery as it determines the frequency of backups and the amount of data that can be lost in the event of a disaster.

Multiple choice

What is the purpose of a Recovery Time Objective (RTO) in IaaS Backup and Recovery?

  1. To define the maximum amount of time that can elapse between the occurrence of a data loss event and the restoration of data from a backup.

  2. To define the maximum amount of data loss that can occur before a backup is considered successful.

  3. To define the maximum amount of time that can elapse between the creation of a backup and the expiration of the backup.

  4. To define the maximum number of backups that can be stored before older backups are deleted.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Recovery Time Objective (RTO) defines the maximum amount of time that can elapse between the occurrence of a data loss event and the restoration of data from a backup. It is a critical metric in IaaS Backup and Recovery as it determines the speed at which data and systems can be recovered in the event of a disaster.

Multiple choice

What is the role of a Backup Window in IaaS Backup and Recovery?

  1. It defines the specific time period during which backups are scheduled to occur.

  2. It defines the maximum amount of time that can elapse between the creation of a backup and the expiration of the backup.

  3. It defines the maximum amount of data loss that can occur before a backup is considered successful.

  4. It defines the maximum number of backups that can be stored before older backups are deleted.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

A Backup Window defines the specific time period during which backups are scheduled to occur. It is important to select a backup window that minimizes the impact on production workloads and ensures that backups are completed successfully.

Multiple choice

What is the 'right to data portability' under GDPR?

  1. The right to receive one's personal data from a data controller in a structured, commonly used, and machine-readable format

  2. The right to have one's personal data transferred to another data controller

  3. The right to have one's personal data erased from the records of the data controller

  4. The right to object to the processing of one's personal data
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The 'right to data portability' under GDPR is the right to receive one's personal data from a data controller in a structured, commonly used, and machine-readable format.

Multiple choice

What is the Adoption and Foster Care Analysis and Reporting System (AFCARS)?

  1. A national database that collects data on children in foster care and adoption.

  2. A national database that collects data on children in foster care only.

  3. A national database that collects data on children in adoption only.

  4. A national database that collects data on children in foster care and adoption, as well as data on children who are at risk of entering foster care.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The Adoption and Foster Care Analysis and Reporting System (AFCARS) is a national database that collects data on children in foster care and adoption. AFCARS data is used to track the well-being of children in foster care and adoption, and to identify areas where improvements can be made.

Multiple choice

Which certification is best suited for individuals with experience in NoSQL databases?

  1. Certified NoSQL Developer (CND)

  2. Certified NoSQL Administrator (CNA)

  3. Certified NoSQL Architect (CNA)

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

All of the above certifications are relevant for individuals with experience in NoSQL databases.

Multiple choice

Which data privacy principle emphasizes the transparency and accountability of data processing?

  1. Data minimization

  2. Data accuracy

  3. Data subject rights

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

Data subject rights emphasize the transparency and accountability of data processing, giving individuals control over their personal data and the right to access, rectify, or erase it.

Multiple choice

Which data privacy principle emphasizes the accuracy and reliability of data processing?

  1. Data minimization

  2. Data accuracy

  3. Data subject rights

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

Data accuracy emphasizes the importance of maintaining accurate and reliable data, ensuring that data processing results are based on correct and up-to-date information.

Multiple choice

What are the three main types of data integration?

  1. Physical data integration, logical data integration, and virtual data integration.

  2. Data warehousing, data marting, and data federation.

  3. ETL, ELT, and data virtualization.

  4. Data cleansing, data transformation, and data enrichment.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The three main types of data integration are physical data integration, logical data integration, and virtual data integration. Physical data integration involves physically combining data from multiple sources into a single database or data warehouse. Logical data integration involves creating a single, unified view of data from multiple sources without physically combining the data. Virtual data integration involves creating a virtual view of data from multiple sources that can be accessed as if it were a single, unified database.

Multiple choice

What is the difference between data warehousing and data marting?

  1. Data warehousing is a centralized approach to data integration, while data marting is a decentralized approach.

  2. Data warehousing is used for operational reporting, while data marting is used for analytical reporting.

  3. Data warehousing is typically used by large organizations, while data marting is typically used by small and medium-sized organizations.

  4. Data warehousing is more expensive than data marting.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Data warehousing is a centralized approach to data integration, in which data from multiple sources is physically combined into a single database or data warehouse. Data marting is a decentralized approach to data integration, in which data from multiple sources is stored in separate data marts that are designed for specific business purposes.