UDEMY3

Question 1

Choose the correct statement related to Database Tables.

There are 2 correct answers.

Answer 1

• They store information in two dimensions.
• They can have relationships with other tables.

Question 2

In a subclass lcl_sub, you want to redefine a component of a superclass lcl_sup. How do you achieve this?

There are 2 correct answers.

Answer 2

• you add the clause REDEFINITION to the component in lcl_sub.
• You implement the redefined component in lcl_sub

Question 3

For the assignment,
lv_target = lv_source.

which of the following data declarations will always work without truncation or rounding?

There are 2 correct answers.

Answer 3

• DATA lv_source TYPE d.
  to
  DATA lv_target TYPE string.
• DATA lv_source TYPE c.
  to
  DATA lv_target TYPE string.

Question 4

Choose the correct annotation.

You want to provide a short description of the data definition for developers that will be attached to the database CDS view.

Answer 4

@EndUserText.Label

Question 5

Which of the following is a generic internal table type?

Answer 5

INDEX TABLE

Question 6

Choose the correct case expression.

2 answers are correct.

Answer 6

• CASE
  WHEN smoker = ‘X’ AND custtype = ‘B’ THEN loccuram + 100

WHEN smoker = ‘X’ AND custtype = ‘P’ THEN loccuram + 200

ELSE loccuram
END AS inc_smoker_charge

• CASE smoker
  WHEN ‘X’ THEN loccuram + 100

ELSE loccuram
END AS inc_smoker_charge

Question 7

Data (lv_result) = 1/8.

what will be the data type of lv_result?

Answer 7

TYPE I

Question 8

Which of the following parts of a behavior definition are generated automatically?

2 answers are correct.

Answer 8

• Draft enabling
• Create, update, and delete operations

Question 9

What RESTful Application Programming feature is used to ensure the uniqueness of a semantic key?

Answer 9

Validation

Question 10

Which system variable holds the current row number when an internal table is processed using the LOOP AT itab… ENDLOOP statement?

Answer 10

sy-tabix

Question 11

Which of the following annotations can be mandatory in the definition of a CDS view entity?

Answer 11

@Semantics.quantity.unitofMeasure

Question 12

Which of the following are valid sort operations for internal tables?

There are 3 correct answers.

Answer 12

• SORT itab BY field1 field2.
• SORT itab DESCENDING.
• SORT itab BY field1 ASCENDING field2 DESCENDING.

Question 13

Which of the following ABAP SQL statements are valid?

There are 2 correct answers.

Answer 13

• SELECT FROM sbook FIELDS carrid, connid, MAX( LOCCURAM ) AS dist_max, MIN( LUGGWEIGHT ) AS dist_min GROUP BY carrid, connid INTO TABLE @DATA(lt_tab).
• SELECT FROM sbook FIELDS MAX( LOCCURAM ) AS dist_max, MIN( LUGGWEIGHT ) AS dist_min INTO TABLE @DATA(lt_tab).