Exam (elaborations)
WGU D426 V2 Exam 482 Questions with Verified Answers,100% CORRECT
- Course
- Institution
WGU D426 V2 Exam 482 Questions with Verified Answers
[Show more]
Content preview
WGU D426 V2 Exam 482 Questions with Verified AnswersA _______________ is a column, or group of columns, used to identify a row. -
CORRECT ANSWER Primary Key
A _______________ consists of a single column. - CORRECT ANSWER Simple
Primary Key
A _______________ key consists of multiple columns. - CORRECT ANSWER
Composite Primary
All primary key columns are necessary for uniqueness. When any column is
removed, the resulting simple or composite column is no longer unique. -
CORRECT ANSWER Minimal
The _______________ constraint in a CREATE TABLE statement names the table's
_______________. The _______________ constraint ensures that a column or
group of columns is always unique and non-null. - CORRECT ANSWER PRIMARY
KEY
An a_______________ is a numeric column that is assigned an automatically
incrementing value when a new row is inserted. - CORRECT ANSWER Auto-
increment Column
The _______________ keyword defines an auto-increment column.
AUTO_INCREMENT follows the column's data type in a CREATE TABLE statement.
- CORRECT ANSWER AUTO_INCREMENT
A _______________ is a column, or group of columns, that refer to a primary key.
- CORRECT ANSWER Foreign Key
_______________requires foreign key values must either be NULL or match some
value of the referenced primary key. - CORRECT ANSWER Referential Integrity
,A _______________ constraint is added to a CREATE TABLE statement with the
_______________ and REFERENCES keywords. - CORRECT ANSWER FOREIGN
KEY / REFERENCES
A _______________ foreign key is a simple or composite foreign key in which all
columns are NULL. - CORRECT ANSWER Fully NULL
_______________ is a relational rule that requires foreign key values are either
fully NULL or match some primary key value. - CORRECT ANSWER Referential
Integrity
_______________ sets invalid foreign keys to NULL. - CORRECT ANSWER SET
NULL
_______________ sets invalid foreign keys to the foreign key default value. -
CORRECT ANSWER SET DEFAULT
_______________ propagates primary key changes to foreign keys. - CORRECT
ANSWER 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. - CORRECT
ANSWER ON UPDATE / 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. - CORRECT
ANSWER Constraint
A _______________ appears after the column name and data type in a CREATE
TABLE statement. Column constraints govern values in a single column. -
CORRECT ANSWER Column Constraint
,A _______________t appears in a separate clause of a CREATE TABLE statement
and governs values in one or more columns. - CORRECT ANSWER Table Constraint
The _______________ constraint ensures that values in a column, or group of
columns, are unique. - CORRECT ANSWER 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. - CORRECT ANSWER CHECK
Table _______________may be named using the optional CONSTRAINT keyword,
followed by the constraint name and declaration. - CORRECT ANSWER
CONSTRAINT
An _______________is a high-level representation of data requirements, ignoring
implementation details. - CORRECT ANSWER Entity-relationship model
An _______________is a person, place, product, concept, or activity. - CORRECT
ANSWER Entity
A _______________is a statement about two entities. - CORRECT ANSWER
Relationship
An _______________is a descriptive property of an entity. - CORRECT ANSWER
Attribute
An _______________, commonly called an ER diagram, is a schematic picture of
entities, relationships, and attributes. - CORRECT ANSWER Entity-relationship
diagram / ER diagram
An _______________ is a set of things. Ex: All employees in a company. -
CORRECT ANSWER Entity Type
An _______________ is a set of values. Ex: All employee salaries. - CORRECT
ANSWER Attribute type
, An _______________ is an individual thing. Ex: The employee Sam Snead. -
CORRECT ANSWER Entity instance
A_______________ is a statement about entity instances. Ex: "Maria Rodriguez
manages Sales.". - CORRECT ANSWER Relationship instance
An _______________ is an individual value. Ex: The salary $35,000. - CORRECT
ANSWER Attribute instance
_______________ develops an entity-relationship model, capturing data
requirements while ignoring implementation details. - CORRECT ANSWER Analysis
_______________ converts the entity-relationship model into tables, columns,
and keys for a particular database system. - CORRECT ANSWER Logical design
_______________ adds indexes and specifies how tables are organized on storage
media. - CORRECT ANSWER Physical design
In entity-relationship modeling, _______________refers to maxima and minima
of relationships and attributes. - CORRECT ANSWER Cardinality
_______________ is the greatest number of instances of one entity that can
relate to a single instance of another entity. - CORRECT ANSWER Relationship
maximum
A related entity is _______________when the maximum is one and
_______________when the maximum is many. - CORRECT ANSWER Singular /
plural
_______________ is the least number of instances of one entity that can relate to
a single instance of another entity. - CORRECT ANSWER relationship minimum
A related entity is _______________when the minimum is zero and
_______________ when the minimum is one. - CORRECT ANSWER
Optional/Required
The benefits of buying summaries with Stuvia:
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
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
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 paulhans. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $16.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
83637 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now