SAP Certified Associate Back End Developer ABAP Cloud · Free Practice Question Medium
Question 21
What are some features of a unique secondary key? Note: There are 2 correct answers to this question.
-
A
It is created with the first read access of a table.
-
B
It is created when a table is filled.
-
C
It is updated when the modified table is read again.
-
D
It is updated when the table is modified.
Reveal correct answers
Correct answers: B, D
Explanation
A unique secondary key has two purposes – firstly to speed up access to the table, and secondly to ensure that the key combination of all of the rows in the table is unique. Consequently, the system must always keep the key up to date and uses a different update strategy to secondary keys that are non-unique.
Any operation that changes the contents of the internal table (filling or changing its contents) leads to the index either being created (first access) or updated (subsequent accesses). Read accesses are always fast because the secondary index is always already up to date.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
