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 technology
  1. Persistent

  2. Non Persistent

  3. cant say

  4. dont know

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

Persistent objects in Documentum are those stored in the RDBMS and survive beyond the session that created them. These objects maintain their state and data in the database, allowing them to be retrieved and used across different user sessions and server restarts.

Multiple choice technology
  1. Three

  2. Two

  3. Four

  4. One

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

Each persistent object in Documentum is represented by two tables in the RDBMS: one table stores the object's type-specific attributes (custom fields), while another table stores system attributes like object ID, creation date, and owner information common to all objects.

Multiple choice technology databases
  1. network

  2. relational

  3. hierarchical

  4. object-oriented

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

IMS DB uses hierarchical database management, organizing data in a tree structure with parent-child relationships. This is faster than network or relational models for certain access patterns.

Multiple choice technology databases
  1. multiple DBD s for each database

  2. none of these

  3. cannot be used by DL/I

  4. created by a process called DBDGEN

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

A Database Description (DBD) defines the physical structure of an IMS database and is compiled using the DBDGEN utility. There is one DBD per physical database, and it is required by DL/I to interpret the database structures.

Multiple choice technology databases
  1. network

  2. relational

  3. hierarchical

  4. object-oriented

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

IMS DB uses hierarchical database management, organizing data in a tree structure with parent-child relationships. This is faster than network or relational models for certain access patterns.

Multiple choice technology databases
  1. multiple DBD s for each database

  2. none of these

  3. cannot be used by DL/I

  4. created by a process called DBDGEN

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

DBD (Database Descriptor) is created by the DBDGEN utility process. Each database has exactly one DBD, and DL/I uses DBDs to access databases.

Multiple choice technology databases
  1. network

  2. relational

  3. hierarchical

  4. object-oriented

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

IMS (Information Management System) DB uses a hierarchical database management model, organizing data in a tree-like structure with parent-child relationships. This is different from network (many-to-many), relational (table-based), or object-oriented databases. The hierarchical model is fundamental to IMS architecture.

Multiple choice technology databases
  1. multiple DBD s for each database

  2. none of these

  3. cannot be used by DL/I

  4. created by a process called DBDGEN

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

DBD (Database Descriptor) is created through a process called DBDGEN, which compiles DBD source statements into a usable database descriptor. Each database has exactly one DBD, and it is essential for DL/I (Data Language/I) operations. The statement 'multiple DBDs for each database' is false, and DBDs are required by DL/I, not unusable.

Multiple choice technology databases
  1. network

  2. relational

  3. hierarchical

  4. object-oriented

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

IMS DB is a classic hierarchical database management system where data is organized into parent-child segment relationships. It does not use relational tables, network pointer structures, or object-oriented design as its primary database organization.

Multiple choice technology databases
  1. multiple DBD s for each database

  2. cannot be used by DL/I

  3. created by a process called DBDGEN

  4. none of these

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

DBD (Database Descriptor) is created through a process called DBDGEN, which compiles DBD source statements into a usable database descriptor. Each database has exactly one DBD, and it is essential for DL/I (Data Language/I) operations. The statement 'multiple DBDs for each database' is false, and DBDs are required by DL/I, not unusable.

Multiple choice technology databases
  1. network

  2. relational

  3. hierarchical

  4. object-oriented

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

IMS (Information Management System) DB uses a hierarchical database management model, organizing data in a tree-like structure with parent-child relationships. This is different from network (many-to-many), relational (table-based), or object-oriented databases. The hierarchical model is fundamental to IMS architecture.

Multiple choice technology databases
  1. multiple DBD s for each database

  2. none of these

  3. cannot be used by DL/I

  4. created by a process called DBDGEN

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

A Database Description (DBD) defines the physical structure of an IMS database and is compiled into a control block using the DBDGEN utility. Only one DBD exists per physical database definition, and it is actively used by DL/I to manage database access.

Multiple choice technology databases
  1. To provide the database name

  2. To name the fields in the DBD

  3. To tell the program the data field segment sense sizes during any process stage

  4. To identify the segments in the database to which the application program is sensitive

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

The SENSEG (Sensitive Segment) statement in a PSB identifies which database segments the application program is sensitive to and can access. It specifies the segment name (NAME), its parent in the hierarchy (PARENT), and the processing options (PROCOPT) permitted on that segment. It does not provide database names, field names within DBD, or segment sense sizes.