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 best practice for metadata management in data warehousing?

  1. Centralize metadata in a single repository

  2. Standardize metadata definitions and formats

  3. Automate metadata collection and maintenance

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

Centralizing metadata in a single repository, standardizing metadata definitions and formats, and automating metadata collection and maintenance are all common best practices for metadata management in data warehousing.

Multiple choice

Which of the following is NOT a common component of an expert system?

  1. Knowledge base

  2. Inference engine

  3. User interface

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

Databases are not typically considered a core component of expert systems, as they are primarily concerned with storing and managing data, rather than providing expert advice or making decisions.

Multiple choice

Which programming paradigm is characterized by its focus on data and the relationships between data elements?

  1. Procedural Programming

  2. Object-Oriented Programming

  3. Functional Programming

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

Object-Oriented Programming (OOP) is a programming paradigm that revolves around the concept of objects, which are data structures consisting of data fields and methods together with their interactions. This approach emphasizes data encapsulation, modularity, and code reusability.

Multiple choice

Which of the following is a type of database management system (DBMS) that uses a hierarchical data model?

  1. Relational Database

  2. Hierarchical Database

  3. Network Database

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

A Hierarchical Database is a type of DBMS that organizes data in a tree-like structure. It consists of parent-child relationships, where each parent can have multiple children, but each child can have only one parent.

Multiple choice

What is the primary purpose of the pandas.DataFrame object in Python?

  1. Storing and manipulating tabular data

  2. Performing numerical computations

  3. Creating visualizations

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

The pandas.DataFrame object is a two-dimensional, size-mutable, potentially heterogeneous tabular data structure with labeled axes (rows and columns).

Multiple choice

What is the load factor of a hash table?

  1. The ratio of the number of data items to the number of slots in the hash table

  2. The number of collisions that occur in the hash table

  3. The average number of data items stored in each slot of the hash table

  4. The maximum number of data items that can be stored in the hash table
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The load factor of a hash table is the ratio of the number of data items stored in the hash table to the number of slots available in the hash table. It is a measure of how full the hash table is and can affect the efficiency of data retrieval operations.

Multiple choice

Which of the following is NOT a common type of metadata in a geographical database?

  1. Data dictionary

  2. Lineage

  3. Spatial reference system

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

Projection is not a type of metadata, but rather a transformation applied to the data to display it in a particular way.

Multiple choice

Which of the following is NOT a common standard for metadata in geographical databases?

  1. ISO 19115

  2. FGDC CSDGM

  3. Dublin Core

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

SDMX is not a common standard for metadata in geographical databases.

Multiple choice

Which of the following is NOT a common type of data dictionary in a geographical database?

  1. Entity-relationship diagram

  2. Attribute table

  3. Feature catalog

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

Layer file is not a type of data dictionary, but rather a file that defines the symbology and other properties of a layer in a GIS.

Multiple choice

Which of the following is NOT a common type of lineage report in a geographical database?

  1. Data lineage diagram

  2. Metadata report

  3. Data provenance report

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

Data quality report is not a type of lineage report, but rather a report that assesses the quality of the data in the database.

Multiple choice

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

  1. Vector Data

  2. Raster Data

  3. Attribute Data

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

Metadata is information about data, such as its source, accuracy, and format. It is not a type of spatial data.

Multiple choice

Which of the following is NOT a common type of personal data processed in engineering systems?

  1. Names

  2. Addresses

  3. Financial information

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

Medical records are not a common type of personal data processed in engineering systems. Names, addresses, and financial information are more common types of personal data processed in engineering systems.

Multiple choice

Which of the following is NOT a common type of electronic evidence presented in court?

  1. Spreadsheets

  2. Databases

  3. Audio recordings

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

Physical documents, such as paper contracts or handwritten notes, are not considered electronic evidence and are typically presented in court in their original form.

Multiple choice

The term "Big Data" refers to:

  1. Large volumes of data

  2. High-speed data processing

  3. Data visualization techniques

  4. Cloud computing platforms
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Big Data refers to large volumes of data that are difficult to manage and process using traditional methods.

Multiple choice

What is the best way to improve the performance of a geographical database?

  1. Use a faster processor.

  2. Use more RAM.

  3. Use a solid-state drive (SSD).

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

All of the above can help to improve the performance of a geographical database. A faster processor, more RAM, and an SSD can all help to speed up data processing and retrieval.