WGU D370 TEST QUESTIONS WITH CORRECT
ANSWERS
database administrator - ANSWER Protects the database system from
unauthorized users. implements user access and database system availability
database designer - ANSWER Specifies the form of each data element and the
overall structure of the database
database programmer - ANSWER Creates computer programs that use a
database
trasnaction - ANSWER Collection of queries that must be either executed or
abandoned as a unit
architecture of database system - ANSWER internal components and the
relationships between components
query processor - ANSWER interprets queries, creates a plan to modify the
database system or retrieve data, returns results to the application
store manager - ANSWER translates the query processor instructions into low
level file-system commands that modify or retrieve data
Indexes used in order to locate the required data as quickly as possible
transaction manager - ANSWER ensures transaction are correctly executed
ensures no conflict between concurrently executed transactions
brings the database back to a consistent state when a transaction fails or the
system crashes
, log - ANSWER file that records all inserts updates and deletes being processed
by a database
catalog or data dictionary - ANSWER directory of table, columns indexes and
other data base objects
relational database - ANSWER -most common
Stores data in tables, columns, rows like a spreadsheet
all data in a column has same format
All data in row represents a single object
SQL - ANSWER Structured Query Language
NoSQL - ANSWER nonrelational databases
Optimized for big data
database design - ANSWER specification o f database objects like tables,
columns, data types and indexes
ER diagrams - ANSWER rectangles represent entities
-lines represent relationships
-text under entity names represent attributes
logical design phase - ANSWER implements the requirements of the database
in some specific database system
ANSWERS
database administrator - ANSWER Protects the database system from
unauthorized users. implements user access and database system availability
database designer - ANSWER Specifies the form of each data element and the
overall structure of the database
database programmer - ANSWER Creates computer programs that use a
database
trasnaction - ANSWER Collection of queries that must be either executed or
abandoned as a unit
architecture of database system - ANSWER internal components and the
relationships between components
query processor - ANSWER interprets queries, creates a plan to modify the
database system or retrieve data, returns results to the application
store manager - ANSWER translates the query processor instructions into low
level file-system commands that modify or retrieve data
Indexes used in order to locate the required data as quickly as possible
transaction manager - ANSWER ensures transaction are correctly executed
ensures no conflict between concurrently executed transactions
brings the database back to a consistent state when a transaction fails or the
system crashes
, log - ANSWER file that records all inserts updates and deletes being processed
by a database
catalog or data dictionary - ANSWER directory of table, columns indexes and
other data base objects
relational database - ANSWER -most common
Stores data in tables, columns, rows like a spreadsheet
all data in a column has same format
All data in row represents a single object
SQL - ANSWER Structured Query Language
NoSQL - ANSWER nonrelational databases
Optimized for big data
database design - ANSWER specification o f database objects like tables,
columns, data types and indexes
ER diagrams - ANSWER rectangles represent entities
-lines represent relationships
-text under entity names represent attributes
logical design phase - ANSWER implements the requirements of the database
in some specific database system
