WGU - D426 Exam; Questions and Answers 100% Correct
8 views 0 purchase
Course
D426 WGU
Institution
D426 WGU
WGU - D426 Exam; Questions and Answers 100%
Correct
A ____ 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...
WGU - D426 Exam ; Questions and Answers 100% Correct A ____ 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 keys 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 the 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 _____ 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. It 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 WGU - D426 Exam ; Questions and Answers 100% Correct 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 to either be fully NULL or match some primary key value. Correct answer Referential integrity ____ rejects an insert, update, or delete that violates referential integrity. Correct answer RESTRICT ____ 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 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. Correct answer Constraint(s) 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
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 GOLDTUTORS. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $11.99. You're not tied to anything after your purchase.