WGU D426 exam questions with answers

WGU D426 exam questions with answers |\ |\ |\ |\ |\




What Is a software that reads and writes data in a database?
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\




Database management system or DBMS |\ |\ |\ |\




What is a computer programming language for writing database queries?
|\ |\ |\ |\ |\ |\ |\ |\ |\




Query language |\




What is a command for a database that typically inserts new data, retrieves
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\



data, updates data, or deletes data from a database
|\ |\ |\ |\ |\ |\ |\ |\




Query

What is a group of queries that must be either completed or rejected as a
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\



whole?

A transaction
|\




What Interprets queries, creates a plan to modify the database or retrieve
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\



data, and returns query results to the application?
|\ |\ |\ |\ |\ |\ |\




A query processor
|\ |\




What translates the query processor instructions into low-level file-system
|\ |\ |\ |\ |\ |\ |\ |\ |\



commands that modify or retrieve data? |\ |\ |\ |\ |\




Store Manager
|\




What ensures transactions are properly executed?
|\ |\ |\ |\ |\




Transaction Manager |\




What is a file containing a complete record of all inserts, updates, and
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\



deletes processed by the database?
|\ |\ |\ |\




The log
|\




What is a directory of tables, columns, indexes, and other database objects?
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\

, Catalog

What is a column, used to identify individual rows of a table?
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\




A key
|\




Which phase implements database requirements in a specific database
|\ |\ |\ |\ |\ |\ |\ |\ |\



system?

Database Logical design phase |\ |\ |\




Which phase specifies database objects such as tables, columns, data types,
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\



and indexes?
|\




Database design phase |\ |\




Which phase specifies database requirements without regard to a specific
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\



database system? |\




Database analysis phase |\ |\




Which phase adds indexes and specifies how tables are organized on storage
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\



media?

Database physical design phase |\ |\ |\




What is the name of a leading relational database system that sponsored by
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\



Oracle?

MySQL

What is a conceptual framework for database systems, with three parts?
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\




Database model |\




In a database model, what prescribes how data is organized?
|\ |\ |\ |\ |\ |\ |\ |\ |\




Data structures
|\




In a database mode, what manipulates data structures?
|\ |\ |\ |\ |\ |\ |\




Operations