Quiz
ABAP 3
Crie uma conta grátis para terminar este quiz
Salve seu progresso e veja sua nota final.
Já tem uma conta? Inicie sessão
Perguntas do quiz (25)
1When should you use a hashed internal table?
There are 2 correct answers to this question.- AWhen accessing mainly single records
- BWhen accessing by index
- CWhen accessing always by primary key
- DWhen accessing by secondary key
- EWhen accessing using the left-justified part of the key
2What must you do to define a database view using the ABAP Dictionary?
There are 3 correct answers to this question.- ADefine the join conditions between the tables.
- BDefine selection criteria for the view.
- CChoose the database tables from where the view acquires data.
- DChoose the fields from the tables that should be part of the view.
- EDefine buffering settings for the underlying database tables.
3Which options do you have to read data from multiple tables while using a SELECT statement?
There are 3 correct answers to this question.- ANested loop statements
- BDatabase views
- CNested select statements
- DPooled tables
- EJoin statements
4What is the predefined reference variable used in ABAP OO to address the object itself?
Please choose the correct answer.- AME
- BSUPER
- CSELF
- DTHIS
5You 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.- AIn the event block AT SELECTION-SCREEN on VALUE-REQUEST
- BIn the event block AT SELECTION-SCREEN
- CIn the event block INITIALIZATION
- DIn the event block AT SELECTION-SCREEN OUTPUT
6What is the difference between the INITIALIZATION and AT SELECTION-SCREEN OUTPUT events?
Please choose the correct answer- A• INITIALIZATION can overwrite the default value of a PARAMETERS field
• AT SELECTIION-SCREEN OUTPUT can overwrite the default values of a PARAMETERS field - B• INITIALIZATION is only processed once.
• AT SELECT-SCREEN OUTPUT can be processed multiple times - C• INITIALIZATION can change the properties of the screen fields
• AT SELECTION-SCREEN OUTPUT cannot change the properties of the screen field - D• INITIALIZATION cannot change pushbutton texts
• AT SELECTION-SCREEN OUTPUT can change pushbutton texts
- A• INITIALIZATION can overwrite the default value of a PARAMETERS field
7You 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.- ASELECT 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’
- BSELECT 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’.
- CSELECT 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’.
- DSELECT 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’.
8Your selection screen can be modified at which event?
- AAT SELECTION-SCREEN OUTPUT
- BNone of the above
- CAT SELECTION-SCREEN ON <field_name>
- DAT SELECTION-SCREEN
9Where should the labels for fields be stored?
- ATAble
- BStructure
- CData element
- DDomain
- EField
10What is the difference between SAP Basis and SAP NetWeaver?
- AAll versions of SAP NetWeaver require the use of Unicode.
- BAll versions of SAP NetWeaver include the ability to handle HTTP requests
- CAll versions of SAP NetWeaver require the use of UTF-8.
- DThere is no difference; the name change was driven by marketing alone.
11Which 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.- AThe table in the FROM clause must be a transparent table
- BAll fields in the SELECT clause that are not part of an aggregate function must be listed after GROUP BY.
- CThe fields after GROUP BY must have a character type.
- DThe SELECT statement must also have a WHERE clause.
12How can you declare an internal table using the transparent table A as its line type?
Please choose the correct answer.- ADATA gt_itab TYPE REF TO a
- BDATA gt_itab TYPE TABLE OF a.
- CDATA gt_itab TYPE LINE OF a.
- DDATA gt_itab TYPE a.
13dbtab is a transparent table. What is declared by the following statement? DATA myvar TYPE dbtab.
- AAn elementary field
- BA structure variable
- CAn internal table
- DA reference to an internal table
14For 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.- ASELECT 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’ - BSELECT 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’ - CSELECT 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’ - DSELECT 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’
- ASELECT DISTINCT cityfrom INTO TABLE lt_cities FROM zflights AS destination
15How can you add a session breakpoint to your program?
There are 2 correct answers to this question.- ASet a breakpoint in the ABAP editor and select Save.
- BExecute command /h
- CSet a breakpoint in the ABAP editor
- DSet a breakpoint in the ABAP debugger and press F8
16Which of the following transactions are integrated in the ABAP workbench tools?
There are 2 correct answers to this question.- AProcess overview (SM50)
- BOverview of job selection (SM37)
- CABAP editor (SE38)
- DClass builder (SE24)
17You 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.- AFIELD-SYMBOLS TYPE REF TO DATA
- BFIELD-SYMBOLS <fs>
- CFIELD-SYMBOLS <fs> TYPE ANY
- DFIELD-SYMBOLS <fs> TYPE REF TO ANY
18What 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.- ASTART-OF-SELECTION
- BLOAD-OF-PROGRAM
- CINITIALIZATION
- DAT SELECTION-SCREEN OUTPUT
19What are some of the advantages of using OPEN SQL?
There are 2 correct answers to this question- AThe application server buffer is NOT used
- BIt can be used with any DBMS
- CAll standard SQL commands can be used
- DSyntax is checked at design time
20What happens when an authorization check fails?
Please choose the correct answer.- AA CX_AUTH_FAILED type exception is raised.
- BThe system field SY-SUBRC is set to a value other than zero.
- CA type E message is displayed.
- DThe program is terminated.
21Which ABAP statement using the local type gty_1 correctly defines a data object?
There are 2 correct answers to this question.- ADATA gv_1 TYPE gty_1.
- BDATA gv_1 TYPE gty_1 DEFAULT '1'.
- CDATA gv_1 LIKE gty_1
- DCONSTANTS gc_1 TYPE gty_1 VALUE '1'
22When is an ENDSELECT not required for a SELECT?
There are 3 correct answers to this question.- AWhen you specify into a table
- BWhen you specify a join of tables
- CWhen you do a SELECT SINGLE
- DWhen you specify appending a table
- EWhen the FROM is a view
23There are ____ versions of the ABAP Editor.
- A1
- B4
- C3
- D2
24Which desktops are part of the new ABAP debugger?
There are 3 correct answers to this question.- ADesktop 1
- BObjects
- CBreak./Watchpoints
- DList
- ESession
25An 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.- A1. INITIALIZATION
2. AT SELECTION-SCREEN OUTPUT
3. AT SELECTION-SCREEN
4. START-OF-SELECTION - B1. INITIALIZATION
2. AT SELECTION-SCREEN OUTPUT
3. START-OF-SELECTION
4. AT SELECTION-SCREEN - C1. AT SELECTION-SCREEN OUTPUT
2. INITIALIZATION
3. AT SELECTION-SCREEN
4. START-OF-SELECTION - D1. INITIALIZATION
2. AT SELECTION-SCREEN
3. AT SELECTION-SCREEN OUTPUT
4. START-OF-SELECTION
- A1. INITIALIZATION
Informações
- Descrição
- ABAP ABAP 7.50 Quiz sobre ABAP 3, criado por Jose Bermejo em 20-11-2019.
- Autor
- Jose Bermejo
- Idioma
- Español
- Visualizações
- 582
- Etiquetas
- Avaliação
- 4,0 de 5 · 1 avaliação Avalie este quiz