CS6400 Exam Prep Questions and Answers
Verified 100% Correct
Mappings - ✔✔process of transforming requests and results between levels
data independence - ✔✔capacity to change the schema at one level of a database
system without having to change the schema at the next higher level
Logical Data Independence - ✔✔The capacity to change the conceptual schema
without having to change the external schemas and their associated application programs.
Physical Data Independence - ✔✔The capacity to change the internal schema without
having to change the conceptual schema.
DDL (Data Definition Language) - ✔✔is used by the DBA and by database designers to
define both schemas
Storage Definition Language (SDL) - ✔✔Used to specify the internal schema
View Definition Language (VDL) - ✔✔Specifies user views/mappings to conceptual schema
Data Manipulation Language (DML) - ✔✔DBMS language that changes database
content, including data element creations, updates, insertions, and deletions
,Buffer Management Module - ✔✔schedule disk read/write, because management of
buffer storage has a considerable effect on performance. Reducing disk read/write improves
performance considerably.
Stored Data Manager Module - ✔✔controls access to DBMS information that is stored
on disk, whether it is part of the database or the catalog.
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
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
Verified 100% Correct
Mappings - ✔✔process of transforming requests and results between levels
data independence - ✔✔capacity to change the schema at one level of a database
system without having to change the schema at the next higher level
Logical Data Independence - ✔✔The capacity to change the conceptual schema
without having to change the external schemas and their associated application programs.
Physical Data Independence - ✔✔The capacity to change the internal schema without
having to change the conceptual schema.
DDL (Data Definition Language) - ✔✔is used by the DBA and by database designers to
define both schemas
Storage Definition Language (SDL) - ✔✔Used to specify the internal schema
View Definition Language (VDL) - ✔✔Specifies user views/mappings to conceptual schema
Data Manipulation Language (DML) - ✔✔DBMS language that changes database
content, including data element creations, updates, insertions, and deletions
,Buffer Management Module - ✔✔schedule disk read/write, because management of
buffer storage has a considerable effect on performance. Reducing disk read/write improves
performance considerably.
Stored Data Manager Module - ✔✔controls access to DBMS information that is stored
on disk, whether it is part of the database or the catalog.
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
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
