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
-
Docbroker
-
Docbase
-
Database configuration file
-
None of the above
A
Correct answer
Explanation
The Docbroker acts as a directory service that routes client connections to the appropriate Content Server. It maintains registry information about available servers and their locations.
-
Docbroker
-
Docbase
-
Database configuration file
-
None of the above
A
Correct answer
Explanation
A Docbroker maintains connection information for multiple Docbases, acting as a central registry. This allows clients to connect to different repositories through a single Docbroker endpoint.
-
Persistent
-
Non Persistent
-
cant say
-
dont know
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.
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.
-
network
-
relational
-
hierarchical
-
object-oriented
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 DBD s for each database
-
none of these
-
cannot be used by DL/I
-
created by a process called DBDGEN
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.
-
network
-
relational
-
hierarchical
-
object-oriented
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 DBD s for each database
-
none of these
-
cannot be used by DL/I
-
created by a process called DBDGEN
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.
-
network
-
relational
-
hierarchical
-
object-oriented
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 DBD s for each database
-
none of these
-
cannot be used by DL/I
-
created by a process called DBDGEN
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.
-
network
-
relational
-
hierarchical
-
object-oriented
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 DBD s for each database
-
cannot be used by DL/I
-
created by a process called DBDGEN
-
none of these
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.
-
network
-
relational
-
hierarchical
-
object-oriented
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 DBD s for each database
-
none of these
-
cannot be used by DL/I
-
created by a process called DBDGEN
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.
-
To provide the database name
-
To name the fields in the DBD
-
To tell the program the data field segment sense sizes during any process stage
-
To identify the segments in the database to which the application program is sensitive
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.