SAP C_ABAPD_2309 SAP Certified Associate - Back-End Developer - ABAP Cloud Exam Exam Practice Test Questions

• Question 1

  What are some characteristics of secondary keys for internal tables? Note: There are 3 correct answers to this question.

  • Secondary keys must be chosen explicitly when you actually read from an internal table.
  • Multiple secondary keys are allowed for any kind of internal table.
  • Hashed secondary keys do NOT have to be unique.
  • Sorted secondary keys do NOT have to be unique.
  • Secondary keys can only be created for standard tables.

  Show Answer Answer: A, ,B, ,D Next

• Question 2

  Which of the following ABAP SQL statements are valid? Note: There are 2 correct answers to this question.SELECT FROM /dmo/connection FIELDS carrid O airpfrom,MAX(distance) AS dist_max, MIN( distance) AS dist_min GROUP BY carrid, airpfrom INTO TABLE @DATA(It_hits)SELECT FROM /dmo/connection FIELDS \/ O carrid, airpfrom,MAX( distance) AS dist_max, MIN(distance) AS dist_min INTO TABLE @DATA(It_hits)SELECT FROM /dmo/connection FIELDS V D MAX(distance) AS dist_max MIN(distance) AS dist_min INTO TABLE @DATA(It_hits).SELECT FROM /dmo/connection FIELDS r—i carrid, airpfrom u GROUP BY carrid, connid INTO TABLE @DATA(It_hits).

  • B: This statement is valid. It is similar to statement A, except that it does not specify the GROUP BY clause. This means that the aggregate functions are applied to the entire table, and the results are stored in an internal table named It_hits, which is created using the inline declaration operator @DATA.
  • C: This statement is invalid. It selects the aggregate functions MAX(distance) and MIN(distance) from the table /dmo/connection, but it does not specify any grouping or non-aggregate fields. This is not allowed in ABAP SQL, as the SELECT list must contain at least one non-aggregate field or a GROUP BY clause. The statement will cause a syntax error.
  • D: This statement is invalid. It selects the fields carrid and airpfrom from the table /dmo/connection, and groups the results by carrid and connid. However, the field connid is not included in the SELECT list, which is not allowed in ABAP SQL, as the GROUP BY clause must contain only fields that are also in the SELECT list. The statement will cause a syntax error.

  Show Answer Answer: A,B Next

• Question 3

  Which of the following actions cause an indirect change to a database table requiring a table conversion? Note: There are 2 correct answers to this question.

  • Renaming a field in a structure that is included in the table definition
  • Changing the field labels of a data element that is used in the table definition.
  • Deleting a field from a structure that is included in the table definition.
  • Shortening the length of a domain used in a data element that is used in the table definition.

  Show Answer Answer: A, ,C Next

• Question 4

  When processing an internal table with the statement LOOP AT itab... ENDLOOP, what system variable contains the current row number?

  • Sy-index
  • Sy-subrc
  • Sy-linno
  • Sy-tabix

  Show Answer Answer: D Next

• Question 5

  In a RESTful Application Programming application, in which objects do you bind a CDS view to create a value help? Note: There are 3 correct answers to this question.

  • Data model view
  • Behavior definition
  • Metadata Extension
  • Service Definition
  • Projection View

  Show Answer Answer: A, ,C, ,E Next