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

Valentine

20 days ago

I thought the primary key was the key to my heart, not the database. Guess I need to brush up on my SQL skills.

upvoted 0 times

...

Odette

22 days ago

Wow, this is a tough one. I'm just going to randomly guess and hope for the best!

upvoted 0 times

...

Veronica

24 days ago

This is a classic database question. I'm going with B, C, and E as the correct answers.

upvoted 0 times

...

2 months ago

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

upvoted 0 times

Nobuko

23 days ago

C) Primary key and foreign key constraints can be defined at both the column and table level.

upvoted 0 times

...

Nobuko

1 months ago

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

upvoted 0 times

...

Elenore

2 months 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

2 months 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

2 months ago

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

upvoted 0 times

...