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 key component of data governance?

  1. Data quality management

  2. Data security and privacy

  3. Data lineage and provenance

  4. Data governance council
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The data governance council is a cross-functional team responsible for overseeing and implementing data governance policies and initiatives.

Multiple choice

Which data governance framework is widely adopted by organizations?

  1. Data Governance Maturity Model (DAMA-DMBOK)

  2. ISO/IEC 38500:2019

  3. COBIT 5

  4. NIST Cybersecurity Framework
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The Data Governance Maturity Model (DAMA-DMBOK) is a comprehensive framework that provides guidance on implementing and assessing data governance initiatives.

Multiple choice

What is the relationship between data governance and data management?

  1. Data governance is a subset of data management

  2. Data management is a subset of data governance

  3. Data governance and data management are independent disciplines

  4. Data governance and data management are complementary disciplines
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Data governance and data management are complementary disciplines that work together to ensure the effective and efficient management of data.

Multiple choice

Which of the following is a common metric used to measure the effectiveness of data governance?

  1. Data quality metrics

  2. Data security metrics

  3. Data accessibility metrics

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

Data quality metrics, data security metrics, and data accessibility metrics are commonly used to measure the effectiveness of data governance initiatives.

Multiple choice

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

  1. Hierarchical

  2. Network

  3. Relational

  4. Object-Oriented
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Object-Oriented is a programming paradigm, not a data model.

Multiple choice

What is the process of converting a conceptual data model into a physical data model called?

  1. Normalization

  2. Denormalization

  3. Transformation

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

Mapping involves translating the abstract concepts of a conceptual data model into the specific structures and constraints of a physical database.

Multiple choice

What is the process of combining multiple data sources into a single, consistent data store called?

  1. Data integration

  2. Data warehousing

  3. Data mining

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

Data warehousing involves extracting, transforming, and loading (ETL) data from various sources into a central repository for analysis and reporting.

Multiple choice

Which of the following is a type of data warehouse designed for near-real-time data processing?

  1. Operational data warehouse (ODW)

  2. Data mart

  3. Virtual data warehouse (VDW)

  4. Active data warehouse (ADW)
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

An ADW is a type of data warehouse that supports real-time data updates and transactions, enabling immediate data analysis and decision-making.

Multiple choice

What is the process of identifying and removing redundant data from a database called?

  1. Normalization

  2. Denormalization

  3. Data cleansing

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

Normalization involves decomposing data into smaller, related tables to eliminate redundancy and improve data integrity.

Multiple choice

Which of the following is a technique used to improve query performance in a relational database?

  1. Indexing

  2. Hashing

  3. Clustering

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

Indexing, hashing, and clustering are all techniques used to optimize data access and improve query performance in relational databases.

Multiple choice

What is the process of converting a physical data model into a set of database tables and constraints called?

  1. Schema generation

  2. Schema mapping

  3. Schema transformation

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

Schema implementation involves creating the actual database tables, columns, and constraints based on the physical data model.

Multiple choice

Which of the following is a type of data model that represents data as a collection of objects and their relationships?

  1. Hierarchical

  2. Network

  3. Relational

  4. Object-Oriented
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

An Object-Oriented data model organizes data as a collection of objects, where each object has its own properties and methods.

Multiple choice

Which of the following is a type of data model that represents data as a collection of nodes and edges?

  1. Hierarchical

  2. Network

  3. Relational

  4. Object-Oriented
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

A Network data model represents data as a collection of nodes (entities) and edges (relationships), allowing for complex connections between data items.

Multiple choice

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

  1. Data integration

  2. Data warehousing

  3. Data mining

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

Data integration involves combining data from multiple sources into a single, consistent view, enabling comprehensive analysis and decision-making.

Multiple choice

Which of the following is a type of data model that represents data as a collection of tables and columns?

  1. Hierarchical

  2. Network

  3. Relational

  4. Object-Oriented
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

A Relational data model organizes data into tables, where each table consists of rows (records) and columns (attributes).