WGU D426 OA EXAM WITH COMPLETE SOLUTIONS NEW!!
What is 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 either be completed or rejected as a whole?
A transaction
What interprets queries, devises 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 actually do the modification or retrieval of data?
Store Manager
What ensures proper execution of transaction?
Transaction Manager
,What is a file containing a complete record of all inserts, updates and deletes processed
by the database?
The log
A directory of tables, columns, indexes, and other database objects?
Catalog
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 a name of one of the leading relational database systems sponsored by Oracle?
MySQL
,What is a conceptual framework for database systems, with three parts?
Database model
In a database model, what prescribes the way data are organized?
Data structures
In a database mode, what are Data structures manipulated by?
Operations
In a database mode, what are valid data governed by?
Rules
What SQL command selects a subset of rows of a table?
Select
What SQL command eliminates one or more columns of a table?
Project
What SQL command lists all combination of rows of two tables?
Product
What SQL command combines two tables by comparing related columns?
Join
What SQL command selects all rows of two tables?
, Union
What SQL command selects rows common to two tables?
Intersect
What SQL command selects rows that appear in one table but not another?
Difference
What SQL command changes a table name?
Rename
What SQL command summarizes the result based upon multi table rows, sum count?
Aggregate
Name two types of rules?
Relational rules and Business rules
Name 3 Relational rules
Unique primary key, Unique columns names, No duplicate rows.
Which rules based on business policy and is specific to some particular database?
Business rules
Which rules are part of relational model and are used to govern data in every relational
database?
Relational rules
What is 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 either be completed or rejected as a whole?
A transaction
What interprets queries, devises 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 actually do the modification or retrieval of data?
Store Manager
What ensures proper execution of transaction?
Transaction Manager
,What is a file containing a complete record of all inserts, updates and deletes processed
by the database?
The log
A directory of tables, columns, indexes, and other database objects?
Catalog
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 a name of one of the leading relational database systems sponsored by Oracle?
MySQL
,What is a conceptual framework for database systems, with three parts?
Database model
In a database model, what prescribes the way data are organized?
Data structures
In a database mode, what are Data structures manipulated by?
Operations
In a database mode, what are valid data governed by?
Rules
What SQL command selects a subset of rows of a table?
Select
What SQL command eliminates one or more columns of a table?
Project
What SQL command lists all combination of rows of two tables?
Product
What SQL command combines two tables by comparing related columns?
Join
What SQL command selects all rows of two tables?
, Union
What SQL command selects rows common to two tables?
Intersect
What SQL command selects rows that appear in one table but not another?
Difference
What SQL command changes a table name?
Rename
What SQL command summarizes the result based upon multi table rows, sum count?
Aggregate
Name two types of rules?
Relational rules and Business rules
Name 3 Relational rules
Unique primary key, Unique columns names, No duplicate rows.
Which rules based on business policy and is specific to some particular database?
Business rules
Which rules are part of relational model and are used to govern data in every relational
database?
Relational rules
