Jose Bermejo
Quiz von , erstellt am more than 1 year ago

ABAP ABAP 7.50 Quiz am ABAP 3, erstellt von Jose Bermejo am 20/11/2019.

562
0
0
Jose Bermejo
Erstellt von Jose Bermejo vor etwa 5 Jahre
Schließen

ABAP 3

Frage 1 von 25

1

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

Wähle eine oder mehr der folgenden:

  • 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

Erklärung

Frage 2 von 25

1

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

Wähle eine oder mehr der folgenden:

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

Erklärung

Frage 3 von 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.

Wähle eine oder mehr der folgenden:

  • Nested loop statements

  • Database views

  • Nested select statements

  • Pooled tables

  • Join statements

Erklärung

Frage 4 von 25

1

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

Wähle eine der folgenden:

  • ME

  • SUPER

  • SELF

  • THIS

Erklärung

Frage 5 von 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.

Wähle eine der folgenden:

  • 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

Erklärung

Frage 6 von 25

1

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

Wähle eine der folgenden:

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

Erklärung

Frage 7 von 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.

Wähle eine der folgenden:

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

Erklärung

Frage 8 von 25

1

Your selection screen can be modified at which event?

Wähle eine der folgenden:

  • AT SELECTION-SCREEN OUTPUT

  • None of the above

  • AT SELECTION-SCREEN ON <field_name>

  • AT SELECTION-SCREEN

Erklärung

Frage 9 von 25

1

Where should the labels for fields be stored?

Wähle eine der folgenden:

  • TAble

  • Structure

  • Data element

  • Domain

  • Field

Erklärung

Frage 10 von 25

1

What is the difference between SAP Basis and SAP NetWeaver?

Wähle eine der folgenden:

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

Erklärung

Frage 11 von 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.

Wähle eine oder mehr der folgenden:

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

Erklärung

Frage 12 von 25

1

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

Wähle eine der folgenden:

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

Erklärung

Frage 13 von 25

1

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

Wähle eine der folgenden:

  • An elementary field

  • A structure variable

  • An internal table

  • A reference to an internal table

Erklärung

Frage 14 von 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.

Wähle eine der folgenden:

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

Erklärung

Frage 15 von 25

1

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

Wähle eine oder mehr der folgenden:

  • 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

Erklärung

Frage 16 von 25

1

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

Wähle eine oder mehr der folgenden:

  • Process overview (SM50)

  • Overview of job selection (SM37)

  • ABAP editor (SE38)

  • Class builder (SE24)

Erklärung

Frage 17 von 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.

Wähle eine oder mehr der folgenden:

  • FIELD-SYMBOLS TYPE REF TO DATA

  • FIELD-SYMBOLS <fs>

  • FIELD-SYMBOLS <fs> TYPE ANY

  • FIELD-SYMBOLS <fs> TYPE REF TO ANY

Erklärung

Frage 18 von 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.

Wähle eine der folgenden:

  • START-OF-SELECTION

  • LOAD-OF-PROGRAM

  • INITIALIZATION

  • AT SELECTION-SCREEN OUTPUT

Erklärung

Frage 19 von 25

1

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

Wähle eine oder mehr der folgenden:

  • 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

Erklärung

Frage 20 von 25

1

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

Wähle eine der folgenden:

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

Erklärung

Frage 21 von 25

1

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

Wähle eine oder mehr der folgenden:

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

Erklärung

Frage 22 von 25

1

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

Wähle eine oder mehr der folgenden:

  • 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

Erklärung

Frage 23 von 25

1

There are ____ versions of the ABAP Editor.

Wähle eine der folgenden:

  • 1

  • 4

  • 3

  • 2

Erklärung

Frage 24 von 25

1

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

Wähle eine oder mehr der folgenden:

  • Desktop 1

  • Objects

  • Break./Watchpoints

  • List

  • Session

Erklärung

Frage 25 von 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.

Wähle eine der folgenden:

  • 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

Erklärung