C-ABAPD-2309 試験問題を無料オンラインアクセス

Given the following Core Data Service View Entity Data Definition:
1 @AccessControl.authorizationCheck: #NOT_REQUIRED
2 DEFINE VIEW ENTITY demo_flight_info_join
3 AS SELECT
4 FROM scarr AS a
5 LEFT OUTER JOIN scounter AS c
6 LEFT OUTER JOIN sairport AS p
7 ON p.id = c.airport
8 ON a.carrid = c.carrid
9 {
10 a.carridAS carrier_id,
11 p.idAS airport_id,
12 c.countnumAS counter_number
13 }
In what order will the join statements be executed?

• A.scounter will be joined to sairport first and the result will be joined with scarr.
• B.sairport will be joined to scounter first and the result will be joined with scarr.
• C.scarr will be joined with sairport first and the result will be joined with scounter.
• D.scarr will be joined with scounter first and the result will be joined with sairport.

Which of the following ABAP SQL statements are valid? Note: There are 2 correct answers to this question.

• A.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)
• B.SELECT FROM /dmo/connection FIELDS r-i carrid, airpfrom u GROUP BY carrid, connid INTO TABLE @DATA(It_hits).
• C.SELECT FROM /dmo/connection FIELDS V D MAX(distance) AS dist_max
  MIN(distance) AS dist_min INTO TABLE @DATA(It_hits).
• D.SELECT FROM /dmo/connection FIELDS \/ O carrid, airpfrom,
  MAX( distance) AS dist_max, MIN(distance) AS dist_min INTO TABLE @DATA(It_hits)

Using ABAP SQL, which select statement selects the mat field on line #17?

• A.SELECT mat FROM Material...
• B.SELECT mat FROM demo sales cds material ve...
• C.SELECT mat FROM demo_sales_so_i...
• D.SELECT mat FROM demo_sales_cds_so_i_ve...

You are designing the following select statement in ABAP Open SQL:

To adhere to the most recent ABAP SQL syntax conventions from SAP, on which line must you insert the
"INTO TABLE @gt flights" clause to complete the SQL statement?

• A.#4
• B.#15
• C.#6
• D.#8

For the assignment, gv_target = gv_source.
which of the following data declarations will always work without truncation or rounding? Note: There are 2 correct answers to this question.

• A.DATA gv_source TYPE string, to DATA gv_target TYPE c.
• B.DATA gv_source TYPE c. to DATA gv_target TYPE string.
• C.DATA gv_source TYPE d. to DATA gv_target TYPE string.
• D.DATA gv_source TYPE p LENGTH 8 DECIMALS 3. to DATA gv_target TYPE p LENGTH 16 DECIMALS 2.