• Wrong document? Swap it for free
  • Written by students who passed
  • Immediately available after payment
  • Read online or as PDF
Sell
Where do you study
Your language
Document preview thumbnail
Preview 3 out of 17 pages
Exam (elaborations)

D426 WGU Guide – Complete Study Set

Document preview thumbnail
Preview 3 out of 17 pages

D426 WGU Guide – Complete Study Set

Content preview

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

Document information

Uploaded on
January 8, 2025
Number of pages
17
Written in
2024/2025
Type
Exam (elaborations)
Contains
Questions & answers
$16.49

Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF

Seller avatar
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
NorthWest
4.1
(175)
Sold
849
Followers
673
Items
6785
Last sold
2 days ago




Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Working on your references?

Create accurate citations in APA, MLA and Harvard with our free citation generator.

Working on your references?

Frequently asked questions