Oracle Exam 1Z0-071 Topic 11 Question 97 Discussion

Actual exam question for Oracle's 1Z0-071 exam

Question #: 97
Topic #: 11

Which statements are true regarding primary and foreign key constraints and the effect they can have on table data?

AA table can have only one primary key but multiple foreign keys.

BIt is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted.

CPrimary key and foreign key constraints can be defined at both the column and table level.

DOnly the primary key can be defined the column and table level.

EIt is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted.

FThe foreign key columns and parent table primary key columns must have the same names.

GA table can have only one primary key and one foreign key.

Show Suggested Answer

Suggested Answer: E

by Danica at Jul 06, 2024, 04:09 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-071 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Brandee

7 days ago

E is definitely true, but I'm not confident about the others. The question seems a bit tricky.

upvoted 0 times

...

Ena

11 days ago

I agree with both of you, statement E is also true because child rows with foreign keys can be deleted automatically.

upvoted 0 times

...

Gracie

12 days ago

I disagree, I believe statement B is true because child rows with foreign keys can stay even if parent row is deleted.

upvoted 0 times

...

Odette

14 days ago

I think statement A is true because a table can have multiple foreign keys.

upvoted 0 times

...

Lacresha

15 days ago

I think A and C are true, but I'm not sure about the rest of the options.

upvoted 0 times

...

Elenore

17 days ago

I agree with both of you, statement E is also true because child rows with foreign keys can be deleted automatically.

upvoted 0 times

...

Eric

18 days ago

I disagree, I believe statement B is true because child rows with foreign keys can stay even if parent row is deleted.

upvoted 0 times

...

Colton

29 days ago

I think statement A is true because a table can have multiple foreign keys.

upvoted 0 times

...