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
  1. Network model

  2. Object oriented model

  3. Object based

  4. E-R model

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The Network model is a record-based logical data model that organizes data in a graph structure with records as nodes and relationships as edges. The Object-oriented model is object-based, not record-based. The E-R model is a conceptual modeling tool, not a logical model. Object-based is a category, not a specific model.

Multiple choice
  1. Physical

  2. Logical

  3. View

  4. None of above

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Data abstraction has three levels: Physical (lowest), Logical (middle), and View (highest). The View level provides the highest level of abstraction by showing users only the data they need without exposing underlying structures. It simplifies data access by hiding complexity.

Multiple choice
  1. Only 1

  2. Only 2

  3. Both 1 and 2

  4. Neither 1 nor 2

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

MIS (Management Information Systems) handles structured, routine decisions using predefined reports and data - it's NOT designed for unstructured problems. DSS (Decision Support Systems) specifically addresses unstructured decisions through analytical models, what-if analysis, and specialized databases. Statement 2 correctly describes DSS architecture.

Multiple choice
  1. BOINC

  2. SIMAP

  3. TreeFam

  4. InterPro

  5. ModBase

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Correct answer. TreeFam is a database of evolutionary trees of animal genes which aims at developing a curated resource that gives reliable information about ortholog and paralog assignments, and evolutionary history of various gene families.

Multiple choice
  1. Repository

  2. Data warehouse

  3. RAD

  4. CASE

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

A data warehouse is a centralized repository that stores all information collected during database development, designed for query, analysis, and reporting. A repository typically stores metadata, RAD is a methodology, and CASE is a category of development tools.