CS6400 - Exam Study Guide Questions Solved 100%
Correct | Verified Answers
interactive query - ✔✔Used by casual users and persons with occasional need
for information from the database
query optimizer - ✔✔A DBMS process that analyzes SQL queries and finds the most
efficient way to access the data. The query optimizer generates the access or execution plan
for the query.
precompiler - ✔✔extracts DML commands from an application program written in a
host programming language
Runtime Database Processor - ✔✔executes (1) the privileged commands, (2) the
executable query plans, and (3) the canned transactions with runtime parameters
Stored Data Manager - ✔✔uses basic operating system services for carrying out low-
level input/output (read/write) operations between the disk and main memory
Database System Utilities - ✔✔-Loading
-Backup
-Database storage reorganization
-Performance monitoring
data dictionary - ✔✔compiles all of the metadata about the data elements in the data model
,Information Repository - ✔✔A component that stores metadata that describe an
organization's data and data processing resources, manages the total information processing
environment, and combines information about an organization's business information and
its application portfolio.
communications software - ✔✔allows users at locations remote from the database system
site to access the database through computer terminals, workstations, or personal computers
Centralized DBMS - ✔✔- Combines everything into single system including DBMS software,
hardware, application programs, and user interface processing software.
- User can still connect through a remote terminal - however, all processing is done
at centralized site.
Distributed DBMS - ✔✔distributed over many sites connected by a computer network
System Metadata - ✔✔Data such as file names, size, and location. critical in a DBMS
Business Metadata - ✔✔critical in a data warehouse
Object Data Model - ✔✔defines a database in terms of objects, their properties, and
their operations
key-value data model - ✔✔associates a unique key with each value
Document Data Model - ✔✔is based on JSON and stores the data as documents,
which somewhat resemble complex objects.
, Graph data model - ✔✔stores objects as graph nodes and relationships among objects
as directed graph edges
Column-based Data Model - ✔✔stores the columns of rows clustered on disk pages for
fast access and allow multiple versions of the data
entity-relationship (ER) model - ✔✔high-level conceptual data model
ER diagrams - ✔✔Diagrammatic notation associated with the ER model
requirements collection and analysis - ✔✔data requirements
functional requirements
Composite attributes - ✔✔can be divided into smaller subparts, which represent more
basic attributes with independent meanings.
single-valued attribute - ✔✔An attribute that can have only one value.
multivalued attribute - ✔✔An attribute that can have many values for a single entity
occurrence. For example, an EMP_DEGREE attribute might store the string "BBA, MBA, PHD"
to indicate three different degrees held.
derived attribute - ✔✔An attribute whose values can be calculated from related
attribute values.
stored attribute - ✔✔The attribute that is used to derive the attribute
NULL Values - ✔✔a particular entity may not have an applicable value for an attribute
Correct | Verified Answers
interactive query - ✔✔Used by casual users and persons with occasional need
for information from the database
query optimizer - ✔✔A DBMS process that analyzes SQL queries and finds the most
efficient way to access the data. The query optimizer generates the access or execution plan
for the query.
precompiler - ✔✔extracts DML commands from an application program written in a
host programming language
Runtime Database Processor - ✔✔executes (1) the privileged commands, (2) the
executable query plans, and (3) the canned transactions with runtime parameters
Stored Data Manager - ✔✔uses basic operating system services for carrying out low-
level input/output (read/write) operations between the disk and main memory
Database System Utilities - ✔✔-Loading
-Backup
-Database storage reorganization
-Performance monitoring
data dictionary - ✔✔compiles all of the metadata about the data elements in the data model
,Information Repository - ✔✔A component that stores metadata that describe an
organization's data and data processing resources, manages the total information processing
environment, and combines information about an organization's business information and
its application portfolio.
communications software - ✔✔allows users at locations remote from the database system
site to access the database through computer terminals, workstations, or personal computers
Centralized DBMS - ✔✔- Combines everything into single system including DBMS software,
hardware, application programs, and user interface processing software.
- User can still connect through a remote terminal - however, all processing is done
at centralized site.
Distributed DBMS - ✔✔distributed over many sites connected by a computer network
System Metadata - ✔✔Data such as file names, size, and location. critical in a DBMS
Business Metadata - ✔✔critical in a data warehouse
Object Data Model - ✔✔defines a database in terms of objects, their properties, and
their operations
key-value data model - ✔✔associates a unique key with each value
Document Data Model - ✔✔is based on JSON and stores the data as documents,
which somewhat resemble complex objects.
, Graph data model - ✔✔stores objects as graph nodes and relationships among objects
as directed graph edges
Column-based Data Model - ✔✔stores the columns of rows clustered on disk pages for
fast access and allow multiple versions of the data
entity-relationship (ER) model - ✔✔high-level conceptual data model
ER diagrams - ✔✔Diagrammatic notation associated with the ER model
requirements collection and analysis - ✔✔data requirements
functional requirements
Composite attributes - ✔✔can be divided into smaller subparts, which represent more
basic attributes with independent meanings.
single-valued attribute - ✔✔An attribute that can have only one value.
multivalued attribute - ✔✔An attribute that can have many values for a single entity
occurrence. For example, an EMP_DEGREE attribute might store the string "BBA, MBA, PHD"
to indicate three different degrees held.
derived attribute - ✔✔An attribute whose values can be calculated from related
attribute values.
stored attribute - ✔✔The attribute that is used to derive the attribute
NULL Values - ✔✔a particular entity may not have an applicable value for an attribute
