100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
WGU D426 Test | Questions & Answers (100 %Score) Latest Updated 2024/2025 Comprehensive Questions A+ Graded Answers | With Expert Solutions $13.48   Add to cart

Exam (elaborations)

WGU D426 Test | Questions & Answers (100 %Score) Latest Updated 2024/2025 Comprehensive Questions A+ Graded Answers | With Expert Solutions

 4 views  0 purchase
  • Institution
  • WGU

WGU D426 Test | Questions & Answers (100 %Score) Latest Updated 2024/2025 Comprehensive Questions A+ Graded Answers | With Expert Solutions

Preview 2 out of 7  pages

  • August 7, 2024
  • 7
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers
All documents for this subject (6258)
avatar-seller
VasilyKichigin
WGU D426 Test | Questions & Answers (100 %Score) Latest Updated 2024/2025
Comprehensive Questions A+ Graded Answers | With Expert Solutions


A ____ is a column, or group of columns, used to identify a row. - Primary key

A ____ consists of a single column. - Simple primary key

A ____ key consists of multiple columns. - Composite primary

All primary keys columns are necessary for uniqueness. When any column is removed,
the resulting simple or composite column is no longer unique. - Minimal

The ____ constraint in the CREATE TABLE statement names the table's ____. The
____ constraint ensures that a column or group of columns is always unique and non-
null. - Primary key

An _____ is a numeric column that is assigned an automatically incrementing value
when a new row is inserted. - Auto-increment column

The ____ keyword defines an auto-increment column. It follows the column's data type
in a CREATE TABLE statement. - AUTO_INCREMENT

A ____ is a column, or group of columns, that refer to a primary key. - Foreign key

____ requires foreign key values must either be NULL or match some value of the
referenced primary key. - Referential integrity

A ____ constraint is added to a CREATE TABLE statement with the ____ and
REFERENCES keywords. - Foreign key; references

A ____ foreign key is a simple or composite foreign key in which all columns are NULL.
- Fully NULL

____ is a relational rule that requires foreign key values to either be fully NULL or match
some primary key value. - Referential integrity

____ rejects an insert, update, or delete that violates referential integrity. - RESTRICT

____ sets invalid foreign keys to NULL. - SET NULL

____ sets invalid foreign keys to the foreign key default value. - SET DEFAULT

____ propagates primary key changes to foreign keys. - CASCADE

, Actions are specified in the optional ____ and ____ clauses of the FOREIGN KEY
constraint. ____ and ____ are followed by either RESTRICT, SET NULL, SET
DEFAULT, or CASCADE. - ON UPDATE and ON DELETE

A ____ is a rule that governs allowable values in a database. ____ are based on
relational and business rules, and implemented with special keywords in a CREATE
TABLE statement. The database automatically rejects insert, update, and delete
statements that violate a constraint. - Constraint(s)

A ____ appears after the column name and data type in a CREATE TABLE statement.
Column constraints govern values in a single column. - Column constraint

A ____ appears in a separate clause of a CREATE TABLE statement and governs
values in one or more columns. - Table constraint

The ____ constraint ensures that values in a column, or group of columns, are unique. -
UNIQUE

The ____ constraint specifies an expression on one or more columns of a table. The
constraint is violated when the expression is FALSE and satisfied when the expression
is either TRUE or NULL. - CHECK

Table ____ may be names using the optional CONSTRAINT keyword, followed by the
constraint name and declaration. - CONSTRAINT

An ____ is a high-level representation of data requirements, ignoring implementing
details. - Entity-relationship model

An ____ is a person, place, product, concept, or activity. - Entity

A ____ is a statement about two entities. - Relationship

An ____ is a descriptive property of an entity. - Attribute

A ____ relates an entity to itself. - Reflexive relationship

An ____, commonly called an ER diagram, is a schematic picture of entities,
relationships, and attributes. - Entity-relationship diagram (ER diagram)

A ____, also known as a ____ or ____, documents additional detail in text format. -
Glossary; data dictionary; repository

An ____ is a set of things. Ex: All employees in a company. - Entity type

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

Guaranteed quality through customer reviews

Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.

Quick and easy check-out

Quick and easy check-out

You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.

Focus on what matters

Focus on what matters

Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!

Frequently asked questions

What do I get when I buy this document?

You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying these notes from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller VasilyKichigin. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for $13.48. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

62890 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling
$13.48
  • (0)
  Add to cart