Deleting a parent row is rejected while child rows exist.

Matching child rows are moved into the parent table.

Deleting a parent row sets the matching child foreign keys to NULL.

Deleting a row from the parent table deletes the matching rows in the child table, cascading further if needed.

The named columns are updated for all rows in the table.

PostgreSQL raises an error.

Only the first row is updated.

No rows are updated.

6, 4, 3, 1

6, 4, 4, 1

2, 3, 3, 5

3, 5, 1, 6

6, 4

5, 3

4, 3

5, 6

6, 4, 4, 1

2, 3, 3, 5

3, 3, 1, 6

3, 5, 3, 1

ALIAS

BY

AS

INTO

6, 4

5, 3

4, 3

5, 6

6, 4, 4, 1

2, 3, 3, 5

3, 3, 1, 6

3, 5, 3, 1

{S | Staff(S) ˄ (∃P) (PropertyForRent(P) ˄  (P.staffNo = S.staffNo) ˄ P.city = ‘London’)}

{S | Staff(S) ˅ (∃P) (PropertyForRent(P) ˅  (P.staffNo = S.staffNo) ˅ P.city = ‘London’)}

{S.fName, S.lName  | Staff(S) ˅ (∃P) (PropertyForRent(P) ˅  (P.staffNo = S.staffNo) ˅ P.city = ‘London’)}

{S.fName, S.lName  | Staff(S) ˄ (∃P) (PropertyForRent(P) ˄  (P.staffNo = S.staffNo) ˄ P.city = ‘London’)}

Only rows containing no null values.

Only distinct rows.

Only rows where the first column is not null.

All rows of a table, regardless of nulls or duplicate values.