WGU D426 questions with verified answers
What Is a software that reads and writes data in a database? Ans ✔✔-
Database management system or DBMS
What is a computer programming language for writing database queries?
Ans ✔✔-Query language
What is a command for a database that typically inserts new data,
retrieves data, updates data, or deletes data from a database Ans ✔✔-
Query
What is a group of queries that must be either completed or rejected as a
whole? Ans ✔✔-A transaction
What Interprets queries, creates a plan to modify the database or retrieve
data, and returns query results to the application? Ans ✔✔-A query
processor
What translates the query processor instructions into low-level file-
system commands that modify or retrieve data? Ans ✔✔-Store Manager
What ensures transactions are properly executed? Ans ✔✔-Transaction
Manager
What is a file containing a complete record of all inserts, updates, and
deletes processed by the database? Ans ✔✔-The log
, What is a directory of tables, columns, indexes, and other database
objects? Ans ✔✔-Catalog
What is a column, used to identify individual rows of a table? Ans ✔✔-A
key
Which phase implements database requirements in a specific database
system? Ans ✔✔-Database Logical design phase
Which phase specifies database objects such as tables, columns, data
types, and indexes? Ans ✔✔-Database design phase
Which phase specifies database requirements without regard to a
specific database system? Ans ✔✔-Database analysis phase
Which phase adds indexes and specifies how tables are organized on
storage media? Ans ✔✔-Database physical design phase
What is the name of a leading relational database system that sponsored
by Oracle? Ans ✔✔-MySQL
What is a conceptual framework for database systems, with three parts?
Ans ✔✔-Database model
What Is a software that reads and writes data in a database? Ans ✔✔-
Database management system or DBMS
What is a computer programming language for writing database queries?
Ans ✔✔-Query language
What is a command for a database that typically inserts new data,
retrieves data, updates data, or deletes data from a database Ans ✔✔-
Query
What is a group of queries that must be either completed or rejected as a
whole? Ans ✔✔-A transaction
What Interprets queries, creates a plan to modify the database or retrieve
data, and returns query results to the application? Ans ✔✔-A query
processor
What translates the query processor instructions into low-level file-
system commands that modify or retrieve data? Ans ✔✔-Store Manager
What ensures transactions are properly executed? Ans ✔✔-Transaction
Manager
What is a file containing a complete record of all inserts, updates, and
deletes processed by the database? Ans ✔✔-The log
, What is a directory of tables, columns, indexes, and other database
objects? Ans ✔✔-Catalog
What is a column, used to identify individual rows of a table? Ans ✔✔-A
key
Which phase implements database requirements in a specific database
system? Ans ✔✔-Database Logical design phase
Which phase specifies database objects such as tables, columns, data
types, and indexes? Ans ✔✔-Database design phase
Which phase specifies database requirements without regard to a
specific database system? Ans ✔✔-Database analysis phase
Which phase adds indexes and specifies how tables are organized on
storage media? Ans ✔✔-Database physical design phase
What is the name of a leading relational database system that sponsored
by Oracle? Ans ✔✔-MySQL
What is a conceptual framework for database systems, with three parts?
Ans ✔✔-Database model
