01.
Which of the following conditions must be fulfilled when using
a GROUP BY clause in a SELECT statement?
There are 2 correct answers to this question.
a) The SELECT statement must also have a WHERE clause.
b) All fields in the SELECT clause that are not part of an aggregate
function must be listed after GROUP BY.
c) The table in the FROM clause must be a transparent table.
d) The fields after GROUP BY must have a character type.
02. Which of the following data types are predefined ABAP data
types?
There are 3 correct answers to this question.
a) DECFLOAT34
b) STRING
c) XSTRING
d) FLOAT
e) DECIMALS
03. Which of the following repository objects can you maintain in
the ABAP Workbench?
There are 3 correct answers to this question.
a) Function modules
b) Internal tables
c) Business functions
d) Transparent tables
e) Module pools
04. You want to define data structures to hold two fields with
data elements s_carr_id and s_carrname. Which of the following
declarations can be used to define this data structure?
There are 2 correct answers to this question.
a) TYPES: BEGIN OF gty_flight,
b) DATA: BEGIN OF gs_flight,
c) DATA BEGIN OF gs_flight,
d) TYPES: BEGIN OF gs_flight,
05. What process is used to establish the automatic transport of
data between the view controller's context-attributes and the UI
element in its layout?
Please choose the correct answer.
a) Context mapping
b) Data migration
c) Data binding
d) View assembly
06. Which of the following is an invalid method for populating an
internal table?
Insert IB
Append
Read table IB
Select into table IB from dbb.
Collect
07 .What are valid methods for including text elements in your
program?
(More than one answer is correct)
Write: 'Hello'(001)
Write: TEXT-001
Write: 001(Hello)
Write: TEXT-001'Hello'
08.Which of the following short programs will not display the text
“SY-LSIND= 1” during interactive
reporting?
ZPGM3
ZPGM2
ZPGM1
09.When is Top-Of-Page event triggered?
When the Top-Of-Page event is encountered in sequence
After Number of lines per page, as specified in the REPORT, have
been written to the list buffer
When the report starts
When the first write statement is encountered
10.What is the effect of the collect statement if any entry with
the same key already exists?
Appends a new line
adds the numeric fields to an existing entry
Creates a new entry
11.Identify the item that are not considered Data Dictionary
technical settings when creating a
dictionary table
(More than one answer is correct)
Buffering
Data Class
Field Name
Size Category
Status
12.An ABAP program has a selection screen. The ABAP is to be
included as a step in the Background job. What other field must
be filled in when creating the job step?
Print Specifications
Variant
Language
Mandatory Fields
13.What is true about the end-of-page Event?
(More than one answer is correct)
Used to create Footers
Occurs when the page break has been triggered by the New-Page
statement
Automatically creates a footer on the last page of a list
Works only if you reserve space in the Report
Statement using the line-count statement
14.What is required to establish an interactive list?
(More than one answer is correct)
The user interface allows actions to trigger interactive list type
events
Corresponding interactive events are programmed
The Hide command is programmed into the report
15.The user default for the date format is set to YYYY.MM.DD.
Assume that today’s date is January
15, 1999 the displayed output of the date field in the following
code
01/15/1999
1999/01/15
19990115
1999.01.15
16.Identify the different type categories in the ABAP dictionary
(More than one answer is correct)
table Types
Data Models
Structures
Data definitions
Data Elements
17.Which is not a valid option of write statement?
Input
NO-GAP
No-Zero
As Radio Box
Centered
Under
18.In your ABAP program you want to display a dialog box that
asks the user to confirm a chosen action. Which function module
can you use to do this? Please choose the correct answer
Popup_To_Confirm
Dialog_To_Confirm
User_Confirm
There Is No Such Function Module.
19.What is the default screen that is generated for a selection
screen?
100
1000
1001
1100
20.Which of the following will trigger the AT LINE_SELECTION
event?
(More than one answer is correct)
Double Click a line on a list
Function Code P+
F2
Function Code PICK
Menu Option EDIT>Choose
Function Code CHOOSE
21.When does a table get physically created in the underlying
database?
When you activate a transparent table in the ABAP Workbench
When you create a transparent table
When Basis creates the tablespace at the OS layer
When you activate a transparent table in the Dictionary
22.How many statistics or ranked lists allowed per query?
10
Unlimited
9
1
23.When does system reset the formatting values on a write
statement?
When explicitly changed using the Format statement
All answers are correct
At any New Event
Using the Reset option of the Format statement
24.What determines if a table is a client specific versus client
independent?
The first field is mandt with a external data type
CLNT and specified as a key field
Depends how Basis has configured the client
The option 'Client Specified' is added to the Select stement The first
field is mandt with a domain CLNT but not specified as a key field
25.What will cause the AT USER-COMMAND to fire?
Type S Function Codes
Type T Functions Codes
Normal Function Codes
Function Codes that Start with P
26.During interactive reporting, at what point does sy-Isind get
incremented by the system?
When you programmatically increment it
At the end of an interactive processing block
At the beginning of an interactive processing block
27.What can be assigned directly to a data element?
(More than one answer is correct)
domain
built-in type
table type
check table
table field
28.After a READ LINE on a List, what happens to the HIDE data?
Nothing, the data remains in the hidden area
The hide data is restored to shared memory
The Hide data is not available to the program
It is transferred back to the fields defined in the program
29.Which report statement option determines the width of a list?
Line-Width
Line-Count
Report Size
Line-Size
30.What happens when an EXIT statement is executed in the AT
event?
The program ends.
The remainder of the current processing block is executed
The output list is displayed
The system leaves the processing block and branches to the
processing block of the next event.
31.Where does the system store the data after a Read Line has
been performed on a list?
In Memory
In an Internal table
SY-LISTI
SY-LISEL
32.Select the valid customer defined Message Stement:
MESSAGE Y123.
MESSAGE E123 (9999).
MESSAGE ID 'AT' TYPE 'S' NUMBER 100
MESSAGE E123 by Fielda Fieldb
33.What is true about the result set of an left outer join at the
database level?
(More than one answer is correct)
contains all entries from the left table
contains only entries that match in the on clause
fields from unmatched rows in the right table are null filled
fields from unmatched rows in the left table are null filled
contains all entries from the right table
34.What internal table Fields are generated using a select-
option?
(More than one answer is correct)
Low
Between
Option
High
Sign
Operator
35.How can records from the left table be omitted in an outer
join?
specify conditions in the WHERE clause
There is no way to omit records from the left table
specify conditions in the ON clause
specify conditions in the FROM clause
36.Identify the clause that is used in suppress standard headers?
No Standard Heading
No Standard Page Heading
Suppress Standard
System>List>Save
37.You design an executable program that displays flight
bookings. The selection screen of your program contains a
parameter pa_car of type S_CARRID for the carrier. To make sure
that users only see flight connections they are allowed to see,
you perform an authority check on the authorization object
S_CARRID. Where do you do this?Please choose the correct
answer.
In The Event Block At Selection-Screen.
In The Event Block Get Scarr.
In a PAI Module Of The Selection Screen.
In The Event Block At User-Command.
In a PBO Module Of The Selection Screen.
38.What is true about the primary index of table?
The primary index is automatically created when the table is
activated
The key fields of the table make up the primary index
The primary index ID is designated by the Dabase Administrator
The developer designates the fields to be used as the primary index
39.You want to create a selection screen for your ABAP
executable program. Which statements can you use to do this?
There is more than one correct answer to this question.
Parameters
Select-Options
Field-Symbols
Tables
Range Of
40.You write an ABAP executable program that displays the flight
connections between two cities. Your have provided selection
parameters for departure city and destination city. In your
program you have written event blocks for the event blocks AT
SELECTION-SCREEN, INITIALIZATION, START-OF-SELECTION, TOP-
OF-PAGE (in alphabetical order). In which sequence will ABAP
Runtime call these event blocks? Please choose the correct
answer.
At Selection-Screen, Initialization, Start-Of-Selection, Top-Of-Page
Initialization, At Selection-Screen, Start-Of-Selection, Top-Of-Page
Top-Of-Page, Initialization, At Selection-Screen, Start-Of-Selection
Start-Of-Selection, Initialization, At Selection-Screen, Top-Of-Page
41.READ CURRENT LINE makes use of what system variables ….
(More than one answer is correct)
SY-CUROW
SY-PAGNO
SY-CPAGE
SY-INDEX
42.When is it better to buffer the table?
When a table is linked to check tables
When a table is read infrequently
When a table is read frequently and the data seldom changes
When a table is read frequently and the data is always changing
43.You create a function group ZATP that contains a couple of
function modules to manage material master data. What is the
name of the corresponding program? Please choose the correct
answer.
ZATP
SAPMZATP
SAPFZATP
SAPLZATP
SAPTZATP
44.Where does information comes from when you press F1 on a
screen fileld?
Data element documention
Domain short text
Search help
Domain Help values
45.What requirement exists if a field is defined in the dictionary of
type CURR?
Decimals must be defined in the domain
The field must be numeric
The field must be linked to another field of type CUKY
No other requirement exists
46. 3. If a field, NAME1, is declared as a global data object, what will be
output by the
following code?
report zabaprg.
DATA: name1 like KNA1-NAME1 value 'ABAP programmer'.
name1 = 'Customer name'.
CLEAR name1.
perform write_name.
FORM write_name.
name1 = 'Material number'.
WRITE name1.
ENDFORM.
A: Customer name
B: ABAP programmer
C: Material number
D: None of the above
47.Identify the valid attributes of domain?
(More than one answer is correct)
Header
Label
Length
Fixed Values
Type
48. What are the two methods of modifying Sap standard tables ?
49. Where can we kind BAPI other than se37?
50. 8. A DO loop increments the system field ____.
A: SY-LOOPI
B: SY-TABIX
C: SY-LSIND
D: SY-INDEX
51. 17. What will be output by the following code?
DATA: BEGIN OF itab OCCURS 0, fval type i, END OF itab.
itab-fval = 1. APPEND itab.
itab-fval = 2. APPEND itab.
REFRESH itab.
WRITE: /1 itab-fval.
A: 1
B: 2
C: blank
D: 0
52. 19. When modifying an internal table within LOOP AT itab. _
ENDLOOP. you must
include an index number.
A: True
B: False
53. 20. If itab contains 20 rows, what will SY-TABIX equal when the
program reaches the
WRITE statement below?
SY-TABIX = 10.
LOOP AT itab.
count_field = count_field + 1.
ENDLOOP.
WRITE: /1 count_field.
A: 0
B: 10
C: 20
D: 30
54. 21. Adding a COMMIT WORK statement between
SELECT_ENDSELECT is a good
method for improving performance.
A: True
B: False
55.
In regard to MOVE-CORRESPONDING, which of the following is NOT a
true
statement?
A: Moves the values of components with identical names.
B: Fields without a match are unchanged.
C: Corresponds to one or more MOVE statements.
D: Moves the values of components according to their location
56. If a table contains many duplicate values for a field, minimize the
number of
records returned by using this SELECT statement addition.
A: MIN
B: ORDER BY
C: DISTINCT
D: DELETE
57. PERFORM subroutine USING var.
The var field is known as what type of parameter?
A: Formal
B: Actual
C: Static
D: Value
58. 50. To place a checkbox on a list, use
A: WRITE CHECKBOX.
B: FORMAT CHECKBOX ON.
C: WRITE fld AS CHECKBOX.
D: MODIFY LINE WITH CHECKBOX.
59. After a DESCRIBE TABLE statement SY-TFILL will contain
A: The number of rows in the internal table.
B: The current OCCURS value.
C: Zero, if the table contains one or more rows.
D: The length of the internal table row structure.
60. The output for the following code will be
report zabaprg.
DATA: my_field type I value 99.
my_field = my_field + 1.
clear my_field.
WRITE: 'The value is', my_field left-justified.
A: The value is 99
B: The value is 100
C: The value is 0
D: None of the above
