D426 WGU Guide – Complete Study Set
Connection between data Right Ans - Relation
Anything you store data about Right Ans - Entity
Examples of Entities Right Ans - - Employee
- Customer
- Product
Things you store Right Ans - Attribute
Examples of Attributes Right Ans - - Customer ID
- Total amount
- Quantity
Database Management System Right Ans - Software that provides a
systematic way to create, retrieve, update, and manage data in databases
View Mechanism Right Ans - A way of presenting customized data to users
without directly exposing the underlying tables
Examples of RDMS Right Ans - - MySQL
- Microsoft SQL Server
- Oracle Database
What does SQL do? Right Ans - It defines and manipulates a database
Which subset of SQL is used to define and manage the structure of a database
Right Ans - DDL
Which subset of SQL is used to manipulate data stored in a database Right
Ans - DML
Common DDL commands Right Ans - - CREATE
- ALTER
- DROP
- TRUNCATE
- RENAME
,Common DML commands Right Ans - - UPDATE
- DELETE
- INSERT
- SELECT
Data Integrity Right Ans - The accuracy, consistency, and reliability of data
stored in a database
Conceptual schema Right Ans - Big-picture view of what the system will
contain, how it will be organized, and which business rules are involved
Logical schema Right Ans - Clearly define schema objects such as table and
field names, entity relationships, and integrity constraints
Physical schema Right Ans - Provides technical and contextual information
Primary Key Right Ans - A unique identifier for each record in a database
table
Foreign Key Right Ans - An attribute in a table that refers to the primary
key in another table
Entity Integrity Right Ans - Condition in which each row in the table has its
own unique, non-null identity
This principle is primarily enforced through the use of primary keys, which
are special attributes assigned to each record in a table Right Ans - Entity
Integrity
Referential Integrity Right Ans - Ensures the accuracy and consistency of
relationships between tables
A property that guarantees that foreign keys in one table correctly reference
primary keys in another table, thus maintaining valid links between related
data. Right Ans - Referential Integrity
Domain Right Ans - Defines constraints on data type, format, and range of
values
, Domain Integrity Right Ans - Ensures the validity and correctness of the
data within a specific domain or field in a database
Anamoly Right Ans - A situation that can lead to unexpected results in data
Frontend Right Ans - What a user sees
Backend Right Ans - What goes on behind the scenes
Which sublanguage in SQL is used to manage database access? Right Ans -
Data Control Language
Which sublanguage in SQL is used to roll back database changes? Right Ans
- Data Transaction Language
Which MySQL operator is the last in the order of operator precedence?
Right Ans - OR
Which clause or function is used with aggregate functions to produce
summary rows? Right Ans - GROUP BY
Where data is structured in a way that reduces the complexity of data
retrieval by merging tables Right Ans - Denormalized View
Which process eliminates redundancy by decomposing a table into two or
more tables in a higher normal form Right Ans - Normalization
Where data is organized into multiple related tables to minimize redundancy
and ensure data integrity Right Ans - Normalized View
View in which data is persisted and is automatically changed as the
underlying data is changed Right Ans - Materialized View
Removes data from temporary tables Right Ans - TRUNCATE
Which property specifies an expression on one or more columns of a table
Right Ans - CHECK
Connection between data Right Ans - Relation
Anything you store data about Right Ans - Entity
Examples of Entities Right Ans - - Employee
- Customer
- Product
Things you store Right Ans - Attribute
Examples of Attributes Right Ans - - Customer ID
- Total amount
- Quantity
Database Management System Right Ans - Software that provides a
systematic way to create, retrieve, update, and manage data in databases
View Mechanism Right Ans - A way of presenting customized data to users
without directly exposing the underlying tables
Examples of RDMS Right Ans - - MySQL
- Microsoft SQL Server
- Oracle Database
What does SQL do? Right Ans - It defines and manipulates a database
Which subset of SQL is used to define and manage the structure of a database
Right Ans - DDL
Which subset of SQL is used to manipulate data stored in a database Right
Ans - DML
Common DDL commands Right Ans - - CREATE
- ALTER
- DROP
- TRUNCATE
- RENAME
,Common DML commands Right Ans - - UPDATE
- DELETE
- INSERT
- SELECT
Data Integrity Right Ans - The accuracy, consistency, and reliability of data
stored in a database
Conceptual schema Right Ans - Big-picture view of what the system will
contain, how it will be organized, and which business rules are involved
Logical schema Right Ans - Clearly define schema objects such as table and
field names, entity relationships, and integrity constraints
Physical schema Right Ans - Provides technical and contextual information
Primary Key Right Ans - A unique identifier for each record in a database
table
Foreign Key Right Ans - An attribute in a table that refers to the primary
key in another table
Entity Integrity Right Ans - Condition in which each row in the table has its
own unique, non-null identity
This principle is primarily enforced through the use of primary keys, which
are special attributes assigned to each record in a table Right Ans - Entity
Integrity
Referential Integrity Right Ans - Ensures the accuracy and consistency of
relationships between tables
A property that guarantees that foreign keys in one table correctly reference
primary keys in another table, thus maintaining valid links between related
data. Right Ans - Referential Integrity
Domain Right Ans - Defines constraints on data type, format, and range of
values
, Domain Integrity Right Ans - Ensures the validity and correctness of the
data within a specific domain or field in a database
Anamoly Right Ans - A situation that can lead to unexpected results in data
Frontend Right Ans - What a user sees
Backend Right Ans - What goes on behind the scenes
Which sublanguage in SQL is used to manage database access? Right Ans -
Data Control Language
Which sublanguage in SQL is used to roll back database changes? Right Ans
- Data Transaction Language
Which MySQL operator is the last in the order of operator precedence?
Right Ans - OR
Which clause or function is used with aggregate functions to produce
summary rows? Right Ans - GROUP BY
Where data is structured in a way that reduces the complexity of data
retrieval by merging tables Right Ans - Denormalized View
Which process eliminates redundancy by decomposing a table into two or
more tables in a higher normal form Right Ans - Normalization
Where data is organized into multiple related tables to minimize redundancy
and ensure data integrity Right Ans - Normalized View
View in which data is persisted and is automatically changed as the
underlying data is changed Right Ans - Materialized View
Removes data from temporary tables Right Ans - TRUNCATE
Which property specifies an expression on one or more columns of a table
Right Ans - CHECK