CIW Exam 1D0-541 Topic 6 Question 80 Discussion

Actual exam question for CIW's 1D0-541 exam

Question #: 80
Topic #: 6

[All 1D0-541 Questions]

Which type of dependency occurs when one attribute of a composite primary key is removed

and the dependency still exists?

A11

BTransitive

CFunctional

DPartial functional

Show Suggested Answer

Suggested Answer: D

by Ernie at Jan 27, 2024, 09:48 AM

Limited Time Offer

25%

Off

Get Premium 1D0-541 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Carlee

6 days ago

But if one attribute of a composite primary key is removed and the dependency still exists, it's a partial functional dependency.

upvoted 0 times

...

Scarlet

7 days ago

I disagree, I believe the answer is C) Functional.

upvoted 0 times

...

Carlee

8 days ago

I think the answer is D) Partial functional.

upvoted 0 times

...

Alaine

10 days ago

Hmm, I think it's Partial functional. Gotta love those composite keys, always keeping us on our toes!

upvoted 0 times

...

Helaine

10 days ago

I'm not sure, but I think it might be C) Functional dependency.

upvoted 0 times

...

Lavera

12 days ago

I agree with Carissa, because in partial functional dependency, removing one attribute of a composite key still maintains the dependency.

upvoted 0 times

...

Carissa

17 days ago

I think the answer is D) Partial functional.

upvoted 0 times

...