SAP R/3 форум ABAP консультантов
Russian ABAP Developer's Club

Home - FAQ - Search - Memberlist - Usergroups - Profile - Log in to check your private messages - Register - Log in - English
Blogs - Weblogs News

ABAP certification questions



 
Post new topic   Reply to topic    Russian ABAP Developer's Club Forum Index -> E-Courses | Электронные курсы
View previous topic :: View next topic  
Author Message
admin
Администратор
Администратор



Joined: 01 Sep 2007
Posts: 1636

PostPosted: Fri Feb 27, 2009 2:31 pm    Post subject: ABAP certification questions Reply with quote

1. What is the fastest way to move one internal table to another internal table (assuming two tables of similar structure)?

a) append lines of table1 to table2.
b) loop at table1.
Move: table1-field1 to table2-field1,
table1-field2 to table2-field2.
Append table2.
Endloop.
c) table2[] = table1[].
d) loop at table1.
Move-corresponding table1 to table2.
Endloop.
e) move table1 to table2.

2. Which one of the following is true about a function module?

a) Function modules are locally accessible objects.
b) Function modules have inbound and outbound parameters.
c) Function modules have no built-in exception handling.
d) Function modules CANNOT be created by a programmer.
e) Function modules use a shared memory area.


3.
data: field1 type I value 10.
a) field1 = 10
field1 = 8
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?
b) field1 = 8
field1 = 14
field1 = 5
c) field1 = 5
field1 = 3
field1 = 8
d) field1 = 5
field1 = 10
field1 = 8
e) field1 = 8
field1 = 14

4. Which one of the following commands is used in drill-down reporting?

a) AT LINE-SELECTION
b) MODULE SET_SCREEN
c) LEAVE SCREEN
d) END-OF-PAGE
e) ON VALUE-REQUEST

5. What is an object which CANNOT be transported?

a) A local object
b) A change request
c) A development object
d) A class
e) A task

6. A GUI-Status is created in which transaction?

a) Flow Logic
b) Menu Painter
c) GUI Painter
d) Screen Painter
e) Status Painter

7. Which one of the following statements creates a GUI-status in a dialog program?a) set pf-status '0100?.

b) set screen '0100?.
c) set gui-status '0100?.
d) set gui-status = '0100?.
e) set status '0100?.

8. Dialog programs have which naming convention?

a) ZPBOxxx
b) SAPMZxxx
c) ZDIAxxx
d) ZPAIxxx
e) Zxxx

9. Which dictionary structure contains system fields?

a) SYSTEM
b) SYTAB
c) SYST
d) SY
e) SYS

10.
a) 1
An internal table ICODE contains the following entries:
field1 field2
-----
John 12345
Alice 23478
Sam 54321
Bob 10000
IF NOT ICODE[] IS INITIAL.
SORT ICODE BY FIELD1 DESCENDING.
READ TABLE ICODE WITH KEY FIELD1 = 'Sam'.
WRITE: / SY-TABIX.
ENDIF.
What is the output of the above code after execution?
b) 2
c) 3
d) 4
e) Sam

11.
a) 4
Data: number type i.
while number < 10.
Add 1 to number.
If number < 8.
Continue.
Else.
Add 4 to number.
Endif.
Endwhile.
Write number.
What does NUMBER equal after executing the above code?
b) 8
c) 10
d) 12
e) 14

12. Which one of the following statements would occur in the PBO of a dialog program using table control?

a) loop at itab.
b) loop at itab with control itab_tc.
c) module exit at exit-command.
d) module user_command.
e) set screen '0100?

13.
data: begin of itab occurs 0,
field1(10),
field2(10),
end of itab.
a) A B
A B
B B
A
Move: 'A' to itab-field1,
'B' to itab-field2.
Append itab.
Append itab.
Move: 'B' to itab-field1.
Append itab.
Clear itab.
Move: 'A' to itab-field2.
Append itab.
What are the contents of itab after executing the above code?
b) A B
A B
B
A
c) A B
B
A
d) A B
B A
A
e) A B
B A
B A
B A

14. When debugging a BDC session, which command is used to exit the session?

a) /n
b) /bend
c) /nexit
d) /nquit
e) /exit

15. Which system field returns the number of records returned after a select?

a) sy-index
b) sy-recno
c) sy-lncnt
d) sy-dbcnt
e) sy-tabix

16. Which statement regarding Logical databases is FALSE?

a) Logical databases use a tree structure.
b) Logical databases use a standard selection-screen for selection criteria.
c) More than one logical database can be used in a report.
d) Any change to a logical database is reflected in all reports using that logical database.
e) Logical databases simplify and encapsulate data retrieval

17. Which one of the following is an example of an asynchronous update?

a) modify ztable from wa.
b) update ztable set field1 = '123?.
c) update ztable from ztable.
d) insert wa into ztable.
e) call function 'update_table' in update task

18. Which return code is associated with a failed authority check due to lack of user authorization for the chosen action?

a) 0
b) 4
c) 8
d) 12
e) 24

19. Which transaction is used to monitor, release, and reprocess BDC sessions?

a) SM36
b) SE37
c) SE35
d) SP35
e) SM35

20. What is the structure for the following select-options? Select-options: zname like ztable-name.
a) zname-sign
zname-value
zname-low
zname-high
b) zname-low
zname-high
zname-pattern
c) zname-sign
zname-option
zname-low
zname-high
d) zname-sign
zname-option
zname-low
e) zname-sign
zname-option
zname-low

21. Which of the following are elementary types in ABAP?

a) C,D,F,H,I,N,P,T
b) C,D,F,I,N,P,Q,T
c) A,D,F,I,N,P,T,X
d) A,D,F,H,N,P,T,X
e) C,D,F,I,N,P,T,X

22.
a) 1 1
3 3
4 4
4 4
data: f1 type I value 1,
f2 type I value 1.
Write: / f1, f2.
Do 2 times.
Perform scope.
Enddo.
Write: / f1, f2.
Form scope.
Data: f1 type I value 2,
f2 type I value 2.
Add: 1 to f1, 1 to f2.
Write: / f1, f2.
Endform.
What is the output of this program after execution?

b) 1 1
2 2
3 3
1 1
c) 1 1
3 3
3 3
3 3
d) 1 1
2 2
3 3
3 3
e) 1 1
3 3
3 3
1 1

23. Program specs call for screen 100 to appear in a modal dialog box.
a) The addition 'starting at X' is left out.
PAI
----
module do_something.
If field1 = 'X'.
Call screen '0100?.
Endif.
Endmodule.
Why does the above code fail to produce a modal box?
b) The screen should be numbered 900.
c) The code must occur in the PBO.
d) The screen is of the wrong type.
e) Screens are not called within modules.

24. Field-symbols are defined in which of the following ways?

a) field-symbols f1 for f1.
b) field-symbols [f1].
c) field-symbols like f1.
d) field-symbols (f1) like f1.
e) field-symbols {f1}.

25.
a) Line 2
1 TABLES: MARC.
2 DATA: BEGIN OF ITAB OCCURS 0,
3 FIELD1(5),
4 FIELD2(5),
5 END OF ITAB.
6 READ ITAB WITH KEY MATNR = '12345?.
7 IF SY-SUBRC = 0.
8 WRITE:/ ITAB-MATNR.
9 ENDIF.
Referring to the above code, which line contains an error?
b) Line 5
c) Line 6
d) Line 7
e) Line 8

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.
a) Icode-field2 must be a numeric field.
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?
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.
a) 26
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?
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.
a) f1: 'Test Variant'
f2: 'ariant'
f3: ' ariant'
data: f1(12) type c value 'Test Variant',
f2(6) type c,
f3(Cool type c.
Move: f1 to f2,
f2 to f3.
What do f1, f2, and f3 contain after executing the above code?
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.
a) Lines 1 and 4
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?
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.
a) 1 2 3 D
2 3 4
3 4 5 D
4 5 6 D
7 8 9 d
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?

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.
a) 3 3
1 1
4 4
1 1
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?
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:
a) Indexes are not allowed on Z tables
tnum, tcode.
Select * from ztest where tnum ne '123? and tcode = '456?.
Why is the index not used in the above case?
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 :
a) select field1 field2 into (itab-field1, itab-field2)
from ztable where field1 = '10?.
Append itab.
Endselect.
Field1
Field2
Which of the following is the fastest way to fill an internal table of the structure above.
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.
a) 1
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?
b) 2
c) 3
d) 6
e) 12

42.
Loop at zinfo.
At new name.
Sum.
Write: / zinfo-id, zinfo-name, zinfo-sales.
Endat.
Endloop.
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?
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.
a) 2
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?
b) 5
c) 6
d) 8
e) 10

45.
a) D
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 ?
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.

51. Which one of the following statements is FALSE?
a) Local objects CANNOT be transported to another instance.
b) After a CHANGE REQUEST is released, no further changes to its' objects are allowed.
c) Development classes can be viewed by using transaction SE80.
d) A CHANGE REQUEST contains objects that can be transported to QA-PRD.
e) A CHANGE REQUEST only contains one task.

52. Which one of the following statements would occur in the PBO of a dialog program using table control?
a) loop at itab with control itab_tc.
b) loop at itab.
c) set screen '0100?.
d) module user_command.
e) module exit at exit-command

53.
data n type i.
do 5 times.
If n > 0 and n < 5.
n = n + 1.
elseif n = 5.
n = n - 5.
else.
n = n - 1.
endif.
enddo.
Write: / n.
If n = 3, what is the output of this code after execution?
a) 2-
b) 1-
c) 0
d) 3
e) 5

54. You have added an append structure to a standard SAP table. What happens to the standard table when a new version of the table is imported during an upgrade?
a) The standard table is returned to standard.Therefore, the append structure must be manually re-applied
b) The append fields are automatically appended to the table upon activation but you must still convert the table
c) All append structures are deleted. A new append structure must be created and then appended to the standard table
d) When the standard tables are activated, the append structure is automatically appended to the standard table

55. What can you NOT attach a search help to?
a) type
b) field of a table
c) check table
d) data element
e) table

56. Which of the following does not physically exist in the underlying database? More than one answer is correct.
a) View
b) Internal table
c) Structure
d) Transparent Table
e) Domain

57. What conditoins apply for a LEFT Outer Join in OPEN SQL?
a) Only 'Or' can be used as a logical operator in the ON condition
b) A join statement is found to the right of the join operator
c) At least one field from the table on the right is required for comparison in the ON condition
d) A Left Outer Join is not permitted in OPEN SQL

58. What is true about a check table?
a) Foreign key fields can accept only values which exist in the check table
b) Check table fields can accept only values which exist in the check table
c) Foreign key fields can accept any values regardless of the check table
d) Check tables are not used for restricting values in the foreign key tables

59. Full buffering would be appropriate for what type of tables?
a) Small Static tables
b) Transaction Tables
c) Tables with generic Keys
d) Internal Tables

60. Where does information come from when you press F1 on a screen field?
a) Domain short text
b) Search help
c) Data element documentation
d) Domain Help values

61. What are the main functions of a Data Dictionary? More than one answer is correct.
a) To insulate the ABAP/4 developer from the database
b) To support the creation and management of metadata (data about data)
c) To provide data security at the application level
d) To connect to the operating system

62. Structure MY_STRUCTURE is created in the dictionary. When does the structure get created in the underlying database ?
a) At the beginning of the table creation
b) When the database administrator physically creates the table
c) When the table is activated
d) At the end of the table creation after it is saved.
e) It does not correspond to an object in the underlying database and does not get created

63. What is the recommended method to modify a standard search help to include customer defined search paths?
a) Add an elementary search help to the standard search help
b) Enhance the standard search help with an append search help
c) Add a collective search help to the standard search help
d) Perform a modification to the standard search help

64. Where are Dictionary runtime objects used ?
a) in the dictionary
b) in structures
c) in table "nametab"
d) in work processes

65. If you want a subroutine U to have a formal parameter P that is used to return a value to the actual parameter . Which of the following definitions of U would you use to ensure that the value is passed back to the calling program only if the processing of U ends normally and is not terminated with a message statement ?
a) Form U changing P.
b) Form U using P.
c) Form U changing value(P).
d) Form U using value(P).
e) Form U using P local P.

66. You want to go from dialog processing to list processing using a selection screen . Which statements would you use?
a) call screen .
b) read list.
c) call transaction .
d) leave to ist processing followed by call selection-screen .
e) selection-screen followed by parameters.

67. Which component on the application server controls the data traffic between work process and presentation server?
a) SapGui.
b) message handler.
c) dispatcher.
d) Dynpro processor.
e) frontend processor.

68. Which options exist for extending a table without having to modify a table within the ABAP Dictionary? More than one answer is correct.
a) append fields to the table.
b) use append structures.
c) use customer includes.
d) CI includes.
e) Insert new table fields.

69. Which of the following steps should be carried out in a transaction that implements updates ? More than one answer is correct.
a) read the record that is to be updated.
b) lock the record that is to be updated.
c) pass the changed data to the update process.
d) unlock the record that is to be updated.
e) call the Abap command commit work.

70. Which enhancements planned by SAP are maintained in transaction CMOD (SAP enhancements)? More than one answer is correct.
a) Table appends
b) Menu exits
c) function module exits
d) User exits
e) Screen exits

71. Why would you group corrections together? More than one answer is correct.
a) To enable several corrections to be assigned to the same transport.
b) To transport objects from different development classes.
c) To prevent other developers from processing the same objects.
d) To enable several developers to process the same object in parallel.
e) To retain versions of several objects together.

72. Which statements are allowed if you are working with an internal table of type sorted? More than one answer is correct.
a) Append
b) Collect
c) Sort
d) Read
e) Modify

73. How can you set the status and title for a modal dialog box?
a) In the attributes of the corresponding screen.
b) Before the corresp. call screen statement.
c) In a PBO module of the corresponding screen.
d) In the PAI module of the corresponding screen.

74. Which ABAP datatype would you use for calculations which require high degree of precision?
a) P
b) I
c) F
d) N
e) X

75. Which of the following statements about R/3 instances are correct? More than one answer is correct.
a) An R/3 instance is an administrative unit that combines together all the components of a R/3 system that provide one or more services.
b) A central R/3 system consists of one or more Instances.
c) Each instance has its own SAP buffer area.
d) Each instance contains at least one dialog service .

76. Where can you find the SET/GET parameters that has been assigned to a screen field? More than one answer is correct.
a) in table TPARA.
b) in the object list of the module pool.
c) in the F1 help for the screen field under technical info.
d) in the field list of the screen in the screen painter.
e) in the window with possible values.

77. Which letters are allowed to be the first letter in the names of customer defined tables,structures and global types? More than one answer is correct.
a) Y
b) Z
c) W
d) T

78. What must you do to undo DB changes previously issued in a dialog? More than one answer is correct.
a) output E message.
b) perform rollback work.
c) raise exception.
d) Analyze log record.
e) code rollback LUW.

79. An update function module VF is called within subprogram VU .The program contains the call , VU on commit . At which point are the parameters for the update function VF evaluated ?
a) when perform is executed
b) at the beginning of function
c) at commit work
d) at start of v1 update
e) at the end of the dialog step

80. Which events and statements determine the end of an SAP LUW in an online program with synchronous update? More than one answer is correct.
a) call function in update task
b) the start of the next dialog step
c) commit work (explicit)
d) call screen
e) leave to list processing

81. What methods can be used to set the values for printing an online list? More than one answer is correct.
a) Include SET_PRINT_PARAMTERS
b) Function SET_PRINT_PARAMETERS
c) NEW-PAGE PRINT ON
d) Function GET_PRINT_PARAMETERS

82. What does a LDB(Logical Database) provide?
a) Consistent and flexible user interface
b) Central performance improvements for update accesses
c) A method to access the data in a random manner
d) Centrally defined authorization checks

83. When you EXPORT an internal table that has a header line to ABAP/4 memory, what is the result?
a) Only the contents of the internal table is stored
b) Only the header line is stored
c) The header line and contents of the internal table are stored
d) You cannot EXPORT an internal table with a header line.

84. Which Report Statement option determines the width of a list?
a) Line-Size
b) Line-Count
c) Line-Width
d) Report Size

85. What happens to memory when the Export is executed without specifying ID. i.e EXPORT object to memory ?
a) The ABAP memory is completely overwritten
b) SAP Memory is overwritten
c) ABAP memory sets up a new default area

86. Mark the valid values for a checkbox . More than one answer is correct.
a) Any Alpha Character
b) Space
c) 0
d) 1
e) X

87. When does the processing block for a Get statement end?
a) When the next keyword event is encountered
b) When all data has been retrieved for the Get
c) After each PUT in the LDB
d) When the END GET statement is encountered

88. What technique would you use to fix the 10 leftmost columns on a list when scrolling to the right?
a) Set Left Scroll-Boundary Column 10
b) Set Right Scroll-Boundary Column 10
c) Scroll List PS+<10>
d) Scroll List Left

89. When does the system reset the formatting on a Write statement?
a) When explicitly changed using the Format statement
b) At any New Event
c) Using the Reset option of the Format statement
d) All of the above

90. Which type is not a valid GUI Status type?
a) Online(Dialog) Status
b) List Status
c) Dialog Box
d) Context Menu

91. What does the following code achieve?
At Selection-Screen on value-request for sales.
Call screen 100.
a) When the user presses F4, Screen 100 is displayed in addition to the normal help screen
b) When the user presses F1, Screen 100 is displayed instead of the normal possible values search help
c) When the user presses F4, Screen 100 is displayed instead of the normal possible values search help
d) When the user presses F1, Screen 100 is displayed in addition to the normal help screen

92. Which of the following are valid logical database types? More than one answer is correct.
a) Table
b) Structure
c) File
d) Complex Data Object
e) Node

93. Program A issues the following statement SUBMIT PROGRAM B. What takes place?
a) Program B becomes active in the same internal session of Program A
b) Program A becomes active in the same internal session of Program B
c) Program B runs in a new internal session
d) User Context is flushed

94. What is the code required in order to scroll the 3rd detail list to page 5 ?
a) Scroll LIST 3 5
b) Scroll LIST Index 3 to Page 5
c) Scroll LIST sy-index 3 to Page 5
d) Scroll LIST sy-lsind 3 to Page 5

95. For called program components that are of type transaction or report, what is true about the roll area (assuming processing will resume in the calling program).
a) They run in their own roll area
b) They run in the roll area of the caller
c) Share the same roll area

96. Select the line that would execute in the following code after the EXIT statement
10 get spfli.
20 * Processing of SPFLI records
30 write: spfli-carrid, spfli-connid.
40 counter = counter + 1.
60 if counter > 1.
70 Exit.
80 endif.
90 write:/ 'No more processing for this Carrier'.
100 get sflight.
110 write: sflight-fldate, spfli-price.
120 end-of-selection.
130 write: / text-002, text-003.
a) 80
b) 100
c) 120
d) 130
e) Exits the Program

97. What is not a valid functional area type?
a) LDB
b) Sequential Data Set
c) Program
d) Search Help
e) Joined Tables

98. Which is not a valid option of the Write Statement?
a) NO-GAP
b) Input
c) Centered
d) Under
e) No-Zero
f) As RadioBox

99. What are the 3 main sub objects of a LDB? More than one answer is correct.
a) Structure
b) Selection Screen
c) Search Helps
d) Tables
e) DB Program

100. What is needed to ensure a check field is verified against the referenced key field of the check table?
a) same data element is required for check field and referenced field
b) same domain is required for check field and referenced field
c) same data type only is required for check field and referenced field
d) all key fields MUST have domain equality between check table andn foreign key table

101. What is true about the primary index of a table? More than one answer is correct.
a) The key fields of the table make up the primary index
b) The primary index ID is designated by the Database Adminstrator
c) The developer designates the fields to be used as the primary index
d) The primary index is automatically created when the table is activated

102. Which of the following gets stored as a Runtime Object?
a) Programs
b) Tables
c) Aggregate Objects
d) Fixed Values belonging to a domain

103. When is it better to buffer the table?
a) When a table is read infrequently
b) When a table is read frequently and the data seldom changes
c) When a table is read frequently and the data is always changing
d) When a table is linked to check tables

104. Identify the different type categories in the ABAP dictionary. More than one answer is correct.
a) Data Elements
b) Structures
c) Data definitions
d) Table Types
e) Data Models

105. What is true about views? More than one answer is correct.
a) A view is automatically created on the database upon activation
b) A view contains data
c) Maintenance Views are not updateable
d) Views can be buffered

106. Identify the case where table buffering should be set off.
a) When the most current data is required
b) When the most current data is not required
c) For Small Static non volatile tables
d) For Global Master Data

107. Table T1 wants to ensure that the key field t1-fielda entered is valid against a field t2-fielda in table T2. Which is the foreign key table?
a) T1
b) T2
c) T3 from the dictionary
d) Cannot be determined

108. Identify the one addition that is not part of the interface of a method
a) Importing
b) Result
c) Exception
d) Returning

109. What is the effect when a CLEAR statement is used on an internal table without header line?
a) The work area is intitialized
b) All the lines of the table are deleted
c) All the lines of the table are initialized
d) Nothing

110. What is the default mode for passing actual parameters in a Perform?
a) By Value
b) By Reference
c) By Changing

111. In the case of a function, Identify the item that is not a valid interface element.
a) Import parameters
b) Export parameters
c) Tables
d) Source Code
e) Exceptions

112. How would you clear the body of an internal table (with a header line). More than one answer is correct.
a) Clear ITAB[]
b) Refresh ITAB []
c) Clear ITAB
d) Refresh ITAB

113. When catching errors using the CATCH:ENDCATCH statement, where does the runtime error return code get placed?
a) sy-subrc
b) sy-fdpos
c) error class
d) system-exceptions

114. What is the value of ZFIELDB after the last line of the following code is executed?
Data: ZFIELDA(5) type c value 'ABCDE'.
ZFIELDB(4) type c.
ZFIELDA = 'XX'.
Clear ZFIELDA.
ZFIELDB = ZFIELDA.
a) ABCDE
b) Spaces
c) ABCD
d) BCDE

115. Mark the valid use of the data statement. Assume that ZBOOK-ID is a dictionary object.
a) Data fielda value zbook-id
b) Data fielda type c like zbook-id
c) Data fielda(5) like zbook-id
d) Data fielda like zbook-id

116. Assuming you have created a data object of type c with the name ZFIELDA in your program. Which of the following is allowed?
a) Data: ZFIELDA type n
b) Types: ZFIELDA type I
c) Data: ZFIELDA type c
d) Constants: ZFIELDA type n

117. What do search statements REPLACE, SHIFT, CONCATENATE, SPLIT have in common? More than one answer is correct.
a) They all set sy-subrc
b) They all set sy-fdpos
c) They all distinguish between upper and lower case
d) They all treat the operands as type C regardless of their actual type
e) The actual type of each operand determines how the string processing is performed

118. What are valid uses of a variant? More than one answer is correct.
a) Hiding input fields
b) Pre-assigning values
c) Input validation
d) Security checking

119. How can you perform a direct database read from a buffered table?
a) Do not have buffering in the technical attributes
b) Add the BYPASSING BUFFER clause on the select statement
c) Buffering can be turned off on the application server by the programmer using the ABAP Workbench

120. What is the Effect of not Typing Formal parameters in a Form?
a) Conversion always occurs
b) Conversion never occurs
c) Forms are more flexible but prone to a short dump if conversion does not work
d) No effect
e) Forms are less flexible and are guaranteed no chance of a run time error

121. What requirement exists if a field is defined in the dictionary of type CURR?
a) The field must be numeric
b) Decimals must be defined in the domain
c) The field must be linked to another field of type CUKY
d) No other requirement exists

122. Which of the following is not a valid ABAP data statement?
a) Data fielda(5) type c
b) Data fielda(5) type n
c) Data fielda(5) type t
d) Data fielda(5) type x

123. What is the result of the following date calculation? Assume current date is 20001220.
Data: Today(Cool type C.
Today = sy-datum.
Today = 10.
a) 10
b) 20001220
c) 10001220
d) 20011210

124. Mark the default size for a packed field
a) 1
b) 2
c) 4
d) 8
e) size must be specified

125. Refer to the following Code. What is the value of sy-fdpos and sy-subrc after the search is executed?
Data: mystring type c value 'ARAMCO'.
Search mystring for 'X'
a) sy-fdpos = 0 and sy-subrc = 0
b) sy-fdpos = 0 and sy-subrc = 4
c) sy-fdpos = 4 and sy-subrc = 0
d) sy-fdpos = 4 and sy-subrc = 4

126. What is true of passing by value and result in the following code? More than one answer is correct.
Perform calculate_sales using amount.
FORM calculate_sales changing value(f_amount)
a) Formal Parameter f_amount is allocated it's own memory space
b) The address of the actual parameter is passed to the formal parameter
c) Formal parameter is copied to memory space of actual parameter at the end of the form
d) Formal parameter is not copied to memory space of actual parameter

127. Define a Logical Database.
a) An ABAP/4 Reading Program used to read and process data
b) A method to update data
c) A Reporting Tool
d) Defintion of a Relational Data Model

128. What happens if message E046 is raised?
At Selection-Screen on sales.
If sales-low < 500.
Message E046.
Endif.
a) The initialization event is fired again
b) Field Sales is open for input and all other fields are not available for input
c) All fields are open for input and cursor is positioned on field sales
d) The program ends

129. What is a structured type in the ABAP dictionary that has no physical table defintion in the underlying database referred to as?
a) table
b) structured data type
c) structure
d) table type

Data Dictionary - questions and their answers

1. What are the layers of data descriptions in R/3?
The external layer
The ABAP/4 layer
The database layer

2. Define external layer.
The external layer is the plane at which the user sees and interacts With the data, that is, the data format in the user interface. This data Format is independent of the database system used.

3. Define ABAP/4 layer?
The ABAP/4 layer describes the data formats used by the ABAP/4 processor.

4. Define Database layer ?
The database layer describes the data formats used in the database.

5. What is a Data Class?
The Data class determines in which table space the table is stored when it is created in the database.

6. What is a Size Category?
The Size category describes the probable space requirement of the table in the database.

7. How Many types of size categories and data classes are there?
There are five size categories (0-4) and 11 data classes, only three of which are appropriate for application tables:
APPL0 - Master data (data frequently accessed but rarely updated)
APPL1 - Transaction data (data that is changed frequently)
APPL2 - Organizational data (customizing data that is entered when system is Configured and then rarely changed)
The other two types are:
USR
USR1 - Intended for customers own developments

8. What are control tables?
The values specified for the size category and data class are mapped to database-specific values via control tables.

9. What is the function of the transport system and workbench organizer?
The function of the transport system and the Workbench Organizer is to manage any changes made to objects of the ABAP/4 Development Workbench and to transport these changes between different SAP systems.

10. What is a table pool?
A table pool (or pool) is used to combine several logical tables in the
ABAP/4 Dictionary. The definition of a pool consists of at least two keys
Fields and a long argument field (VARDATA).

11. What are pooled tables?
These are logical tables which must be assigned to a table pool when they are defined. Pooled tables can be used to store control data (such as Screen sequences or program parameters).

12. What is a table cluster?
A table cluster combines several logical tables in the ABAP/4 Dictionary. Several logical rows from different cluster tables are brought together in a single physical record. The records from the cluster tables assigned to a cluster are thus stored in a single common table in the database.

13. How can we access the correction and transport system?
Each time you create a new object or change an existing object in the ABAP/4 Dictionary, you branch automatically to the Workbench Organizer or correction and transport system.

14. Which objects are independent transport objects?
Domains, Data elements, Tables, Technical settings for tables, Secondary indexes for transparent tables, Structures, Views, Match code objects, Match code IDs,Lock objects.

15. How is conversion of data types done between ABAP/4 & DB layer?
Conversion between ABAP/4 data types and the database layer is done within the database interface.

16. How is conversion of data types done between ABAP/4 & external level?
Conversion between the external layer and the ABAP/4 layer is done in the SAP dialog manager DYNP.

17. What are the Data types of the external layer?
ACCP, CHAR, CLNT, CUKY, CURR, DATS, DEC, FLTP, INT1, INT2, INT4, LANG, LCHR, LRAW, NUMC, PREC, QUAN, RAW, TIMS, UNIT, VARC.

18. What are the Data types of the ABAP/4 layer?
Possible ABAP/4 data types:
C: Character.
D: Date, format YYYYMMDD.
F: Floating-point number in DOUBLE PRECISION (8 bytes).
I: Integer.
N: Numerical character string of arbitrary length.
P: Amount or counter field (packed; implementation depends on hardware platform).
S: Time stamp YYYYMMDDHHMMSS.
T: Time of day HHMMSS.
V: Character string of variable length, length is given in the first two bytes.
X: Hexadecimal (binary) storage.

19. How can we set the tablespaces and extent sizes ?
You can specify the extent sizes and the tablespace (physical storage area in the database) in which a transparent table is to be stored by setting the size category and data class.

20. What is the function of the correction system?
The correction system manages changes to internal system components,
such as objects of the ABAP/4 Dictionary.

21. What are local objects?
Local objects (Dev class $TMP) are independent of correction and transport system.

22. What is a Development class?
Related objects from the ABAP/4 repository are assigned to the same development class.This enables you to correct and transport related objects as a unit.

23. What is a data dictionary ?
Data dictionary is a central source of data in a data management system. Its main function is to support the creation and management of data definitions. It has details about
What data is contained ?
What are the attributes of the data ?
What is the relationship existing between the various data elements ?

23. What functions does a data dictionary perform ?
In a data management system, the principal functions performed by the data dictionary are
- Management of data definitions
- Provision of information for evaluation
- Support for software development
- Support form documentation
- Ensuring that the data definitions are flexible and up-to-date.

24. What are the features of ABAP/4 Dictionary ?
The most important features are :
- Integrated to ABAP/4 Development Workbench
- Active in the runtime environment

25. What are the uses of the information in the Data dictionary ?
The following information is directly taken from the Data dictionary :
- Information on fields displayed with F1 help
- Possible entries for fields displayed with F4 help
- Matchcode and help views search utitlities.

26.What are the basic objects of the data dictionary ?
- Tables
- Domains
- Data elements
- Structures
- Foreign keys

27. What are the aggregate objects in the data dictionary?
- Views
- Matchcodes
- Lock objects

28.In the ABAP/4 Dictionary Tables can be defined independent of the underlying database (T/F)
True

29. ABAP/4 Dictionary contains the Logical _ (Logical/Physical) definition of the table.

30. A field containing currency amounts (data type CURR) must be assigned to a reference table and a reference field. Explain.
• As a reference table, a system table containing all the valid currencies is assigned or any other table which contains a field with the currency key format. This field is called as reference field. The assignment of the field containing currency amounts to the reference field is made at runtime. The value in the reference field determines the currency of the amount.

31. A field containing quantity amounts (data type QUAN) must be assigned to a reference table and a reference field. Explain.
• As a reference table, a system table containing all the valid quantity units is assigned or any other table which contains a field with the format for quantity units (data type UNIT). This field is called as reference field. The assignment of the field containing quantity amounts to the reference field is made at runtime. The value in the reference field determines the quantity unit of the amount.

32. What is the significance of Technical settings (specified while creating a table in the data dictionary) ?
By specifying technical settings we can control how database tables are created in the database. The technical settings allows us to
- optimize storage space requiremnets
- table access behaviour
- buffering required
- changes to entries logged

33.What is a Table attribute ?
The table attributes determine who is responsible for maintaining a table and which types of access are allowed for the table. The most important table attributes are:
a. Delivery class
b. Table maintenance allowed
c. Activation type.

34. What is the significance of Delivery Class ?
The delivery class controls the degree to which the SAP or the customer is responsible for table maintenance
• whether SAP provides the table with or without contents.
• determines the table type.
• determines how the table behaves when it is first installed, at upgrade, when it is transported, and when a client copy is performed.

35. What is the maximum number of structures that can be included in a table or structure
- Nine.

36. What are the two methods of modifying Sap standard tables ?
- Append Structures and
- Customizing Includes.

39. What is the difference between a Substructure and an Append Structure ?
In case of a substructure, the reference originates in the table itself, in the forma of a statement .include... .
In case of an append structure, the table itself remains unchanged and the refrence originates in the append structure.

40. To how many tables can an append structure be assigned ?
One.

41. If a table that is to be extended contains a long field, we cannot use append structures. Why?
Long fields in a table must always be located in the end, as the last field of the table. If a table has an append structure the append line must also be on the last field of the table.

42.Can we include customizing include or an append structure with Pooled or Cluster tables ?
No.

43. What are the two ways for restricting the value range for a domain ?
• By specifying fixed values.
• By stipulating a value table.

44. Structures can contain data only during the run time of a program (T/F)
- True.

45. What are the aggregate objects in the Dictionary?
- Views
- Match Code
- Lock object

46.What are base tables of an aggregate object?
The tables making up an aggregate object (primary and secondary) are called aggregate object.

47.The data of a view is not physically stored, but derived from one or more tables. (T/F).
-True.

48. What are the 2 other types of Views, which are not allowed in Release 3.0?
- Structure Views
- Entity Views.

49. What is a Match Code?
Match Code is a tool to help us to search for data records in the system. Match codes are an efficient and user-friendly search aid where key of a record is unknown.

50. What are the two levels in defining a Match Code?
- Match Code object
- Match Code Id.

51. What is the maximum number of match code Id's that can be defined for one Match code object ?
A match code Id is a one character ID that can be a letter or a number.

52. Can we define our own Match Code ID's for SAP Matchcodes ?
Yes, the numbers 0 to 9 are reserved for us to create our own Match Code IDs for a SAP defined Matchcode object.

53. What is an Update type with reference to a Match code ID?
If the data in one of the base tables of a matchcode ID changes, the matchcode data has to be updated. The update type stipulates when the matchcode is to be updated and how it is to be done. The update type also specifies which method is to be used for Building matchcodes . You must specify the update type when you define a matchcode ID.

54. Can matchcode object contain IDs with different update types ?
- Yes.

55. What are the update types possible ?
The following update types are possible:
Update type A: The matchcode data is updated asynchronously to database changes.
Update type S: The matchcode data is updated synchronously to database changes.
Update type P: The matchcode data is updated by the application program.
Update type I: Access to the matchcode data is managed using a database view.
Update type K: Access to the matchcode is achieved by calling a function module.

56. What are the two different ways of building a match code object ?
A match code can be built in two different ways :
• Logical structure : The matchcode data is set up temporarily at the moment when the match code is accessed. (Update type I, K)
• Physical structure : The match code data is physically stored in a seperate table in the database. (Update type A, S, P)

57. What are the differences between a Database index and a match code ?
• Match Code can contain fields from severeal tables whereas an index can contain fields from only one table.
• Match code objects can be built on transparent tables and pooled and cluster tables.

58. What is the function of a Domain?
• A domian describes the technical settings of a table field.
• A domain defines a value range, which sets the permissible data values for the fields, which refers to this domain.
• A single domain can be used as basis for any number of fields that are identical in structure.

59. Can you delete a domain which is being used by data elements ?
- No.

60. What are conversion routines ?
Non standard conversions from display format to sap internal format and vice-versa are implemented with so called conversion routines.

61. What is the function of a data element ?
A data element describes the role played by a domain in a technical context. A data element contains semantic information.

62. Can a domain, assigned to a data element be changed ?
Yes. We can do so by just overwriting the entry in the field domain).

63. Can you delete data element which is being used by table fields .
No.

64. Can you define a field without a data element ?
Yes. If you want to specify no data element and therefore no domain for a field, you can enter data type and field length and a ashort text directly in the table maintenance.

65. What are null values ?
If the value of a field in a table is undefined or unknown, it is called a null value.

66. What is the difference between a structure and a table ?
Structures are constructed the almost the same way as tables, the only difference using that no database table is generated from them.

67. What is a View ?
A view is a logical view on one or more tables. A view on one or more tables i.e, the data from a view is not actually physically stored instead being derived from one or more tables.

68. How many types of Views are there ?
- Database View
- Help View
- Projection View
- Maintenance View

69. What is Locking ?
When two users simultaneously attempt to access the same data record, this is synchronised by a lock mechanism.

70. What is database utility ?
Database utility is the interface betweenn the ABAP/4 Dictionary and the underlying the SAP system.

71. What are the basic fucntions of Database utility ?
The basic functions of database utility are :
- Create database objects
- Delete database objects
- Adjust database objects to changed ABAP/4 dictionary definition.

72. What is Repository Info. Systems ?
It is a tool with which you can make data stored in the ABAP/4 Dictionary available.


Last edited by admin on Thu Sep 10, 2009 12:09 pm; edited 2 times in total
Back to top
View user's profile Send private message
admin
Администратор
Администратор



Joined: 01 Sep 2007
Posts: 1636

PostPosted: Fri Feb 27, 2009 2:48 pm    Post subject: Reply with quote

1. Which statements are allowed if you are working with an internal table of the type SORTED? (T/F)
F- SORT
F- APPEND
F- MODIFY
T- COLLECT
T- READ

2. Which of the following ABAP statements create a list for executable programs?
(T/F)
T- SKIP
T- WRITE
F- PERFORM
F- CLEAR
T- ULINE

3. Which of the following statements are correct? (T/F)
- You can select from several database tables using a database view or a join. T
- A secondary index for non-key fields generally works like a primary index for
key fields. T
- A key field in a database table uniquely identifies a data record. T
- The client field is a selective field and should therefore always be specified in
the
WHERE condition for SELECT. F
- The OPEN SQL statements are converted into database-specific statements by
the database interface. T

4. What do you get when you refer to a client-specific transparent table in the
Dictionary if you have a data definition with TABLES? (Single selection)
- A structured work area (line). T
- A field. F
- An internal table. F

5. In program P, the SUBMIT statement is used to call report R. How can you pass
data from P to R? (T/F)
- Using the SET/GET parameters. T
- By passing parameters using additions in the SUBMIT statement. T
- Using the ABAP memory. T
- By declaring the data objects with the same name in both programs, using the
DATA statement. F
6. Which of the following statements about the SELECT statement are correct?
(T/F)
- With SELECT SINGLE access, the result is one data record maximum. T
- The SELECT statement supports the return code (SY-SUBRC). T
- With SELECT...ENDSELECT access. the result is one data record maximum. F
- The SELECT statement always reads the data into the SAP memory first. F
- With SELECT...INTO TABLE access, the result is one data record maximum. F

7. Which of the following statements about data types, data objects, and field symbols are correct? (T/F)
- If you change the value of a field symbol, the value of the data object to which the field symbol is assigned also changed. T
- A field symbol always reference a data element. F
- You can no longer create data objects at runtime(dynamically) since the ABAP runtime system combines all the declarative statements in on processing block and executes these first. F
- A field symbols only references a data object after the latter has been assigned to the field symbols using the ASSIGN statement. T
- You can change the type of the assigned data object using the CASTING-TYPE addition for the ASSIGN statement. T

8. Which of the following statements about internal tables is correct? (T/F)
- Key access to an internal table of the type STANDARD generally has even less
runtime consumption than index access. F
- Index access to an internal table of type SORTED will, in certain cases, violate
the sort sequence. F
- Access to nested internal tables using field symbols usually increase
performance. T
- Index access to an internal table of the type HASHED has less runtime
consumption. F
- You can perform a binary search on internal tables of the type SORTED using
the addition BINARY SEARCH only. F

9. You want a subroutine U to have a formal parameter P that is used to return a
value. Which of the following definitions of U would you use to ensure that the
value is passed back to the calling program only if the processing of U ends
normally and is not terminated with a MESSAGE statement? (Single selection)

- FORM U CHANGING VALUE(P). T
- FORM U CHANGING P. F
- FROM U USING P.
LOCAL P. F
- FROM U USING p. F
- FORM U USING VALUE(P). F

10. Which statement at the time of AT SELECTION-SCREEN causes the selection screen to be displayed again with fields ready for input and a message in the status line? (Single selection)
- A MESSAGE E...statement T
- An AUTHORITY-CHECK statement that return code SY-SUBRC NE 0. F
- A MESSAGE I...statement. F

11. What do you get when you refer to a client-specific transparent table in the Dictionary if you have a data definition with TABLES? (Single selection)
- A structured work area (line). T
- A field. F
- An internal table. F

12. Which of the following events generate lists? (T/F)
- PROCESS BEFORE OUTPUT F
- START-OF-SELECTION. F
- AT SELECTION-SCREEN. F
- INITIALIZATION. F
- AT LINE-SELECTION. T

13. Which component of an application sever controls the data traffic between a work process and a presentation server? (Single selection)
- Dispatcher. T
- SAPGUI. F
- Front-end processor. F
- Message Handler. F
- Screen processor. F

14. For which tasks is the database interface responsible? (T/F)
- Syntax check of "native" SQL commands. F
- Conversion of Open SQL statement from ABAP statements into the corresponding database statements. T
- Data consistency check with respect to foreign key relationships. F
- Database independence of application programs. T
- Usage of the SAP buffers. T

15. Which SAP GUI types are there? (T/F)
- SAP GUI for Windows T
- SAP GUI for HTML. T
- SAP GUI for Web AS. F
- SAP GUI for ITS. F
- SAP GUI for Java. T

16. Where can you have automatic input checks against the check table? (Single selection)
- For input fields on screens if the input fields have been copied from the
Dication into the Screen Painter. T
- For input fields on ABAP lists. F
- For input fields on selection screens. F

17. Is it possible to increase the number of key fields in transparent tables that are already active? (Single selection)
- No, Key changes are not allowed. T
- Yes, irrespective of whether the table already contains data or not. F
- Yes, However, the table must not contain any data yet. F

18. Which of the following statements about APPEND structures are true? (T/F)
- After adding an APPEND structure to a table, you must convert the table. F
- You can use an APPEND structure like any other structure in ABAP programs. ?
F
- An APPEND structure allow you to append field to an SAP table without having
to modify the table itself. T
- An APPEND structure is the same as substructure. F

19. Changes to active transparent tables: The type for the non-key field is to be
changed from NUMC to CHAR. What follow-up actions are to be expected? (T/F)

20. Which of the following statements apply to a database view? (T/F)
- A database view supplies the results quantity of an outer join logic. F
- Using a database view, you can read data from several tables. T
- Using a database view, you can insert data into several tables. F
- A database view is a special view of transparent tables. F
- A database view can have one or several base tables. T

21. The search help function know various link options in the ABAP dictionary. Which of the following statements apply? (T/F)
- A search help function that is linked to the table field can return values only for
the search field (field where the f4 help was triggered). F
- A search help function that is linked to the data element can return values only
for the search field (field where the f4 help was triggered). F
- If the search help function is linked to the data element as well as to the field.
The search help for the field is displayed. T
- If the search help function is linked to a table A. this search help is displayed
whenever there are input field from A on the screen. f
- If the search help function is linked to a table A. this search help displayed
whenever there are input fields on that screen that have A as the check table. T

22. Which statements about parameters for an elementary search help apply? (T/F)
- Parameters can be displayed on the result list. T
- Parameters must be fields from the selection method only. F
- Import parameters control which data can be included in the data selection. T
- Export parameters control which data can be returned to the input template. T
- A parameter is either an import or an export parameter F

23. Which of the following statements about indexes are correct? (T/F)
- The primary index consists of the key fields of the database table. T
- An Index can be assigned to several database tables. F
- A database table can have more than one index. T
- Using an index speeds up data selection from a table. T

24. For what purpose are foreign key (FK) defined in the ABAP Dictionary? (Single selection)
- For the purpose of data consistency: when you active the table the FKs are
created in the database. You thus prevent invalid data from getting into the table.
F
- For the propose data consistency: when you maintain data records using dialog
transaction (screens). T
- The input values are automatically check in accordance with the FKs. T
- FKs are used solely for documenting table relationships. F

25. In which of the following table types is there a one-to-one relationship between the table defined in the ABAP Dictionary and relevant physical table in the database?
- Cluster table F
- Pooled table F
- Structure F
- Transparent database table. T

26. What is allowed within class definitions? (T/F)
- Typing with LIKE to ABAP Dictionary types. F
- The definition of internal tables with header lines. F
- The TABLES statement. F
- The definition of internal tables without header lines. T
- Typing with TYPE to ABAP Dictionary types. T

27. Which techniques are basic requirements for polymorphism? (T/F)
- Narrowing Case. T
- Redefinition of methods (for polymorphsim through inheritance). T
- Widening Cast. F
- Implementation of methods of an interface in the respective classes
(for polymorphism through interfaces). T

28. Which of the following statements about interfaces are correct? (T/F)
- Interfaces actually stand for an interface (protocol) between a client (interface
user) and a server (implementing class). T
- Interfaces are used to call static components of a class. F
- Using interface references you can reference all the public components of an
object that have been defined in the corresponding interface-implementing class.
F
- A client (caller) can use interface reference to access all methods of the
interfaces and thus archive polymorphism behavior. T
- Using interfaces you can simulate multiple inheritance.T

29. Using the statement CREATE OBJECT you can instantiate objects of a class. What situations can arise here? (T/F)
- All objects of the same class contain the same number of attributes and
methods after being created. T
- You can preset different objects of a class with different values immediately
when they are being created. T
- The contents of the attributes of different objects in a class always contain the
same content or value immediately after being created. F
- You define the type and number of attributes of an object through the
corresponding class. T

30. Ref_cl is a reference to the class cl_document. ref_if is a reference to the interface if_display. The interface if_display is implemented by the class cl_document. What option do you have to create an object of the class cl_docment? (T/F)
- CREATE OBJECT ref_cl. T
- CREATE OBJECT ref_if TYPE cl_document. T
- CREATE OBJECT ref_if. F
- DATA class_name TYPE string.
class_name = "CL_DOCUMENT".
CREATE OBJECT ref_if TYPE (class_name). T

31. In the case of classes, we distinguish between two types of components (attributes and methods):
Instance components and static components. Which of the following statements
apply in this context? (T/F)
- In a static method, instance attributes can also be used, provided they are
declared as READ ONLY. F
- Instance methods can use both static as well as instance components in their
implementation part. T
- Both static as well as instance attributes are declared using the DATA
statement.F
- Static methods can be called through the class:
<class_name>=><method_name>. T
- Static attributes exist only once for each class. T

32. Which of the following statements about functional methods are correct?(T/F)
- Functional methods cannot have any EXPORTING or CHANGING parameters. T
- Functional methods have exactly one RETURNING parameter. T
- You can functional methods directly in a WRITE statement. F
- You can use functional methods directly in an arithmetic expression. T

33. Which of the following statements apply to the SAP grid control? (T/F)
- Can only be implemented in module pools. F
- Can only display single-line lists. T
- Cannot print data. F
- Provides standard functions such as sorting. T
- Can only display structures from the Dictionary. F

34. Which access authorizations apply to friend relationships? (T/F)
- A friend of a class access to the public attributes of the class allowing the
friendship. T
- A subclass of a friend class has automatic access to the private attributes of
the class allowing the friendship. F
- A friend of a class has access to the private attributes of the class allowing the
friendship. T
- The allowing of a friendship is not inherited. T

35. Which statements in connection with methods are correct? (T/F)
- You can call methods in ABAP objects in the same way as function modules. F
- You can call methods only within ABAP Objects classes. F
- Like form routines or function modules, methods are a means to modularize
software. T
- Similar to the case with function modules, you have the option with methods of
marking parameters as "optional". T

36.
SE24 If you have a "Singleton Pattern", you must ensure that only one object can be created from a cl_singleton class. What mechanisms must you avail of here?

- The singleton class must have a class method implemented in which the
CREATE OBJECT call is programmed for this one object. T
- The singleton class must have the addition CREATE PRIVATE in the definition
part. T
- In the singleton class, there must be an even defined that is triggered when the
first and only object is created
and also prevents further objects of this class from being created. T
- The singleton class must have an instance method implemented in which the
CREATE OBJECT call is programmed for this one object. T
- The CREATE OBJECT call for this one object can take place in the class
constructor of the singleton class. T

37. The reference ME is defined by the system and has the following function.(Single selection)
- You use the reference ME within a class solely to reference the private methods
of the class itself. F
- You use the reference ME within a class to call attributes and methods of the
class itself. T
- You use the reference ME within a class solely to reference the private
attributes of the class itself. F

38. In a OO transaction, a transaction code is assigned to a method of a global class CL_A. Afterwards, this method can be called directly using the transaction code. What limitation exists with regard to the (instance) constructor of this class CL_A?
- The constructor must not have any importing parameters.T
- There is no limitation. F
- The constructor must be defined in the protected section.F

39. Which of the following statements about inheritance are correct? (T/F)
- Through inheritance, the public attributes of the super class are inherited to the
subclass. T
- Through inheritance, the private attributes of the super class are inherited to
the subclass
and they can be addressed in the subclass directly using "ME->". F
- Through inheritance, the protected attributes of the super class are inherited to
the subclass. T
- Through inheritance, the private attributes of the super class are inherited to
the subclass
and they can be addressed in the subclass directly using "THIS->". F

40. Typing is not always necessary in ABAP, for example, for interface parameters of a subroutine. Which of the following statements applies to ABAP objects? (Single selection)
- Typing is imperative for interface parameters of a method belonging to an ABAP
objects class. T
- To simplify writing the software and design it clearly, you can do without typing
altogether within the ABAP object classes. F
- If you have numeric interface parameter in an ABAP Objects class. You can do
without typing. F

41. What is a (instance) constructor? (Single selection)
- An instance attribute that is automatically given a unique identification by the
system when an object is created. F
- An instance method for initializing the attributes of an object; it is automatically
called by the system during CREATE OBJECT. T
- An instance method for controlling how much main memory is to be reserved
for an object. F

42. Which statements apply to dialog program? (Single selection)
- If you are using asynchronous update, the database changes are executed
directly from the program F
- If you are using asynchronous update, the statement COMMIT WORK is not
required because it is executed implicitly after each screen change. T
- In the PAI of each screen, you must use the statement COMMIT WORK. F
- If an inline change has resulted in an error, the statement ROLLBACK WORK
must be listed in the last screen in order to rollback the entire SAP LUW. F
- All inline change must be done in the PAI of the last screen in order to ensure
the rollback ability of the SAP LUW. F

43. What can you do to undo database changes executed beforehand in a dialog? (T/F)
- Output a termination message.(ABORT, X) T
- Analyze the log record. F
- Output an error message. F
- Perform a ROLLBACK WORK. T
- Raise an exception. F

44. Which of the following steps should be carried out in a transaction that implements an updating technique? (T/F)
- Call the ABAP command COMMIT WORK. T
- Unlock the data record that is to be updated F
- Lock the data record that to be update. F
- Read the data record that is to be update. F
- Pass the changes entered by the user to the update process. F

45. You call an update function using CALL FUNCTION ... IN UPDATE TASK. At what time are the values of the function parameters determined? (Single selection)
- At the end of the dialog step. F
- at the start of the V1 update. F
- At the time of the call F
- At the start of function execution. F
- At COMMIT WORK. T

46. You are writing a transaction to update a database table. Which of the following elements must the program contain? (T/F)
- A logical database. F
- A table buffer refresh on the application server. F
- A call for ENQUEUE/DEQUEUE fuction modules. T
- An AUTHORITY-CHECK statement. T
- A call for an update function module in the case of time-consuming changes. T

47. What are the main reasons for using update techniques? (T/F)
- To log the database changes. F
- To achieve delayed implementation of database changes. F
- To collect database change requests from several dialog step in order to
process them or delete them together. T
- To create reusable modules for database changes. T
- To relieve the load on the dialog work processes. T

48. What happens if you have a CALL TRANSACTION statement? (T/F)
- The update process triggered by the called transaction can be executed
asynchronously or synchronously, as required. T
- The called transaction is processed in a separated database LUW. T
- Processing of the calling program will be continued at the end of the
transaction. T
- Another internal session is opened for the transaction. T

49.Which sub objects can an SAP enhancement contain? (T/F)
- Menu exits. T
- Screen exits. T
- Append Structures. T
- Function module exits. T
- User exits. F

50. You want to supply your users with a transaction variant. Using transaction variants you can : (T/F)
- ... have transaction run in the background. F
- ... change the flow logic of a screen. F
- ... reduce the complexity of transactions. T
- ... suppress individual fields. T
- ... suppress entire(a) screens. T

51. Which of the following statements apply to table appends? (T/F)
- There can be several append structures for one table. T
- If you copy a table to which an append structure has been added, the fields in
the append structure become standard fields in the table. T
- When you active the table, all the active append structure of the table are
established and appended to the table in the database. T
- An append structure can be assigned to several tables. F


52. You wish to use a Business Transaction Event (BTE) to enhance an SAP application. Which statement applies? (T/F)
- BTEs are called on a cross-client basis. F
- BTEs allow you to call additional components in other systems. F
- BTEs allow you to link up addtional components to the SAP standard system. T
- BTEs interface can be used repeatedly. T

53. You wish to modify an SAP program. What do you need to watch out for? (T/F)
- If a user has modified an SAP object and SAP delivers a new version of the
object
in a release upgrade of Support Package, the modified object must be adjusted
during the upgrade. T
- You can perform the modification immediately if you set the global setting for
system modifiability to "Modifiable". RZ11(CONFIGURATION) T
- There R/3 System oes not allow modifications by user DDIC or SAP*. F
- You can change application programs delivered by SAP without registration
using the Modification Assistant. F
- Before you can change the program, you must request a key for the object in
the SAP New Web front-end. T

54. You wish to adapt the SAP standard software to the needs of the customer. Which of the following methods should you preferably use? (T/F)
- Customizing. T
- Modification of SAP objects. F
- Enhancement concept. T
- Customer's own developments. F

55. Assuming a customer has modified SAP objects in the customer system, which activities are required at release upgrade or when applying a Support Package? (T/F)
- No manual operations are necessary. Everything is performed automatically. F
- ABAP Dictionary objects are not handled separately. T
- The modified objects must be adjusted to match the standard version whenever
SAP delivers new versions of the objects. T
- After each upgrade, the new SAP objects is available as an active version. T
- Only ABAP Dictionary tables, data elements, and domain are adjusted during
the upgrade. F

56. You wish to use a Business Add-In (BAdI) in order to enhance an SAP application. Which of the following statements are correct?
- A BAdi always has exactly one interface in which the methods of the
enhancement are defined. T
- More than one implementation can exist event for BAdis that are not used on
multiple basis. F
- BAdis can contaion menu enhancements. T
- If a defualt implementation exists for a BAdi. this will always be run. F
- If you have filter-dependent BAdis, there can always be only one active
implementation for a filter value. F

57. How do you output icons on an ABAP list? (Single selection)
- You must enter the include <icon> in the program and also specify the addition
AS ICON in the WRITE statement. T
- You must enter include <system> in the program. F
- You must specify the addition FORMAT AS ICON is the WRITE statement. F

58. How do you ensure there will be the correct number of decimal places for currency amounts on an ABAP list output? (Single selection)
- By maintaining the corresponding customizing table and by using the addition
CURRENCY in the WRITE statement. T
- This take place automatically, provided the checkbox 'CURRENCY output' is
ticked in the program attributes. F
- By saving the currency amounts with decimal place in the database. F

59. You want to output the string "Name:" in line 20, column 10 on the first page of a list, and the string "Address" immediately below it, the page should otherwise remain blank (no header). Which of the following reports can you use to achieve this? (T/F)
- REPORT TEST NO STANDARD PAGE HEADING.
skip to line 20.
position 10.
write:/ 'Name:', /'Address'. F
- REPORT TEST NO STANDARD PAGE HEADING.
skip to line 20.
position 10.
write:/ 'Name:', /'Address:' under "Name'. F
- REPORT TEST NO STANDARD PAGE HEADING.
skip to line 20.
position 10.
write: / 'Name:'. write /'Address:'.'. F
- REPORT TEST NO STANDARD PAGE HEADING.
skip to line 20.
position 10.
write:/ "Name:", /10 "Address:". T
- REPORT TEST.
skip to line 20.
position 10.
write:/ "Name:", "Address" under "Name". F
- REPORT TEST.
skip to line 20.
position 10.
write:/ 'Name:', 'Address' under 'Name'. T

60. A logical database has four nodes altogether. First you have the root node node_00. Underneath the root node you have node_01 and then node_02 arranged in such a way so that they belong to the same hierarchy level. In addition, node_02 has a hierarchically dependent node, node_21. You have the following statements in programs: NODES. (Single selection)
- NODE_00, Node_02 Node_21. F
- NODE_00, Node_02, Node_21. T
- NODE_00, Node_02. T
- NODE_00, NODE_01, Node_02. F
1. What is the fastest way to move one internal table to another internal table (assuming two tables of similar structure)?

a) append lines of table1 to table2.
b) loop at table1.
Move: table1-field1 to table2-field1,
table1-field2 to table2-field2.
Append table2.
Endloop.
c) table2[] = table1[].
d) loop at table1.
Move-corresponding table1 to table2.
Endloop.
e) move table1 to table2.

2. Which one of the following is true about a function module?

a) Function modules are locally accessible objects.
b) Function modules have inbound and outbound parameters.
c) Function modules have no built-in exception handling.
d) Function modules CANNOT be created by a programmer.
e) Function modules use a shared memory area.


3.
data: field1 type I value 10.
a) field1 = 10
field1 = 8
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?
b) field1 = 8
field1 = 14
field1 = 5
c) field1 = 5
field1 = 3
field1 = 8
d) field1 = 5
field1 = 10
field1 = 8
e) field1 = 8
field1 = 14

4. Which one of the following commands is used in drill-down reporting?

a) AT LINE-SELECTION
b) MODULE SET_SCREEN
c) LEAVE SCREEN
d) END-OF-PAGE
e) ON VALUE-REQUEST

5. What is an object which CANNOT be transported?

a) A local object
b) A change request
c) A development object
d) A class
e) A task

6. A GUI-Status is created in which transaction?

a) Flow Logic
b) Menu Painter
c) GUI Painter
d) Screen Painter
e) Status Painter

7. Which one of the following statements creates a GUI-status in a dialog program?a) set pf-status '0100?.

b) set screen '0100?.
c) set gui-status '0100?.
d) set gui-status = '0100?.
e) set status '0100?.

8. Dialog programs have which naming convention?

a) ZPBOxxx
b) SAPMZxxx
c) ZDIAxxx
d) ZPAIxxx
e) Zxxx

9. Which dictionary structure contains system fields?

a) SYSTEM
b) SYTAB
c) SYST
d) SY
e) SYS

10.
a) 1
An internal table ICODE contains the following entries:
field1 field2
-----
John 12345
Alice 23478
Sam 54321
Bob 10000
IF NOT ICODE[] IS INITIAL.
SORT ICODE BY FIELD1 DESCENDING.
READ TABLE ICODE WITH KEY FIELD1 = 'Sam'.
WRITE: / SY-TABIX.
ENDIF.
What is the output of the above code after execution?
b) 2
c) 3
d) 4
e) Sam

11.
a) 4
Data: number type i.
while number < 10.
Add 1 to number.
If number < 8.
Continue.
Else.
Add 4 to number.
Endif.
Endwhile.
Write number.
What does NUMBER equal after executing the above code?
b) 8
c) 10
d) 12
e) 14

12. Which one of the following statements would occur in the PBO of a dialog program using table control?

a) loop at itab.
b) loop at itab with control itab_tc.
c) module exit at exit-command.
d) module user_command.
e) set screen '0100?

13.
data: begin of itab occurs 0,
field1(10),
field2(10),
end of itab.
a) A B
A B
B B
A
Move: 'A' to itab-field1,
'B' to itab-field2.
Append itab.
Append itab.
Move: 'B' to itab-field1.
Append itab.
Clear itab.
Move: 'A' to itab-field2.
Append itab.
What are the contents of itab after executing the above code?
b) A B
A B
B
A
c) A B
B
A
d) A B
B A
A
e) A B
B A
B A
B A

14. When debugging a BDC session, which command is used to exit the session?

a) /n
b) /bend
c) /nexit
d) /nquit
e) /exit

15. Which system field returns the number of records returned after a select?

a) sy-index
b) sy-recno
c) sy-lncnt
d) sy-dbcnt
e) sy-tabix

16. Which statement regarding Logical databases is FALSE?

a) Logical databases use a tree structure.
b) Logical databases use a standard selection-screen for selection criteria.
c) More than one logical database can be used in a report.
d) Any change to a logical database is reflected in all reports using that logical database.
e) Logical databases simplify and encapsulate data retrieval

17. Which one of the following is an example of an asynchronous update?

a) modify ztable from wa.
b) update ztable set field1 = '123?.
c) update ztable from ztable.
d) insert wa into ztable.
e) call function 'update_table' in update task

18. Which return code is associated with a failed authority check due to lack of user authorization for the chosen action?

a) 0
b) 4
c) 8
d) 12
e) 24

19. Which transaction is used to monitor, release, and reprocess BDC sessions?

a) SM36
b) SE37
c) SE35
d) SP35
e) SM35

20. What is the structure for the following select-options? Select-options: zname like ztable-name.
a) zname-sign
zname-value
zname-low
zname-high
b) zname-low
zname-high
zname-pattern
c) zname-sign
zname-option
zname-low
zname-high
d) zname-sign
zname-option
zname-low
e) zname-sign
zname-option
zname-low

21. Which of the following are elementary types in ABAP?

a) C,D,F,H,I,N,P,T
b) C,D,F,I,N,P,Q,T
c) A,D,F,I,N,P,T,X
d) A,D,F,H,N,P,T,X
e) C,D,F,I,N,P,T,X

22.
a) 1 1
3 3
4 4
4 4
data: f1 type I value 1,
f2 type I value 1.
Write: / f1, f2.
Do 2 times.
Perform scope.
Enddo.
Write: / f1, f2.
Form scope.
Data: f1 type I value 2,
f2 type I value 2.
Add: 1 to f1, 1 to f2.
Write: / f1, f2.
Endform.
What is the output of this program after execution?

b) 1 1
2 2
3 3
1 1
c) 1 1
3 3
3 3
3 3
d) 1 1
2 2
3 3
3 3
e) 1 1
3 3
3 3
1 1

23. Program specs call for screen 100 to appear in a modal dialog box.
a) The addition 'starting at X' is left out.
PAI
----
module do_something.
If field1 = 'X'.
Call screen '0100?.
Endif.
Endmodule.
Why does the above code fail to produce a modal box?
b) The screen should be numbered 900.
c) The code must occur in the PBO.
d) The screen is of the wrong type.
e) Screens are not called within modules.

24. Field-symbols are defined in which of the following ways?

a) field-symbols f1 for f1.
b) field-symbols [f1].
c) field-symbols like f1.
d) field-symbols (f1) like f1.
e) field-symbols {f1}.

25.
a) Line 2
1 TABLES: MARC.
2 DATA: BEGIN OF ITAB OCCURS 0,
3 FIELD1(5),
4 FIELD2(5),
5 END OF ITAB.
6 READ ITAB WITH KEY MATNR = '12345?.
7 IF SY-SUBRC = 0.
8 WRITE:/ ITAB-MATNR.
9 ENDIF.
Referring to the above code, which line contains an error?
b) Line 5
c) Line 6
d) Line 7
e) Line 8

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.
a) Icode-field2 must be a numeric field.
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?
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.
a) 26
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?
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.
a) f1: 'Test Variant'
f2: 'ariant'
f3: ' ariant'
data: f1(12) type c value 'Test Variant',
f2(6) type c,
f3(Cool type c.
Move: f1 to f2,
f2 to f3.
What do f1, f2, and f3 contain after executing the above code?
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.
a) Lines 1 and 4
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?
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.
a) 1 2 3 D
2 3 4
3 4 5 D
4 5 6 D
7 8 9 d
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?

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.
a) 3 3
1 1
4 4
1 1
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?
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:
a) Indexes are not allowed on Z tables
tnum, tcode.
Select * from ztest where tnum ne '123? and tcode = '456?.
Why is the index not used in the above case?
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 :
a) select field1 field2 into (itab-field1, itab-field2)
from ztable where field1 = '10?.
Append itab.
Endselect.
Field1
Field2
Which of the following is the fastest way to fill an internal table of the structure above.
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.
a) 1
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?
b) 2
c) 3
d) 6
e) 12

42.
Loop at zinfo.
At new name.
Sum.
Write: / zinfo-id, zinfo-name, zinfo-sales.
Endat.
Endloop.
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?
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

61. A logical database has four nodes altogether. First you have the root node node_00.
Underneath the root node you have node_01 and then node_02 arranged in such
a way so that they belong to the same hierarchy level.
In addition, node_02 has a hierarchically dependent node, node_21. You have
the following statements in programs: NODES. (Single selection)

- The event is executed each time all the dependent data records for a node_00
data record have been delivered into the program. F
- The event is executed each time after the event GET node_02. F
- The event is not executed. T
- The event is executed only if no data record is found for node_00. F

62. Dose a PAI occur when you switch between tab pages whose titles have function type P in a tabstrip? (Single selection)
- Yes, if at least one PAI module exists for the sub-screen container. F
- Yes, if at least one required entry field exits on of the tab pages. F
- No. T
- Yes, always. F

63. Which of the following statements about context menus on screens is correct? (Single selection)
- All the elements of a screen always have the same context menu. F
- You set context menus using the command set pf-status. F
- You set context menus within a subprogram ON_CTMENU_<FORM>. T
- The key combination Shift-F10 on a screen always calls a context menu. F

64. Which conditions must be fulfilled in a programmed check so that a screen input field is made ready for input again? (T/F)
- The check module must be called using:
FIELD field_name MODULE check_module. F
- The check module must be called using:
FIELD field_name MODULE check_module MESSAGE Ennn. F
- The moduel must output an E-type message or W-type message. F
- An I-type message must be output. T

65. You want to have the system branch to list processing from within a screen. Which of the following statements apply here? (Single selection)
- The list buffer must first be read (READ LIST). F
- You have to program the command LEAVE TO LIST-PROCESSING. T
- You have to program the two commands CALL SELECTION-SCREEN <screen
no> and LEAVE TO LIST-PROCESSING. F
- You must place the command LEAVE TO LIST-PROCESSING at the end of the
PAI of the respective screen. F

66. Which of the following statements about pushbuttons are correct? Pushbuttons...
- On a screen always have a corresponding function key. F
- In an application toolbar always have a corresponding function key. T
- With function code E cause program termination. F
- In an application toolbar always have a function code. T

67. What effect does the statement SUPPRESS DIALOG have in a PBO module of
a screen? (Single selection)
- The screen is displayed. But no inputs are possible. F
- Processing is continued with the calling screen. F
- The screen in question is not called. F
- Screen display is suppressed. T
- Neither the respective PBO module nor any of the subsequent PBO modules
are processed.F

68. Which of the following statements about radio buttons is correct? (Single selection)
- For each screen, the user can choose only one radio button. F
- Clicking a radio button always triggers a PAI. F
- Only the selected radio buttons have the value 1 for PBO in the field SCREENACTIVE.
F
- For each radio button group, the user can choose only one radio button. T

69. Which of the following statements about sub-screens are correct? (T/F)
- You call sub-screens using the screen command CALL SUBSCREEN.T
- You call sub-screens using the ABAP command CALL SUBSCREEN. F
(SCREEN COMMAND)
- The statement LEAVE TO SCREEN is not allowed in sub-screen flow logic. F
- Sub-screens have their own OK code field. F

70. You have defined a screen with required entries. You want the "CANCEL" function to work event if all the required entry fields are not filled. How can you do this? (Single selection)
- The "Cancel" function must have the function code "BACK". F
- There is no way to do this: required entry fields must always be filled first. F
- No special actions are required. F
- You must temporally switch off the required entry for the fields concerned
within the
LOOP AT SCREEN. .... ENDLOOP. F
- The 'Cancel' function must be type 'E' and be handled in a module with the
addition
AT EXIT-COMMAND. T

71. Which of the following statements about screens is correct? (Single selection)
- Only full-screens can have a subsequent screen. F
- You can define screens only in programs of type M. F
- On a screen, you can only output fields with Dictionary reference. F
- You assign each screen to exactly one program. T

72. Where can you set the status and the title for a modal dialog box (popup)? (Single selection)
- At the event TOP-OF-PAGE. F
- In a PBO module of the corresponding screen. T
- In a PAI module of the corresponding screen. F
- In the attributes of the corresponding screen. F

73. Which of the following statements about field transport between ABAP and screen are correct? (T/F)
- Name equivalence is imperative for field transport between ABAP and screen. T
- Field transport from ABAP to the screen generally takes place before the first
PBO module of the screen. F
- Field transport from the screen to ABAP is delayed if you have a FIELD
statement. T
- Dictionary structure on the screen requires a TABLES statement in ABAP. T

74. You have created a screen with 5 radio buttons. How do you ensure that only one radio button is selected at a time? (Single selection)
- Combine all the radio buttons into a group. T
- Create a common function code for all the radio buttons. F
- Assign all the radio buttons to the same modification group. F
- Enclose all entire radio button in a frame. F

75. Under which circumstances is module with the addition ON CHAIN-INPUT executed? (Single selection)
- When exactly one field within the CHAIN has a value other than its initial value.
F
- When a new entry has been made for at least one field within the CHAIN. F
- When a new entry has been made for all fields in the chain. F
- When the value of at least one field within CHAIN is other than its initial value. T

76. Which of the following statements in relation to Web Services are correct? (T/F)
- As of Release 6.20, ABAP Web Services can be developed on the SAP Web
Application Server.
- In the ABAP runtime environment, each function module and also each BAPI
can be switched on as a Web service.
- Web Services are based on open and generally accepted standards.
- In NetWeaver04, Web services can be developed both in the ABAP as well as
the Java runtime environment.

77. How does the Web Service Framework support the inclusion of Web services that have been provided? (T/F)
- Generation of a WSDL description.
- UDDI Brower for searching for suitable Web services.
- Generation of a client proxy on the basis of the WSDL description.
- Configuration of the SOAP runtime on the client side using logical ports.

78. Which components are created by the Web Service Creation Wizard when a Web service is defined? (T/F)
- Virtual Interface.
- Client proxy.
- XI Message Interface.
- Web service definition.
- Logical port.

79. What advantages do Shared Objects have compared with import/export To Shared memory / Buffer? (T/F)
- In Shared Objects areas, groups of object references can be stored.
- Data In shared objects areas is compressed.
- It is possible to access data in Shared Objects areas, without copying.
- In Shared objects areas, more data - in principle - can be stored than in the
shared memory / buffer

80. How is a Shared Objects area accessed in ABAP? (Single selection)
- With the help of a special database table.
- With the help of a special data type.
- With the help of a special class.

81. What does the transformation between XML and ABAP data structures involve? (Single selection)
- Generation of ABAP proxy types from XML schemas.
- Generation of XML schemas from ABAP types.
- Neither generation of XML schemas from ABAP types nor generation of ABAP
proxy types from XML schemas.

82. In which cases can the ABAP statement CALL TRANSFORMATION be used? (T/F)
- To transform as iXML document object into and ABAP data structure using
XSLT.
- To transform an XML document contained in a string into another XML
document
using and XSLT program.
- To get canonic XML display of an ABAP data structure.
- To transform an XML document contained in an xstring into another XLM
document using an ST program (Simple Transformation).
- To transform and ABAP data structure into an SML document using ST.
Back to top
View user's profile Send private message
admin
Администратор
Администратор



Joined: 01 Sep 2007
Posts: 1636

PostPosted: Thu Sep 10, 2009 12:10 pm    Post subject: Reply with quote

1 What is Data Dictionary
Description of data and definitions.

2 Significance of Data Class
The Data Class defines the physical area of the database (TABLESPACE in Oracle) in which the table is logically stored. The most important data classes are APPL0 - Master Data ( Data which is frequently read but rarely updated ). APPL1 - Transaction data ( Data which is frequently updated ). APPL2 - Organizational and Customizing Data ( Data which is defined when the system is initialized and then rarely used). USER and USER1 - Customer Data Classes ( These are reserved for user developments and the tables assigned to these data classes are stored in tablesapces for user development). For ORACLE and INFORMIX only these data classes has an effect.

3 Significance of Size Category
The Size Category determines the probable space requirement for a table in the database. Each category is assigned a specific fixed storage area value in the database.When you create a table, initial space is saved for it in the database.If more space is required later as a result of data that has been entered, the storage space is increased in accordance with category selected.

4 Significance of Buffering
The Buffering status specifies whether or not a table may be buffered.

5 How to track table changes?
Using the Logging Flag checkbox on( Log Data Changes ) in Technical Settings of a Table, you can Log/keep track of the changes ( Deletes,Updates etc) made on the table.The changes are logged in table DBTABPRT. Logging only takes place if parameter rec/client in the system profile is set correctly. Setting the flag on its own does not cause the table changes to be logged.The existing logs can be displayed with Transaction Table history (SCU3).

6 To get statistics on ABAP/4 dictionary objects ( Tables/Fieldnames/Dataelements/Domains)
Report - RDDSTAT1

7 How to get Orcale version?
"REPORT ZORAVER.
DATA: V_REL(45).
CALL 'DB_GET_REL' ID 'DBRELEASE' FIELD V_REL.
WRITE V_REL."

8 How to get modifications in the ABAP Workbench Since the Date Specified
Report - RDDMODIF

9 How to determine all Modifications that Conflict with SAP Delivery
Report - RDDGETMO

10 How many types are views are there?
Database View, Project View, Maintenance View and Help View. Database views implement inner joins whereas Maintenance and Help views implement an outer join. Using Inner join you can retrieve records which are there in the entire table involved in the view i.e you can get the records of the primary table which also have the same records in the secondary tables of the view. Using Outer join you can select the records for which there are no entries in the secondary tables.

11 Tables Info
"DD02L & DD02T SAP tables & texts
DD03L & DD03T Table Fields & texts
DD04L & DD04T Data elements & texts
DD01L & DD01T Domains & texts
DD05S Foreign key fields
DD09L DD: Technical settings of tables
DD12L & DD12T R/3 S_SECINDEX: secondary indexes, header & texts
DD20L & DD20T Matchcode objects & texts
DD23L & DD23T Matchcode ID & texts
DD24S Fields of a matchcode ID
DD25L & DD25T Aggregate Header (Views, MC Objects, Lock Objects) & texts
DD26S Base tables and foreign key relationships for a view
DD30L & DD30T Search helps & texts
DDTYPET Type groups & texts"

12 To get information on repository
Transaction code - SE84. From this transaction we get all the information related to repository objects.

13 Table maintenance generator
Transaction code - SE55

14 How to get structure of tables
Function Module - DDIF_NAMETAB_GET or RFC_GET_STRUCTURE_DEFINITION

15 To get all tables used in programs
Table - GET_TABLES

16 Interface to Read a Table/View from the ABAP Dictionary Function Module - DDIF_TABL_GET/DDIF_VIEW_GET

17 Interface to Read a Runtime Object from the ABAP Dictionary Function Module - DDIF_NAMETAB_GET

18 Reading the view fields with data element and domain Function Module - DD_GET_DD27P
19

20 How to delete Database table/entries/
Goto SE14, Specify Tablename -> Press EDIT. You can delete database table by clicking on the DELETE DATABASE TABLE Pushbutton. And you can delete table entries by selecting the radiobutton DELETE DATA and then press ACTIVATE AND ADJUST DATABASE Pushbutton or use FM - SUBST_DELETE_TABLE_CONTENT by passing tablename as parameter

21 Select Statement usage
"Reading all the data of SINGLE Entry
Reading all the data of SEVERAL Entries
Reading the data of SPECIFIC columns"

22 How can I transport data from a Table
You use SE01 to create a transport request.Then when you've completed the transport attributes, you save and enter the editor. You insert an entry: R3TR TABU xxxxxxxx where xxxxxxxx is the tablename. You must also GOTO --> Object Key and then insert the Keys you want.You may also enter * to select all table entries.Save and release your transaport

23 Adding records to a database table
Add a single record to a database table - insert into <database> values <work>. Inserting all lines from an internal table into a database table - insert <database> from table <internal> . You can add the option: accepting duplicate keys. If you add accepting duplicate keys you can test if the table was successfully updated, else a runtime error wil be generated. Note: accepting duplicate keys does not mean that duplicate keys will be accepted, only that it is possible to test on sy-subrc if you have tried to insert records with duplicate keys. All remaining records will be inserted.After you have inserted the recors the variable sy-dbcnt contains the number of records that were inserted.

24 Updating a Database table
"1. Updating records in the database table from an internal table
table: personel.
data: itab like personel.
* Read records from the database table where name is space, into an internal table
select * from personal into table itab
where name = space.
* Update name in the internal table to Unknown
loop at itab.
itab-name = 'Unknown'
endloop.
* Modify records in the database table. Only records with the same key values as then
* internal table is modified
modify personel from table itab.
2. Updating a single entry
In this example the entry with the key value ( Customerno ) 1 is changed.
table customer.
customer-customerno = 1.
customer-customnavme = 'John'.
update customer.
if sy-subrc <0> -1.
or
customer-customerno = '155151'.
delete cutsomer.

Delete all records
select * from zmellemtab.
delete zmellemtab.
endselect.

Deleting records using records from an internal table delete employees from table itab."

26 Reading Database tables into Internal Tables
"1. read the records one by one, moving selected records to the internal table
SELECT * FROM ZEMP.
MOVE ZEMP-ZEMPNO TO ITAB-ZEMPNO.
APPEND ITAB.
ENDSELECT.

2. Read all records
SELECT BUPER BLART ZZPOLNR SGTXT DMBTR
FROM ZTCOST
APPENDING CORRESPONDING FIELDS OF TABLE ITAB
WHERE HKONT = '11111111 ' AND BUDAT IN S_BUDAT.

3. Read all or selected records in one
select * from personal into table itab.
or
select * from personal into table itab
where name = 'Robert'.

4. Reading selected fields
SELECT perno name jdate
INTO CORRESPONDING FIELDS OF TABLE itab
FROM personal
WHERE name = 'Robert'."

27 Inner and Outer joins
"INNER JOIN
One or more lines on the right-hand table is linked to a line in the
left-hand table. Lines from the left-handed table
is only selected if they meet the ON criteria.

FROM from vbak as a inner join vbap as b
ON b~vbeln = a~vbeln.
One or more lines from vbap is selected for each line in vbak.
Limits on the ON clause.

LEFT OUTER JOIN
The left outer join read lines from the left-handed table EVEN if there is
no corresponding line in the right hand table.

FROM vbak as a left outer join vbap as b
ON b~vbeln = a~vbeln.
If vbap does not contain any lines that meets the condition, a single line
where the values from vbap is filled with null values.

Example 1

SELECT a~zafstemnr b~zafstemnr b~zsaknr

INTO CORRESPONDING FIELDS OF TABLE i_tab
FROM zcostafstm as a INNER JOIN zcostplan as b
ON b~zafstemnr = a~zafstemnr.

Example 2

SELECT lips~vbeln lips~lfimg likp~wadat
INTO corresponding fields of table ltab_orders
FROM lips JOIN likp on ( lips~vbeln = likp~vbeln )
JOIN vbfa on ( lips~vbeln = vbfa~vbelv )
WHERE lips~matnr = matnr
and lips~vbeln in vbeln
and likp~vbeln in vbeln
and vbfa~vbelv in vbeln
and lips~werks in werks
and likp~wadat in datum
and vbfa~vbtyp_n = 'Q' ""WMS transfer order
and vbfa~vbtyp_v = 'J'. ""Delivery "

28 Dynamic where clause
"You can use an internal table to build a dynamic where clause:

data: where_tab(30) occurs 1 with header line,
where_clause(30) type c.

* Build the where clause. Will look like this when finished
* WHERE ZAFSTMD02 = 'X' AND rbusa = '5145'

* With a constant, result: ZAFSTMD01 = 'X'
concatenate 'ZAFSTMD' zcostcheck-zmaaned ' = ''X''' into where_clause.

* Append to internal table where_tab
append where_clause to where_tab.

* With a variable, result: AND rbusa = '5145'
concatenate 'AND rbusa = ' '''' i_tab-zgsber ''''
append where_clause to where_tab.

* Select
select * from zcostfreq into table itab
where (where_tab).

Note that you can combine static and dynamic where clauses:

select * from zcostfreq into table itab
where bukrs = '2021' AND
(where_tab).

29 Dynamic Tablename
"data:
l_count type i.

parameters:
p_tab type tabname.

start-of-selection.
select count(*) from (p_tab) into l_count.
write: / 'Number of entries in table ', p_tab, l_count."

30 Dynamic Retrival and Writing of data
"In this example, data is retrieved from the table selected on the selection
screen, and the contents of the
table is written to the screen.

DATA:
* Create variable that can contain referecene to any data
dataref TYPE REF TO data.

FIELD-SYMBOLS:
<row> TYPE ANY,
<component> TYPE ANY.

PARAMETERS:
p_tab TYPE tabname.

START-OF-SELECTION.
* Create a workarea for the tabel selected on the selection screen

CREATE DATA dataref TYPE (p_tab).

* The variable dataref cannot be accessed directly, so a field symbol is
* used
ASSIGN dataref->* TO <row>.

SELECT *
FROM (p_tab) UP TO 10 ROWS
INTO <row>.

NEW-LINE.
DO.
* Write all the fields in the record
ASSIGN COMPONENT sy-index
OF STRUCTURE <row>
TO <component>.
IF sy-subrc <> 0.
EXIT.
ENDIF.
WRITE <component>.
ENDDO.
ENDSELECT."

31 Dynamic Select statement
"TYPES:
BEGIN OF st_bseg,
bukrs LIKE bseg-bukrs,
belnr LIKE bseg-belnr,
dmbtr LIKE bseg-dmbtr,
END OF st_bseg.

DATA:
sel_list TYPE STANDARD TABLE OF edpline,
li_bseg TYPE STANDARD TABLE OF st_bseg,
l_bseg TYPE st_bseg.


START-OF-SELECTION.
APPEND 'bukrs belnr dmbtr' TO sel_list.

SELECT (sel_list)
FROM bseg UP TO 100 ROWS
INTO TABLE li_bseg.

LOOP AT li_bseg INTO l_bseg.
WRITE : / l_bseg-bukrs, l_bseg-belnr, l_bseg-dmbtr.
ENDLOOP."

32 How to create Type Groups, Matchcodes, Pool/Cluster Tables Go to SE11 -> Utilities -> Other Dictionary Objects

33 How to find Inactive objects (From 4.5X Onwards) ? Transaction Code - WORKINGAREA

34 How to add new field to an existing table which contains data. "Use APPEND Structure, the benefit here is that when new ""custom"" fields are added to an SAP table
with append structures, the base SAP table is not changed. This means no conversion needs to occur during an upgrade.Append structures is an SAP R/3 concept. Logically, it looks like you have all the fields in one table. In reality, any fields that are part of the table in a the append structure (look in SE11 for append structure information for a table) are actually stored in a separate, R/3 maintained
table. When operations occur against a table with append structures, special ABAP/4 auto-generated routines are executed that use additional SQL to go after the custom fields stored elsewhere through append structures."
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    Russian ABAP Developer's Club Forum Index -> E-Courses | Электронные курсы All times are GMT + 4 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum


All product names are trademarks of their respective companies. SAPNET.RU websites are in no way affiliated with SAP AG.
SAP, SAP R/3, R/3 software, mySAP, ABAP, BAPI, xApps, SAP NetWeaver and any other are registered trademarks of SAP AG.
Every effort is made to ensure content integrity. Use information on this site at your own risk.