Jose Bermejo
Quiz by , created more than 1 year ago

ABAP ABAP 7.50 Quiz on ABAP 3, created by Jose Bermejo on 20/11/2019.

552
0
0
Jose Bermejo
Created by Jose Bermejo over 4 years ago
Close

ABAP 3

Question 1 of 25

1

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

Select one or more of the following:

  • 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

Explanation

Question 2 of 25

1

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

Select one or more of the following:

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

Explanation

Question 3 of 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.

Select one or more of the following:

  • Nested loop statements

  • Database views

  • Nested select statements

  • Pooled tables

  • Join statements

Explanation

Question 4 of 25

1

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

Select one of the following:

  • ME

  • SUPER

  • SELF

  • THIS

Explanation

Question 5 of 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.

Select one of the following:

  • 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

Explanation

Question 6 of 25

1

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

Select one of the following:

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

Explanation

Question 7 of 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.

Select one of the following:

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

Explanation

Question 8 of 25

1

Your selection screen can be modified at which event?

Select one of the following:

  • AT SELECTION-SCREEN OUTPUT

  • None of the above

  • AT SELECTION-SCREEN ON <field_name>

  • AT SELECTION-SCREEN

Explanation

Question 9 of 25

1

Where should the labels for fields be stored?

Select one of the following:

  • TAble

  • Structure

  • Data element

  • Domain

  • Field

Explanation

Question 10 of 25

1

What is the difference between SAP Basis and SAP NetWeaver?

Select one of the following:

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

Explanation

Question 11 of 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.

Select one or more of the following:

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

Explanation

Question 12 of 25

1

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

Select one of the following:

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

Explanation

Question 13 of 25

1

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

Select one of the following:

  • An elementary field

  • A structure variable

  • An internal table

  • A reference to an internal table

Explanation

Question 14 of 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.

Select one of the following:

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

Explanation

Question 15 of 25

1

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

Select one or more of the following:

  • 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

Explanation

Question 16 of 25

1

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

Select one or more of the following:

  • Process overview (SM50)

  • Overview of job selection (SM37)

  • ABAP editor (SE38)

  • Class builder (SE24)

Explanation

Question 17 of 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.

Select one or more of the following:

  • FIELD-SYMBOLS TYPE REF TO DATA

  • FIELD-SYMBOLS <fs>

  • FIELD-SYMBOLS <fs> TYPE ANY

  • FIELD-SYMBOLS <fs> TYPE REF TO ANY

Explanation

Question 18 of 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.

Select one of the following:

  • START-OF-SELECTION

  • LOAD-OF-PROGRAM

  • INITIALIZATION

  • AT SELECTION-SCREEN OUTPUT

Explanation

Question 19 of 25

1

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

Select one or more of the following:

  • 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

Explanation

Question 20 of 25

1

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

Select one of the following:

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

Explanation

Question 21 of 25

1

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

Select one or more of the following:

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

Explanation

Question 22 of 25

1

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

Select one or more of the following:

  • 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

Explanation

Question 23 of 25

1

There are ____ versions of the ABAP Editor.

Select one of the following:

  • 1

  • 4

  • 3

  • 2

Explanation

Question 24 of 25

1

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

Select one or more of the following:

  • Desktop 1

  • Objects

  • Break./Watchpoints

  • List

  • Session

Explanation

Question 25 of 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.

Select one of the following:

  • 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

Explanation

Previous
Next