WGU D426 C175 Database Management
Foundations UPDATED Actual Exam
Questions and CORRECT Answers
ER Diagram - CORRECT ANSWER✔✔- A type of flowchart that illustrates how "entities"
such as people, objects or concepts relate to each other within a system.
Database Administrator (DBA) - CORRECT ANSWER✔✔- Responsible for securing the
database system against unauthorized users. Enforces procedures for user access and database
system availability.
Database Designers - CORRECT ANSWER✔✔- Determines the format of each data element
and the overall database structure. Must balance several priorities, including storage, response
time, and support for rules that govern the data. Since these priorities often conflict, this job
is technically challenging.
Database Programmer - CORRECT ANSWER✔✔- Develops computer programs that utilize
a database. Write applications that combine database query languages and general-purpose
programming languages. Query languages and general-purpose languages have significant
differences, so this job is a specialized challenge.
Database User - CORRECT ANSWER✔✔- A consumer of data in a database. They request,
update, or use stored data to generate reports or information. They usually access the database
via applications but can also submit queries directly to the database system.
When processing transactions, database systems must: - CORRECT ANSWER✔✔- -Ensure
transactions are processed completely or not at all
-Prevent conflicts between concurrent transactions.
-Ensure transaction results are never lost.
Architecture of a database system - CORRECT ANSWER✔✔- -query processor
-storage manager
-transaction manager
-log
, -catalog or data disctionary
query processor - CORRECT ANSWER✔✔- Interprets queries, creates a plan to modify the
database or retrieve data, and returns query results to the application. It performs query
optimization to ensure the most efficient instructions are executed on the data.
storage manager - CORRECT ANSWER✔✔- Translates the query processor instructions into
low-level file-system commands that modify or retrieve data. Database sizes range from
megabytes to many terabytes, so the it uses indexes to quickly locate data.
transaction manager - CORRECT ANSWER✔✔- Ensures transactions are properly executed.
It prevents conflicts between concurrent transactions. It also restores the database to a
consistent state in the event of a transaction or system failure.
log (database) - CORRECT ANSWER✔✔- a file containing a complete record of all inserts,
updates, and deletes processed by the database. The transaction manager writes log records
before applying changes to the database. In the event of a failure, the transaction manager
uses these to restore the database.
catalog/data dictionary - CORRECT ANSWER✔✔- A directory of tables, columns, indexes,
and other database objects. Other components use catalog information to process and execute
queries.
Oracle Database - CORRECT ANSWER✔✔- Oracle, Relational, Commercial
MySQL - CORRECT ANSWER✔✔- Oracle, Relational, Open Source
SQL Server - CORRECT ANSWER✔✔- Microsoft, Relational, Commercial
PostgreSQL - CORRECT ANSWER✔✔- PostgreSQL Global Development Group,
Relational, Open Source
MongoDB - CORRECT ANSWER✔✔- NoSQL, Open Source, Optimized for big data
generated on the internet
Foundations UPDATED Actual Exam
Questions and CORRECT Answers
ER Diagram - CORRECT ANSWER✔✔- A type of flowchart that illustrates how "entities"
such as people, objects or concepts relate to each other within a system.
Database Administrator (DBA) - CORRECT ANSWER✔✔- Responsible for securing the
database system against unauthorized users. Enforces procedures for user access and database
system availability.
Database Designers - CORRECT ANSWER✔✔- Determines the format of each data element
and the overall database structure. Must balance several priorities, including storage, response
time, and support for rules that govern the data. Since these priorities often conflict, this job
is technically challenging.
Database Programmer - CORRECT ANSWER✔✔- Develops computer programs that utilize
a database. Write applications that combine database query languages and general-purpose
programming languages. Query languages and general-purpose languages have significant
differences, so this job is a specialized challenge.
Database User - CORRECT ANSWER✔✔- A consumer of data in a database. They request,
update, or use stored data to generate reports or information. They usually access the database
via applications but can also submit queries directly to the database system.
When processing transactions, database systems must: - CORRECT ANSWER✔✔- -Ensure
transactions are processed completely or not at all
-Prevent conflicts between concurrent transactions.
-Ensure transaction results are never lost.
Architecture of a database system - CORRECT ANSWER✔✔- -query processor
-storage manager
-transaction manager
-log
, -catalog or data disctionary
query processor - CORRECT ANSWER✔✔- Interprets queries, creates a plan to modify the
database or retrieve data, and returns query results to the application. It performs query
optimization to ensure the most efficient instructions are executed on the data.
storage manager - CORRECT ANSWER✔✔- Translates the query processor instructions into
low-level file-system commands that modify or retrieve data. Database sizes range from
megabytes to many terabytes, so the it uses indexes to quickly locate data.
transaction manager - CORRECT ANSWER✔✔- Ensures transactions are properly executed.
It prevents conflicts between concurrent transactions. It also restores the database to a
consistent state in the event of a transaction or system failure.
log (database) - CORRECT ANSWER✔✔- a file containing a complete record of all inserts,
updates, and deletes processed by the database. The transaction manager writes log records
before applying changes to the database. In the event of a failure, the transaction manager
uses these to restore the database.
catalog/data dictionary - CORRECT ANSWER✔✔- A directory of tables, columns, indexes,
and other database objects. Other components use catalog information to process and execute
queries.
Oracle Database - CORRECT ANSWER✔✔- Oracle, Relational, Commercial
MySQL - CORRECT ANSWER✔✔- Oracle, Relational, Open Source
SQL Server - CORRECT ANSWER✔✔- Microsoft, Relational, Commercial
PostgreSQL - CORRECT ANSWER✔✔- PostgreSQL Global Development Group,
Relational, Open Source
MongoDB - CORRECT ANSWER✔✔- NoSQL, Open Source, Optimized for big data
generated on the internet
