D426 - DATA MANAGEMENT.DOC RED
TEXT QUESTIONS WITH VERIFIED
ANSWERS,100%CORRECT
, Database Application - ANSWERsoftware that helps business users interact with
database systems
Database Administrator - ANSWERResponsible for securing the database system
against unauthorized users. Enforces procedures for user access and database system
availability.
Query Processor - ANSWERinterprets queries, creates a plan to modify the database or
retrieve data, and returns query results to the application. Performs query optimization
Query Optimization - ANSWERensures the most efficient instructions are executed on
the data
Storage Manager - ANSWERTranslates the query processor instructions into low-level
file system commands that modify or retrieve data. Uses indexes to quickly locate data.
Transaction Manager - ANSWEREnsures transactions are properly executed. Prevents
conflicts between concurrent transactions. Restores the database to a consistent state
in the event of a transaction or system failure.
Relational Database - ANSWERstores data in predefined tables that contain rows &
columns similar to spreadsheet
NoSQL - ANSWERNonrelational databases that arise from big data.
Open source
MongoDB
- ANSWER
Database Design Process - ANSWER1. Analysis
2. Logical Design
3. Physical Design
Analysis Phase - ANSWERspecifies database requirements without regard to a specific
database system
Logical Design Phase - ANSWERimplements database requirements in a specific
database system. Converts entities/relationships/attributes into tables/keys/columns
TEXT QUESTIONS WITH VERIFIED
ANSWERS,100%CORRECT
, Database Application - ANSWERsoftware that helps business users interact with
database systems
Database Administrator - ANSWERResponsible for securing the database system
against unauthorized users. Enforces procedures for user access and database system
availability.
Query Processor - ANSWERinterprets queries, creates a plan to modify the database or
retrieve data, and returns query results to the application. Performs query optimization
Query Optimization - ANSWERensures the most efficient instructions are executed on
the data
Storage Manager - ANSWERTranslates the query processor instructions into low-level
file system commands that modify or retrieve data. Uses indexes to quickly locate data.
Transaction Manager - ANSWEREnsures transactions are properly executed. Prevents
conflicts between concurrent transactions. Restores the database to a consistent state
in the event of a transaction or system failure.
Relational Database - ANSWERstores data in predefined tables that contain rows &
columns similar to spreadsheet
NoSQL - ANSWERNonrelational databases that arise from big data.
Open source
MongoDB
- ANSWER
Database Design Process - ANSWER1. Analysis
2. Logical Design
3. Physical Design
Analysis Phase - ANSWERspecifies database requirements without regard to a specific
database system
Logical Design Phase - ANSWERimplements database requirements in a specific
database system. Converts entities/relationships/attributes into tables/keys/columns
