WGU D426 Exam with accurate detailed ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
solutions
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
In a database mode, what governs valid data?
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Rules
What command selects a subset of rows of a table?
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Select
What command eliminates one or more columns of a table?
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Project
What command lists all combination of rows of two tables?
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Product
What command combines two tables by comparing related columns?
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
solutions
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
In a database mode, what governs valid data?
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Rules
What command selects a subset of rows of a table?
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Select
What command eliminates one or more columns of a table?
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Project
What command lists all combination of rows of two tables?
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Product
What command combines two tables by comparing related columns?
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
