Jose Bermejo
Quiz por , criado more than 1 year ago

ABAP ABAP 7.50 Quiz sobre ABAP 3, criado por Jose Bermejo em 20-11-2019.

562
0
0
Jose Bermejo
Criado por Jose Bermejo aproximadamente 5 anos atrás
Fechar

ABAP 3

Questão 1 de 25

1

When should you use a hashed internal table?
There are 2 correct answers to this question.

Selecione uma ou mais das seguintes:

  • 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

Explicação

Questão 2 de 25

1

What must you do to define a database view using the ABAP Dictionary?
There are 3 correct answers to this question.

Selecione uma ou mais das seguintes:

  • 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.

Explicação

Questão 3 de 25

1

Which options do you have to read data from multiple tables while using a SELECT statement?
There are 3 correct answers to this question.

Selecione uma ou mais das seguintes:

  • Nested loop statements

  • Database views

  • Nested select statements

  • Pooled tables

  • Join statements

Explicação

Questão 4 de 25

1

What is the predefined reference variable used in ABAP OO to address the object itself?
Please choose the correct answer.

Selecione uma das seguintes:

  • ME

  • SUPER

  • SELF

  • THIS

Explicação

Questão 5 de 25

1

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.

Selecione uma das seguintes:

  • 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

Explicação

Questão 6 de 25

1

What is the difference between the INITIALIZATION and AT SELECTION-SCREEN OUTPUT events?
Please choose the correct answer

Selecione uma das seguintes:

  • • 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

Explicação

Questão 7 de 25

1

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.

Selecione uma das seguintes:

  • 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’.

Explicação

Questão 8 de 25

1

Your selection screen can be modified at which event?

Selecione uma das seguintes:

  • AT SELECTION-SCREEN OUTPUT

  • None of the above

  • AT SELECTION-SCREEN ON <field_name>

  • AT SELECTION-SCREEN

Explicação

Questão 9 de 25

1

Where should the labels for fields be stored?

Selecione uma das seguintes:

  • TAble

  • Structure

  • Data element

  • Domain

  • Field

Explicação

Questão 10 de 25

1

What is the difference between SAP Basis and SAP NetWeaver?

Selecione uma das seguintes:

  • 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.

Explicação

Questão 11 de 25

1

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.

Selecione uma ou mais das seguintes:

  • 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.

Explicação

Questão 12 de 25

1

How can you declare an internal table using the transparent table A as its line type?
Please choose the correct answer.

Selecione uma das seguintes:

  • 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.

Explicação

Questão 13 de 25

1

dbtab is a transparent table. What is declared by the following statement? DATA myvar TYPE dbtab.

Selecione uma das seguintes:

  • An elementary field

  • A structure variable

  • An internal table

  • A reference to an internal table

Explicação

Questão 14 de 25

1

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.

Selecione uma das seguintes:

  • 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’

Explicação

Questão 15 de 25

1

How can you add a session breakpoint to your program?
There are 2 correct answers to this question.

Selecione uma ou mais das seguintes:

  • 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

Explicação

Questão 16 de 25

1

Which of the following transactions are integrated in the ABAP workbench tools?
There are 2 correct answers to this question.

Selecione uma ou mais das seguintes:

  • Process overview (SM50)

  • Overview of job selection (SM37)

  • ABAP editor (SE38)

  • Class builder (SE24)

Explicação

Questão 17 de 25

1

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.

Selecione uma ou mais das seguintes:

  • FIELD-SYMBOLS TYPE REF TO DATA

  • FIELD-SYMBOLS <fs>

  • FIELD-SYMBOLS <fs> TYPE ANY

  • FIELD-SYMBOLS <fs> TYPE REF TO ANY

Explicação

Questão 18 de 25

1

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.

Selecione uma das seguintes:

  • START-OF-SELECTION

  • LOAD-OF-PROGRAM

  • INITIALIZATION

  • AT SELECTION-SCREEN OUTPUT

Explicação

Questão 19 de 25

1

What are some of the advantages of using OPEN SQL?
There are 2 correct answers to this question

Selecione uma ou mais das seguintes:

  • 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

Explicação

Questão 20 de 25

1

What happens when an authorization check fails?
Please choose the correct answer.

Selecione uma das seguintes:

  • 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.

Explicação

Questão 21 de 25

1

Which ABAP statement using the local type gty_1 correctly defines a data object?
There are 2 correct answers to this question.

Selecione uma ou mais das seguintes:

  • DATA gv_1 TYPE gty_1.

  • DATA gv_1 TYPE gty_1 DEFAULT '1'.

  • DATA gv_1 LIKE gty_1

  • CONSTANTS gc_1 TYPE gty_1 VALUE '1'

Explicação

Questão 22 de 25

1

When is an ENDSELECT not required for a SELECT?
There are 3 correct answers to this question.

Selecione uma ou mais das seguintes:

  • 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

Explicação

Questão 23 de 25

1

There are ____ versions of the ABAP Editor.

Selecione uma das seguintes:

  • 1

  • 4

  • 3

  • 2

Explicação

Questão 24 de 25

1

Which desktops are part of the new ABAP debugger?
There are 3 correct answers to this question.

Selecione uma ou mais das seguintes:

  • Desktop 1

  • Objects

  • Break./Watchpoints

  • List

  • Session

Explicação

Questão 25 de 25

1

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.

Selecione uma das seguintes:

  • 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

Explicação