Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home SAP C_ABAPD_2309

SAP C_ABAPD_2309 Exam Practice Questions (P. 1)

  • Full Access (79 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #1
What are advantages of using a field symbol for internal table row access? (Choose two.)
  1. A
    Using a field symbol is faster than using a work area.
  2. B
    The field symbol can be reused for other programs.
  3. C
    The row content is copied to the field symbol instead to a work area.
  4. D
    A MODIFY statement to write changed contents back to the table is not required.

Correct Answer: AD ?️

Question #2
Given the following code excerpt that defines an SAP HANA database table:

Which field is defined incorrectly?
  1. A
    field3
  2. B
    field2
  3. C
    field4
  4. D
    field1

Correct Answer: D ?️

Question #3
You have the following CDS definition:

(The data sources are joined by the field carrier_id. The name of the corresponding field in Z_SOURCE2 is carrier_id.)
Which of the following ON conditions must you insert in place of “???”?
  1. A
    ON Z_Source1.carrier_id=Z_Source2.carrier_id
  2. B
    ON $projection.Carrier= Source2.carrier id
  3. C
    ON $projection.Carrier = _Source2.carrier
  4. D
    ON $projection.carrier_id = Z_Source2.carrier_id

Correct Answer: C ?️

Question #4
Which of the following ABAP SQL statements are valid? (Choose two.)
  1. A
    SELECT FROM/dmo/connection -

    FIELDS -
    carrid,
    airpfrom,
    MAX(distance) AS dist_max,

    MIN(distance) AS dist_min -

    GROUP BY carrid, airpfrom -
    INTO TABLE @DATA(It_hits).
  2. B
    SELECT FROM /dmo/connection -

    FIELDS -
    carrid,
    airpfrom,
    MAX (distance) AS dist_max,

    MIN(distance) AS dist_min -
    INTO TABLE @DATA(It_hits).
  3. C
    SELECT FROM /dmo/connection -

    FIELDS -
    MAX(distance) AS dist_max,

    MIN (distance) AS dist_min -
    INTO TABLE @DATA(It_hits).
  4. D
    SELECT FROM /dmo/connection -

    FIELDS -
    carrid,
    airpfrom

    GROUP BY carrid, connid -
    INTO TABLE @DATA(It_hits).

Correct Answer: AC ?️

Question #5
What would be the correct expression to change a given string value ‘mr joe doe’ into ‘JOE’ in an ABAP SQL field list?
  1. A
    SELECT FROM TABLE dbtad1 -

    FIELDS -
    f1,
    substring (upper( ‘mr joe doe’), 4, 3 ) AS f2_sub_up,
    f3, …
  2. B
    SELECT FROM TABLE dbtab 1 -

    FIELDS -
    f1,
    left( lower( substring( ‘mr joe doe’ , 4, 3 ) ) , 3 ) AS f2_left_lo_sub, f3, …
  3. C
    SELECT FROM TABLE dbtad1 -

    FIELDS -
    f1,
    substring ( lower( upper( ‘mr joe doe’) ), 4, 3 ) AS f2_sub_lo_up, f3, …
  4. D
    . SELECT FROM TABLE dbtad1

    FIELDS -
    f1,
    upper(left( ‘mr joe doe’ , 6 ) ) AS f2_up_left,
    f3, …

Correct Answer: A ?️

Next Questions

All Pages