SAP ABAP Certification Questions 1

SAP ABAP Certification Questions 1

26.

Loop at itab.
Write itab.
Endloop.

From where is the written line derived in the above loop statement?

a) The table work area

b) sy-subrc

c) sy-index

d) The table header

e) sy-lisel

27.

An internal table icode contains the following entries:


Field1 Field2
--------------
John 12345
Alice 23478
Sam 54321
john 50000

DATA: BEGIN OF ICODE OCCURS 0,
FIELD1(5),
FIELD2(5),
END OF ICODE.

READ TABLE ICODE WITH KEY FIELD1 = 'John' BINARY SEARCH.

Why does executing the above code return a sy-subrc of 4?

a) Icode-field2 must be a numeric field.

b) The internal table has an incorrect structure.

c) Both internal table fields must be used in the search.

d) The internal table must be sorted first.

e) 'John' should not be capitalized.

28.

Data: pos like sy-index,
index(1).

do 10 times.
Check sy-index between 2 and 6.
Add 1 to pos.
Move sy-index to index.
Write at pos index.
Enddo.

What is the output of the above code after execution?

a) 26

b) 1789

c) 23456

d) 132578910

e) 178910

29. Dialog programs are of which type?

a) Type B

b) Type 1

c) Type *

d) Type M

e) Type S

30.

data: f1(12) type c value 'Test Variant',
f2(6) type c,
f3(8) type c.

Move: f1 to f2,
f2 to f3.

What do f1, f2, and f3 contain after executing the above code?

a) f1: 'Test Variant'
f2: 'ariant'
f3: ' ariant'

b) f1: 'Test Variant'
f2: 'ariant'
f3: ' Variant'

c) f1: 'Test Variant'
f2: 'Test V'
f3: 'st Varia'

d) f1: 'Test Variant'
f2: 'Test V'
f3: 'Test V '

e) f1: 'Test Variant'
f2: 'Test V'
f3: 'Test Var'

31.

1. Data: Begin of itab occurs 0,
field1,
End of itab.
2. Data: Itab1 like itab occurs 0.
3. Data: Itab1 type itab occurs 0.
4. Data: Begin of itab1 occurs 0.
Include structure itab.
Data: End of itab1.

Which of the above statements code internal tables with a header line?

a) Lines 1 and 4

b) Lines 1 and 3

c) Lines 2 and 4

d) Lines 1 and 2

e) Lines 2 and 3

32. Which one of the following SQL statements does NOT lock the affected database entries ?

a) select *

b) Insert

c) Delete

d) select single for update

e) modify

33.

data: begin of itab occurs 0,
num1 type I,
num2 type I,
num3 type I,
mark,
end of itab.

Delete from itab where mark eq 'D'.

Itab entries:
1 2 3 D
2 3 4
3 4 5 D
4 5 6 D
7 8 9 d
7 8 9 D

Given the ITAB entries, what are the contents of ITAB after executing the above code?

a) 1 2 3 D
2 3 4
3 4 5 D
4 5 6 D
7 8 9 d

b) 2 3 4

c) 7 8 9 d
7 8 9 D

d) 2 3 4
3 4 5 D
4 5 6 D
7 8 9 d
7 8 9 D

e) 2 3 4
7 8 9 d

34.

data: f1 type I value 1,
f2 type I value 1.

Do 2 times.
Perform scope.
Enddo.

Form scope.
Statics: f1 type I value 2,
f2 type I value 2.

Add: 1 to f1, 1 to f2.
Write: / f1, f2.

Perform scope2.

Endform.

Form scope2.
Write: / f1, f2.
Endform.

What is the output of the above program after execution?

a) 3 3
1 1
4 4
1 1

b) 3 3
3 3
3 3
3 3

c) 3 3
3 3
4 4
4 4

d) 3 3
0 0
4 4
0 0

e) 3 3
1 1
4 4
3 3

35. An ABAP Screen is created in which transaction?

a) Screen Editor

b) Screen Painter

c) Menu Painter

d) ABAP Editor

e) Status Painter

36. Data written to the database would be reversed under which of the following circumstances?

a) Dequeue

b) Enqueue

c) Commit

d) Message Xnnn

e) End of Transaction

37. Program specifications ask for error checking on a selection-screen which contains a parameter inside a frame.

a) at selection-screen on block b1

b) selection-screen check block b1

c) at selection-screen

d) selection-screen on field f1

e) check selection-screen

38. Table ztest has a secondary index on the following fields:

tnum, tcode.


Select * from ztest where tnum ne '123' and tcode = '456'.

Why is the index not used in the above case?

a) Indexes are not allowed on Z tables

b) Variables must be used, NOT literals

c) Select individual fields, not select *

d) Client is not in the where clause

e) NE invalidates the use of an index

39. An internal table has two fields :

Field1

Field2

Which of the following is the fastest way to fill an internal table of the structure above.

a) select field1 field2 into (itab-field1, itab-field2)
from ztable where field1 = '10'.
Append itab.
Endselect.

b) select * from ztable
where field1 = '10'.
Move ztable to wa.
Append itab from wa.
Endselect.

c) select * into corresponding-fields of itab
from ztable where field1 = '10'.

d) select * from ztable
where field1 = '10'.
Append itab.
Endselect.

e) select * into table itab from ztable
where field1 = '10'.

40. Update Bundling can occur within which of the following?

a) Within dialog tasks and dequeue processes

b) Within dialog and update tasks

c) Within enqueue processes

d) Within enqueue and dequeue processes

e) Within update tasks and enqueue processes

41.

data: begin of itab occurs 0,
field1,
end of itab.

Do 3 times.
Append initial line to itab.
Append 'X' to itab.
Enddo.

Describe table itab.
Write: sy-tfill.

What is the value of sy-tfill after executing the above code?

a) 1

b) 2

c) 3

d) 6

e) 12

42.

Table zinfo Entries:
-------------------- a1 Smith 100.00 50.00
Field Type a1 Jones 100.00 50.00
-------------------- a2 Bob 100.00 50.00
id C a3 Bob 100.00 50.00
name C a4 Mike 100.00 50.00
sales P a5 Mary 100.00 50.00
sales2 P a5 Mary 100.00 50.00

Using the above information, what is the result of the following code?

Loop at zinfo.
At new name.
Sum.
Write: / zinfo-id, zinfo-name, zinfo-sales.
Endat.
Endloop.

a) a1 Smith 100.00
a1 Jones 100.00
a2 Bob 100.00
a3 Bob 100.00
a4 Mike 100.00
a5 Mary 200.00

b) a1 Smith 100.00
a1 Jones 100.00
a2 Bob 200.00
a4 Mike 100.00
a5 Mary 100.00

c) a1 Jones 200.00
a2 Bob 200.00
a4 Mike 100.00
a5 Mary 100.00
a5 Mary 100.00

d) a1 Jones 200.00
a2 Bob 200.00
a4 Mike 100.00
a5 Mary 100.00

e) a1 Smith 200.00
a2 Bob 100.00
a3 Bob 100.00
a4 Mike 100.00
a5 Mary 200.00

43. Which one of the following is an INCORRECT form of the WRITE statement?

a) write x no-sign.

b) write x no-decimals.

c) write x left-justified no-gap.

d) write x no-zero.

e) write x under y currency us.

44.

1. Data: Begin of imara occurs 0.
2. Include structure mara.
3. Data: End of imara.
4 Data: number like mara-matnr.

5. Select * into table imara
6. From mara where matnr = number.
7. If sy-subrc = 0.
8. Write:/ imara.
9. Endif.
10. Endselect.

Which line in the above code contains a syntax error?

a) 2

b) 5

c) 6

d) 8

e) 10

45.

data: field1(4) type c value 'ABCD'.

if field1 co 'ABCD'.

endif.

What is the value of sy-fdpos after this block of code is executed ?

a) D

b) 4

c) ABCD

d) A

e) 0

46. Which statement is INCORRECT when referring to SAP memory or ABAP memory?

a) ABAP memory is only stored during the lifetime of an external session.

b) You can use ABAP memory to pass data between internal sessions.

c) SAP memory is also referred to as Global Memory.

d) SAP memory is available across transactions.

e) IMPORT/EXPORT (TO MEMORY) statements are used for SAP memory.

47. A standard type internal table ICODE contains the following entries:
field1 field2
-------------
001 New York
002 Boston
003 Houston
008 Denver
010 San Diego
020 Seattle

READ TABLE ICODE WITH KEY FIELD1 = '015' BINARY SEARCH.
WRITE: / SY-TABIX.

What is the value of sy-tabix after executing the above code?

a) 0

b) 2

c) 5

d) 6

e) 7

48.

data: field1 type I value 10.

End-of-selection.
Subtract 2 from field1.
Write: / 'field1 =', field1.

Start-of-selection.
Add 5 to field1.
Write: / 'field1 =', field1.

Initialization.
Field1 = 5.
Write: / 'field1 =', field1.

What is the result after executing the above code?

a) field1 = 5
field1 = 10
field1 = 8

b) field1 = 8
field1 = 14

c) field1 = 10
field1 = 8

d) field1 = 5
field1 = 3
field1 = 8

e) field1 = 8
field1 = 14
field1 = 5

49.

data: f1 type I value 1,
f2 type I value 1.

Do 2 times.
Perform scope.
Enddo.

Form scope.
Statics: f1 type I value 2,
f2 type I value 2.

Add: 1 to f1, 1 to f2.
Write: / f1, f2.

Perform scope2.

Endform.

Form scope2.
Write: / f1, f2.
Endform.

What is the output of the above program after execution?

a) 3 3
1 1
4 4
3 3

b) 3 3
3 3
4 4
4 4

c) 3 3
3 3
3 3
3 3

d) 3 3
1 1
4 4
1 1

e) 3 3
0 0
4 4
0 0

50.

Table ZNAME Table ZINFO
------------- --------------------------
field key field key
------------- --------------------------
mandt X mandt X
id X id X
lname X dept
fname X division
address
phone
fax

Using the above table definitions, which one of the following selects uses proper syntax?

a) select * from zinfo where id = '0025'.
Loop at zinfo.
Write: / id.
Endloop.
Endselect.

b) select mandt id lname into (client, id, lname)
from zname where id = '0025'.

Write: / id.
Endselect.

c) select * into table itab from zname
where id = '0025'.
Select * from zinfo for all entries in itab
where id = itab-id.
Write: / zinfo-dept.
Endselect.

d) select a~id a~lname a~fname b~dept into table itab
from zname as a INNER JOIN zinfo as b
on a~id = b~id
where lname = 'Smith'.

Loop at zname.
Write: / zname-id, zname-lname.
Endloop.

e) select count ( id ) sum ( lname ) into (num, lname)
from zname where id = '0025'.
Write: / num, lname.
Endselect.