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

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 is not a dimension of data quality. The dimensions of data quality typically include accuracy, completeness, consistency, and validity.

Multiple choice

Which of the following is a measure of data completeness?

  1. Percentage of missing values

  2. Number of records with complete data

  3. Ratio of complete data to total data

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

Data completeness can be measured using various metrics. The percentage of missing values indicates the proportion of data that is missing. The number of records with complete data represents the count of records that have all required data fields populated. The ratio of complete data to total data provides an overall assessment of data completeness.

Multiple choice

Which of the following is a common data source for Mine Data Analytics?

  1. Sensor data from mining equipment

  2. Geological data from exploration activities

  3. Historical production records

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

Mine Data Analytics utilizes data from various sources, including sensor data from mining equipment, geological data from exploration activities, historical production records, and other relevant sources.