Computer Knowledge

Database Management Systems

5,344 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 databases

Which of the following is true about DBD ?

  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

IMS Db uses what kind of database management

  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

Which of the following is true about DBD ?

  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

IMS Db uses what kind of database management

  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

Which of the following is true about DBD ?

  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

IMS Db uses what kind of database management

  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

Which of the following is true about DBD ?

  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

What must be completed before a GNP is issued with the database?

  1. All data must be sorted.

  2. All children must be grouped.

  3. The parent must be established

  4. All parents must be grouped.

  5. Finite control must be released.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

GNP (Get Next Parent) requires that the parent segment be established in the PCB before the call can be issued. Without a parent position established, DL/I cannot determine which parent's children to retrieve next. Option C correctly identifies this prerequisite.

Multiple choice technology databases

IMS uses what kind of database management

  1. Heirarchical

  2. Network

  3. Relational

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

IMS (Information Management System) uses a hierarchical database model where data is organized in a tree structure with parent-child relationships. This is distinct from network (many-to-many), relational (tables), or object-oriented models.

Multiple choice technology enterprise content management

In a version tree, root version is current. If root version is deleted, which property is used to look for new current verion?

  1. r_creation_date

  2. r_modify_date

  3. r_access_date

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

When the current version of a document in a version tree is deleted, the Documentum Content Server automatically promotes the version with the highest r_modify_date to be the new current version.

Multiple choice technology testing

Recovery scenario takes us thru the following wizard steps in the following sequence

  1. define a trigger, define the recovery operations, define the post recovery operations

  2. define the recovery operations, define a trigger, define the post recovery operations

  3. can be created in any order

  4. no such wizard is available in Quick Test
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The Recovery Scenario wizard in QuickTest Professional follows a specific sequence: first you define what triggers the recovery (trigger event), then define what recovery operations to perform (steps to recover), and finally define post-recovery operations (what to do after recovery completes). This logical flow ensures the test knows when to activate recovery, what actions to take, and how to resume.

Multiple choice technology

Data Warehouse consist of (choose three)

  1. Meta data

  2. Summary Data

  3. Raw data

  4. Secondary data

  5. Inconsistent data
Reveal answer Fill a bubble to check yourself
A,B,C Correct answer
Explanation

A data warehouse architecture consists of three core components: metadata (technical and business definitions about the data), summary data (aggregated facts and metrics pre-calculated for query performance), and raw data (detailed transaction records from source systems). Metadata includes schemas, transformation rules, and data lineage; summary data contains pre-aggregated metrics like monthly sales totals; raw data holds the granular source records that enable drill-down analysis.

Multiple choice technology

What are the two common schema types

  1. Star schema

  2. Ring schema

  3. Snow flake schema

  4. Circular schema
Reveal answer Fill a bubble to check yourself
A,C Correct answer
Explanation

The two primary schema types for data warehouse dimensional modeling are star schema and snowflake schema. Star schema has a central fact table connected directly to dimension tables (denormalized dimensions), while snowflake schema further normalizes dimension tables into sub-dimensions. Snowflake reduces redundancy but adds join complexity; star schema is simpler for queries but has some dimension data duplication.