Questão 1
Questão
When should you use a hashed internal table?
There are 2 correct answers to this question.
Responda
-
When accessing mainly single records
-
When accessing by index
-
When accessing always by primary key
-
When accessing by secondary key
-
When accessing using the left-justified part of the key
Questão 2
Questão
What must you do to define a database view using the ABAP Dictionary?
There are 3 correct answers to this question.
Responda
-
Define the join conditions between the tables.
-
Define selection criteria for the view.
-
Choose the database tables from where the view acquires data.
-
Choose the fields from the tables that should be part of the view.
-
Define buffering settings for the underlying database tables.
Questão 3
Questão
Which options do you have to read data from multiple tables while using a SELECT statement?
There are 3 correct answers to this question.
Responda
-
Nested loop statements
-
Database views
-
Nested select statements
-
Pooled tables
-
Join statements
Questão 4
Questão
What is the predefined reference variable used in ABAP OO to address the object itself?
Please choose the correct answer.
Questão 5
Questão
You always want to check the user authorization for data entered in an input field of a selection screen.Where do you do this?
Please choose the correct answer.
Responda
-
In the event block AT SELECTION-SCREEN on VALUE-REQUEST
-
In the event block AT SELECTION-SCREEN
-
In the event block INITIALIZATION
-
In the event block AT SELECTION-SCREEN OUTPUT
Questão 6
Questão
What is the difference between the INITIALIZATION and AT SELECTION-SCREEN OUTPUT events?
Please choose the correct answer
Responda
-
• INITIALIZATION can overwrite the default value of a PARAMETERS field
• AT SELECTIION-SCREEN OUTPUT can overwrite the default values of a PARAMETERS field
-
• INITIALIZATION is only processed once.
• AT SELECT-SCREEN OUTPUT can be processed multiple times
-
• INITIALIZATION can change the properties of the screen fields
• AT SELECTION-SCREEN OUTPUT cannot change the properties of the screen field
-
• INITIALIZATION cannot change pushbutton texts
• AT SELECTION-SCREEN OUTPUT can change pushbutton texts
Questão 7
Questão
You want to select data from two tables and store the result in as structure.
Table PARTNER contains the fields PART_ID and KIND.
Table CONTRACT contains the fields CONT_ID, CONT_TYPE and DIVISION.
The structure is defined as follows
DATA: BEGIN OF wa_result,
Part_id type partner-part_id, cont_id type contract-cont_id,
Cont_type TYPE contract-cont_type,
END of wa_result,
Lt_result type table of wa_result.
How can you replace the following SELECT statement with an outer join?
SELECT part_id from partner INTO wa_result WHERE kind = ‘Residential’.
SELECT cont_id from CONTRACT into wa_result-cont_id WHERE part EQ
wa_partner-part_id And DIVISION eq ‘Water’.
Append wa_result to lt_result.
ENDSELECT.
If sy-subrc<>0. CLEAR wa_result-cont_id
APPEND wa_result TO lt_result. ENDIF.
ENDSELECT.
Please choose the correct answer.
Responda
-
SELECT part_idcont_id from partner AS A LEFT JOIN contract AS b ON a~part_id = b~part_id AND b~division EQ ‘Water’ INTO TABLElt_result WHERE kind = ‘Residential’
-
SELECT part_idcont_id from partner LEFT JOIN contract on partner-part_id = contract-part_id AND partner-kind EQ ‘Residential’ INTO CORRESPONDING FIELDS OF TABLE lt_result WHERE division eq ‘Water’.
-
SELECT part_idcont_id from partner AS A LEFT JOIN contract AS b ON a~part_id = b~part_id INTO CORRESPONDING FIELDS OF TABLE lt_result WHERE kind = ‘Residential’ and AND division EQ ‘Water’.
-
SELECT part_idcont_id from partner LEFT JOIN contract on partner-part_id = contract-part_id AND contract-division EQ ‘Water’ INTO TABLE lt_result WHERE kind EQ ‘Residential’.
Questão 8
Questão
Your selection screen can be modified at which event?
Questão 9
Questão
Where should the labels for fields be stored?
Responda
-
TAble
-
Structure
-
Data element
-
Domain
-
Field
Questão 10
Questão
What is the difference between SAP Basis and SAP NetWeaver?
Responda
-
All versions of SAP NetWeaver require the use of Unicode.
-
All versions of SAP NetWeaver include the ability to handle HTTP requests
-
All versions of SAP NetWeaver require the use of UTF-8.
-
There is no difference; the name change was driven by marketing alone.
Questão 11
Questão
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.
Responda
-
The table in the FROM clause must be a transparent table
-
All fields in the SELECT clause that are not part of an aggregate function must be listed after GROUP BY.
-
The fields after GROUP BY must have a character type.
-
The SELECT statement must also have a WHERE clause.
Questão 12
Questão
How can you declare an internal table using the transparent table A as its line type?
Please choose the correct answer.
Responda
-
DATA gt_itab TYPE REF TO a
-
DATA gt_itab TYPE TABLE OF a.
-
DATA gt_itab TYPE LINE OF a.
-
DATA gt_itab TYPE a.
Questão 13
Questão
dbtab is a transparent table. What is declared by the following statement? DATA myvar TYPE dbtab.
Questão 14
Questão
For a given date(variable lv_date), you want to find all the connections from Frankfurt to Sydney with exactly one stopover. You want to fly from the stopover city to Sydney on the same day you arrive in the stopover city.
Table ZFLIGHTS hold the following information about flights.
-flightid: primary key
-cityfrom:departure city
-datefrom: departure date
-timefrom:departure time
-cityto:destination city
-dateto:destination date
-timeto:destination time
Which of the following Open SQL Queries can you use to find all the possible stopover cities?
Please choose the correct answer.
Responda
-
SELECT DISTINCT cityfrom INTO TABLE lt_cities FROM zflights AS destination
WHERE cityfrom IN (SELECT cityto FROM zflights
WHERE dateto = destination~datefrom AND
timeto < destination~timefrom AND
cityfrom = ‘FRANKFURT’ AND
datefrom = lv_date )
AND destination~cityto = ‘Sydney’
-
SELECT cityfrom INTO TABLE lt_cities FROM zflights AS destination
WHERE cityto IN (SELECT DISTINCT cityfrom FROM zflights
WHERE dateto = destination~datefrom AND
timeto < destination~timefrom AND
cityfrom = ‘FRANKFURT’ AND
datefrom = lv_date )
AND destination~cityto = ‘Sydney’
-
SELECT DISTINCT cityto INTO TABLE lt_cities FROM zflights AS destination
WHERE cityfrom IN (SELECT cityto FROM zflights
WHERE dateto = destination~datefrom AND
timeto < destination~timefrom AND
cityfrom = ‘FRANKFURT’ AND
datefrom = lv_date )
AND destination~cityto = ‘Sydney’
-
SELECT cityto INTO TABLE lt_cities FROM zflights AS destination
WHERE cityfrom IN (SELECT DISTINCT cityto FROM zflights
WHERE dateto = destination~datefrom AND
timeto < destination~timefrom AND
cityfrom = ‘FRANKFURT’ AND
datefrom = lv_date )
AND destination~cityto = ‘Sydney’
Questão 15
Questão
How can you add a session breakpoint to your program?
There are 2 correct answers to this question.
Responda
-
Set a breakpoint in the ABAP editor and select Save.
-
Execute command /h
-
Set a breakpoint in the ABAP editor
-
Set a breakpoint in the ABAP debugger and press F8
Questão 16
Questão
Which of the following transactions are integrated in the ABAP workbench tools?
There are 2 correct answers to this question.
Questão 17
Questão
You Created the following ABAP Code:
DATA x TYPE REF TO DATA
DATA y TYPE REF TO OBJECT
ASSIGN x TO <fs>
ASSIGN y TO <fs>
You want to add a declaration of <fs> to the Code.
Which of the Following Declarations are Valid?
There are 2 correct answers to this question.
Responda
-
FIELD-SYMBOLS TYPE REF TO DATA
-
FIELD-SYMBOLS <fs>
-
FIELD-SYMBOLS <fs> TYPE ANY
-
FIELD-SYMBOLS <fs> TYPE REF TO ANY
Questão 18
Questão
What is the event block that all of your code changes belongs to if you do not explicitly code any event blocks in an executable program?
Please choose the correct answer.
Questão 19
Questão
What are some of the advantages of using OPEN SQL?
There are 2 correct answers to this question
Responda
-
The application server buffer is NOT used
-
It can be used with any DBMS
-
All standard SQL commands can be used
-
Syntax is checked at design time
Questão 20
Questão
What happens when an authorization check fails?
Please choose the correct answer.
Responda
-
A CX_AUTH_FAILED type exception is raised.
-
The system field SY-SUBRC is set to a value other than zero.
-
A type E message is displayed.
-
The program is terminated.
Questão 21
Questão
Which ABAP statement using the local type gty_1 correctly defines a data object?
There are 2 correct answers to this question.
Questão 22
Questão
When is an ENDSELECT not required for a SELECT?
There are 3 correct answers to this question.
Responda
-
When you specify into a table
-
When you specify a join of tables
-
When you do a SELECT SINGLE
-
When you specify appending a table
-
When the FROM is a view
Questão 23
Questão
There are ____ versions of the ABAP Editor.
Questão 24
Questão
Which desktops are part of the new ABAP debugger?
There are 3 correct answers to this question.
Responda
-
Desktop 1
-
Objects
-
Break./Watchpoints
-
List
-
Session
Questão 25
Questão
An executable ABAP program contains a standard selection screen and uses the event blocks AT SELECTION SCREEN, AT SELECTION-SCREEN OUTPUT, INITIALIZATION, START-OFSELECTION.
In which sequence will ABAP runtime call these event blocks?
Please choose the correct answer.
Responda
-
1. INITIALIZATION
2. AT SELECTION-SCREEN OUTPUT
3. AT SELECTION-SCREEN
4. START-OF-SELECTION
-
1. INITIALIZATION
2. AT SELECTION-SCREEN OUTPUT
3. START-OF-SELECTION
4. AT SELECTION-SCREEN
-
1. AT SELECTION-SCREEN OUTPUT
2. INITIALIZATION
3. AT SELECTION-SCREEN
4. START-OF-SELECTION
-
1. INITIALIZATION
2. AT SELECTION-SCREEN
3. AT SELECTION-SCREEN OUTPUT
4. START-OF-SELECTION