ABAP^TM Certification Questions

Submitted by Chandra

1. Which Open SQL statement should not be used with cluster databases?

A: UPDATE
B: MODIFY
C: DELETE
D: INSERT

2. To include a field on your screen that is not in the ABAP Dictionary, which include program should contain the data declaration for the field?

A: PBO module include program
B: TOP include program
C: PAI module include program
D: Subroutine include program

3. This flow logic statement is used to make multiple fields open for input after an error or warning message.

A: GROUP
B: FIELD-GROUP
C: CHAIN
D: LOOP AT SCREEN

4. Which keyword adds rows to an internal table while accumulating numeric values?

A: INSERT
B: APPEND
C: COLLECT
D: GROUP

5. Assuming itab has a header line, what will be output by the following code?

READ TABLE itab INDEX 3 TRANSPORTING field1.
WRITE: /1 itab-field1, itab-field2.

A: The contents of the third row's itab-field1.
B: The contents of the third row's itab-field1 and itab-field2.
C: The contents of the third row's itab-field2.
D: Nothing.

6. The following code indicates:

SELECTION-SCREEN BEGIN OF BLOCK B1.
PARAMETERS: myparam(10) type C,
Myparam2(10) type N,
SELECTION-SCREEN END OF BLOCK.

A: Draw a box around myparam and myparam2 on the selection screen.
B: Allow myparam and myparam2 to be ready for input during an error dialog.
C: Do not display myparam and myparam2 on the selection screen.
D: Display myparam and myparam2 only if both fields have default values.

7. Which statement will sort the data of an internal table with fields FRUIT, QTY, and PRICE so that it appears as follows?

FRUIT QTY PRICE

Apples 12 22.50
Apples 9 18.25
Oranges 15 17.35
Bananas 20 10.20
Bananas 15 6.89
Bananas 5 2.75

A: SORT itab DESCENDING BY QTY PRICE.
B: SORT itab BY PRICE FRUIT.
C: SORT itab.
D: SORT itab BY PRICE DESCENDING.


8. Which keyword adds a line anywhere within an internal table?

A: APPEND
B: MODIFY
C: ADD
D: INSERT

9. To read a single line of an internal table, use the following:

A: LOOP AT itab. _ ENDLOOP.
B: READ itab.
C: SELECT SINGLE * FROM itab.
D: READ TABLE itab.

10. If this code results in an error, the remedy is:

SELECT fld1 SUM( fld1 ) FROM tab1 INTO_

A: Remove the spaces from SUM( fld1 ).
B: Move SUM( fld1 ) before fld1.
C: Add GROUP BY f1.
D: Change to SUM( DISTINCT f1 ).

Continued..