Computer Science, asked by NidhiMenon, 8 months ago

1- Which option allows you to update all the related foreign
key values, if you modify the Primary Key value.
a) Cascade Update Related Fields
c) Enforce Referential
Integrity
b) Cascade Delete Related Records d) Enforce Related
Integrity​

Answers

Answered by rahuljibth1997
3

Answer:

please only one question

( b) b is your answer

Attachments:
Answered by aashnararul
2

Answer: pls mark me as brainliest

Explanation:

Foreign Key Constraint

CONTRIBUTE  

A foreign key is a column (or combination of columns) in a table whose values must match values of a column in some other table. FOREIGN KEY constraints enforce referential integrity, which essentially says that if column value A refers to column value B, then column value B must exist.

For example, given an orders table and a customers table, if you create a column orders.customer_id that references the customers.id primary key:

Each value inserted or updated in orders.customer_id must exactly match a value in customers.id, or be NULL.

Values in customers.id that are referenced by orders.customer_id cannot be deleted or updated, unless you have cascading actions. However, values of customers.id that are not present in orders.customer_id can be deleted or updated.

Similar questions