Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

SAP Exam C_ABAPD_2309 Topic 3 Question 41 Discussion

Actual exam question for SAP's C_ABAPD_2309 exam
Question #: 41
Topic #: 3
[All C_ABAPD_2309 Questions]

What are some features of a unique secondary key? Note: There are 2 correct answers to this question.

Show Suggested Answer Hide Answer
Suggested Answer: C, D

A unique secondary key is a type of secondary key that ensures that the key combination of all the rows in a table is unique.A unique secondary key has two purposes: firstly, to speed up access to the table, and secondly, to enforce data integrity1.

It is created with the first read access of a table: This is true. A unique secondary key is created when an internal table is filled for the first time using the statement READ TABLE or a similar statement.The system assigns a name and an index to each row of the table based on the key fields23.

It is updated when the modified table is read again: This is false. A unique secondary key does not need to be updated when the internal table content changes, because it already ensures data uniqueness.The system uses a lazy update strategy for non-unique secondary keys, which means that it delays updating them until they are actually accessed23.

You cannot do any of the following:

It is created when a table is filled: This is false.As explained above, a unique secondary key is created only with the first read access of a table23.

It is updated when the modified table is read again: This is false.As explained above, a unique secondary key does not need to be updated when the internal table content changes23.


by Selma at Jun 13, 2025, 09:00 PM

Limited Time Offer

25%

Off

Get Premium C_ABAPD_2309 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel
Christiane
4 days ago
Hmm, I'm not sure about that. Shouldn't the secondary key be created with the first read access of the table? That's what option C says.
upvoted 0 times
...
Alpha
7 days ago
I think A and D are the correct answers. The secondary key is created when the table is filled, and it's updated when the table is modified.
upvoted 0 times
...

Save Cancel