WGU D426 C175 Database Management Foundations UPDATED Actual Exam Questions and CORRECT Answers
0 view 0 purchase
Course
WGU D426 C175 Database Management
Institution
WGU D426 C175 Database Management
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 A...
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.
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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller MGRADES. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $7.99. You're not tied to anything after your purchase.
