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 role of data pipelines in real-time data integration?

  1. To extract, transform, and load data from various sources

  2. To ensure data consistency and integrity

  3. To provide real-time data access and analysis

  4. To manage data storage and retrieval
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Data pipelines play a crucial role in real-time data integration by continuously extracting data from different sources, transforming it into a consistent format, and loading it into a central repository for further analysis and processing.

Multiple choice

Which of the following is a common data integration technique?

  1. Data warehousing

  2. Data mining

  3. Machine learning

  4. Natural language processing
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Data warehousing is a widely used data integration technique that involves storing data from multiple sources in a central repository, known as a data warehouse, for analysis and reporting.

Multiple choice

What is the role of data transformation in data integration?

  1. To convert data from one format to another

  2. To remove duplicate data from a dataset

  3. To select specific data from a larger dataset

  4. To aggregate data from multiple sources
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Data transformation involves converting data from one format to another, such as from a raw format to a structured format, or from one data type to another, to ensure compatibility and consistency across different data sources.

Multiple choice

Which of the following is a common data integration architecture?

  1. Hub-and-spoke architecture

  2. Data lake architecture

  3. Data warehouse architecture

  4. Master data management architecture
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Data warehouse architecture is a widely adopted data integration architecture where data from various sources is extracted, transformed, and loaded into a central repository, known as a data warehouse, for analysis and reporting.

Multiple choice

Which of the following is NOT a common data source for data analytics?

  1. Social Media Platforms

  2. Relational Databases

  3. Spreadsheets

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

Satellite Imagery is typically used for geospatial analysis, not general data analytics.

Multiple choice

What is the term used to describe data that is generated in real-time?

  1. Streaming Data

  2. Batch Data

  3. Structured Data

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

Streaming Data refers to data that is continuously generated and transmitted in real-time.

Multiple choice

Which of the following is an example of a structured data type?

  1. JSON

  2. XML

  3. CSV

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

CSV (Comma-Separated Values) is a structured data format where data is organized into rows and columns, separated by commas.

Multiple choice

What is the term used to describe data that does not have a predefined structure or format?

  1. Structured Data

  2. Semi-Structured Data

  3. Unstructured Data

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

Unstructured Data refers to data that does not conform to a specific structure or format, such as text, images, or videos.

Multiple choice

Which of the following is an example of a semi-structured data type?

  1. JSON

  2. XML

  3. CSV

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

JSON (JavaScript Object Notation) is a semi-structured data format that uses key-value pairs to represent data.

Multiple choice

What is the term used to describe data that is stored in a relational database management system?

  1. Structured Data

  2. Semi-Structured Data

  3. Unstructured Data

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

Relational Data refers to data that is stored in tables, with rows and columns, and related to each other through primary and foreign keys.

Multiple choice

Which of the following is an example of a NoSQL database?

  1. MySQL

  2. PostgreSQL

  3. MongoDB

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

MongoDB is a NoSQL database that uses a document-oriented data model, where data is stored in JSON-like documents.

Multiple choice

What are some of the most important legal research databases?

  1. LexisNexis

  2. Westlaw

  3. Bloomberg Law

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

LexisNexis, Westlaw, and Bloomberg Law are all major legal research databases that provide access to a wide range of legal materials.

Multiple choice

Which of the following is NOT a common data format used in Astroinformatics?

  1. FITS

  2. CSV

  3. JSON

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

CSV (Comma-Separated Values) is not a common data format specifically used in Astroinformatics, although it can be used for general data storage and exchange.

Multiple choice

Which preservation strategy involves converting digital data into a standardized format?

  1. Normalization.

  2. Digitization.

  3. Migration.

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

Normalization is a preservation strategy that involves converting digital data into a standardized format, often based on open standards, to ensure its long-term accessibility and compatibility with different systems.

Multiple choice

Which preservation approach involves creating multiple copies of digital data and storing them in different locations?

  1. Data Replication.

  2. Data Migration.

  3. Data Encryption.

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

Data Replication is a preservation approach that involves creating multiple copies of digital data and storing them in different locations to ensure redundancy and protect against data loss or corruption.