DATABASE MANAGEMENT EXAM
UPDATED QUESTIONS AND CORRECT
ANSWERS.
Business Rules - ANS Brief, precise, and unambigiuous description of a policy, procedure, or
principle
Hierarchical Models - ANS Developed to manage large amounts of data for complex
manufacturing projects. Represented by an Upside-down tree which contains a set of one-to-
many(1:M) relationships
Network Models - ANS Created to represent complex data relationships effectively. Depicts
both (1:M) and (M:N) relationships
Schema - ANS Conceptual organization of the entire database as viewed by the database
administrator
Subschema - ANS Portion of the database seen by the application programs that produce the
desired information from the data within the database.
DML (Data manipulation language) - ANS Environment in which data can be managed and is
used to work with the data in the database
1 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED
, Schema DDL (Data defintion language) - ANS Enables the database admin to define the
schema components
Relation/Table - ANS Matrix composed of intersecting tuple and attribute
Tuple - ANS Another name for rows
Attributes - ANS Another name for columns
Relational Model - ANS Describes a precise set of data manipulation constructs, based on a
relation.
RDBMS (Relational Database Management System) - ANS Performs basic functions provided
by the hierarchical and network DBMS systems.
ERD (Entity Relationship Diagram) - ANS Uses graphic representations to model database
components.
Instance - ANS Name for rows in the relation table
Connectivity - ANS Term used to label the relationship types
Object - ANS Contains the data and their relationships with operations that are performed
on it.
Class - ANS Collection of similar objects with shared structure and behavior organized in a
class hierarchy
Inheritance - ANS Object inherits methods and attributes of a parent class
2 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED
UPDATED QUESTIONS AND CORRECT
ANSWERS.
Business Rules - ANS Brief, precise, and unambigiuous description of a policy, procedure, or
principle
Hierarchical Models - ANS Developed to manage large amounts of data for complex
manufacturing projects. Represented by an Upside-down tree which contains a set of one-to-
many(1:M) relationships
Network Models - ANS Created to represent complex data relationships effectively. Depicts
both (1:M) and (M:N) relationships
Schema - ANS Conceptual organization of the entire database as viewed by the database
administrator
Subschema - ANS Portion of the database seen by the application programs that produce the
desired information from the data within the database.
DML (Data manipulation language) - ANS Environment in which data can be managed and is
used to work with the data in the database
1 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED
, Schema DDL (Data defintion language) - ANS Enables the database admin to define the
schema components
Relation/Table - ANS Matrix composed of intersecting tuple and attribute
Tuple - ANS Another name for rows
Attributes - ANS Another name for columns
Relational Model - ANS Describes a precise set of data manipulation constructs, based on a
relation.
RDBMS (Relational Database Management System) - ANS Performs basic functions provided
by the hierarchical and network DBMS systems.
ERD (Entity Relationship Diagram) - ANS Uses graphic representations to model database
components.
Instance - ANS Name for rows in the relation table
Connectivity - ANS Term used to label the relationship types
Object - ANS Contains the data and their relationships with operations that are performed
on it.
Class - ANS Collection of similar objects with shared structure and behavior organized in a
class hierarchy
Inheritance - ANS Object inherits methods and attributes of a parent class
2 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED
