ABAP CERTI SHSM-2

What are some advantages of using open SQL? Note: There are 2 correct answers to this question (2). The application server buffer is NOT used. Syntax is checked at design time. All standard SQL commands can be used. It can be used with any supported DBMS.

You have created a screen on which the user enters data that is to be inserted into table Tl. How do you ensure that the content of field F in Table Tl is checked against table T2?. Create a foreign key for the assigned fiesld F of table T1 in the table T2 and make table T2 the check table. Create a foreign key for the assigned field of field F of Table T1 in the table T2 and make table t1 the check table. Create a foreign key for field F of table t1 and make table t2 the check table. Create a foreign key for field F of table t1 and make tabke t2 and the foreign key table.

Which of the following statements correctly define a data object with the data type of data element s_conn_id? (3). PARAMETER pa_id TYPE s_conn_id. DATA: gv_id LIKE s_conn_id. DATA: gv_id TYPE REF TO s_conn_id. DATA: gv_id TYPE s_conn_id. CONSTANTS gc_id TYPE s_conn_id VALUE '0400'.

How do you create lock objects and lock modules for use in ABAP programs that's access the database?. Use the function builder to create the lock modules. The lock objects are created automatically. Use the ABAP Dictionary to create the lock objects. Use the functions builder to create the lock modules. Use the function builder to create the lock modules and the lock objects. Use the ABAP Dictionary to create the lock objects. The lock module is created automatically.

You run an executable program that contains the following code: DATA: gv_varl TYPE n LENGTH 3. gv_var2 TYPE n LENGTH 3 VALUE '456' START OF SELECTION. CLEAR gv_var2 gv_var2=g. When the assignment to gv_var2 is executed. When the assignment to gv_var2 is executed. As soon as the program is loaded into the terminal session. At the beginning of the START-OF-SELECTION event block.

What transaction can be used to carry out modification adjustment after a system upgrade? Note: There are 2 correct answers to this question. (2). SPAD. SPAU. SPDD. SPAU_ENH.

You created a class by inheriting from a superclass. The superclass contains a public instance method do something; you want to redefine method do something. What must you do?. Change the visibility of the method to PROTECTED. Declare the method FINAL. Leave the signature of the method unchanged. Call the implementation in the superclass.

What can be part of the signature of an instance constructor? Note: There are 2 correct answers to this question (2). Importing parameters. Exporting parameters. Changing parameters. Exceptions.

You write a report that displays mass data in a table using the ALV Grid control, which of the following functions can you offer to the user without doing any specific programming? (2). Display details by double clicking on a row. Sort and filter the data by any column. Convert and currency amount columns. Change column width and sequence.

You want to define a field symbol that will be assigned to a character string. Which generic types can you use? (3) Note: There are 3 correct answers to this question. Sequence. Click. Any table. Any.

You have created the following. A class with an event definition. A Handler class with a method ON_EVT that handles this event. A report that instantiates the handler class. A message statement that raises an exception however AND the report does not react to the event. How do you analyze this issue? (3) Note: There are 3 correct answers to this question. Check if the handler method is registered to the correct event. Check if the event is triggered by setting a breakpoint at MESSAGE...RAISING...statement. Check if the handler method ON_EVT is defined in a subroutine of the report. Check if the event is triggered by setting a breakpoint at the RAISE EVENT statement. Check if the implementation of the handler method ON_EVT contains the desired login.

What ABAP Dictionary object allows you to define fixed values. Lock object. Data element. View. Domain.

What type of method is generated automatically by the web Dynpro Explorer when you assign an action to a button UI element?. Supply function. Event handler method. Standard hook method. Ordinary method.

In which order do you implement a new BADI?. 1. BADI Implementation 2. Create Enhancement Project. 1. BADI Implementation 2. Create Enhancement Spot Implementation. 1. Create Enhancement Project 2. BADI Implementation. 1. Create Enhancement spot implementation 2. BADI Implementation.

After which statement will the runtime system initialize the ABAP memory?. LEAVE TO TRANSACTION. CALL TRANSACTION. SUBMIT..AND RETURN. SUBMIT.

You enhance an SAP standard global class by defining a post-method for an SAP method, the original SAP method has an EXPORTING parameter named PARI. What type of parameters is PARI in the post-method?. IMPORTING. EXPORTING. CHANGING. RETURNING.

A user runs an ABAP program AND enters an incorrect value on the selection screen AND and chooses Execute. Which event block must send the error messages in order messages in order to display the selection screen again?. AT SELEECTION-SCREEN. AT SELECTION-CREEN ON VALUE REQUEST. AT SELECTION-SCREEN ON HELP-REQUEST. AT SELECTION-SCREEN OUTPUT.

Which of the following elements can a string template contain? Note: There are 2 correct answers to this question (2)******. Functional module calls. Function methods calls. String processing statements. Literals.

What are the reasons to use modularization? Note: There are 3 correct answers to this question (3). Easier maintenance. Portability across DBMS. Improved performance. Promotes reusability. Improved transparency.

You want to loop over an internal table without copying each table row to a work area. How can you achieve this using a field symbol?. LOOP...ASSIGNING...ENDLOOP. LOOP...REFERENCE INTCL.ENDLOOP. LOOP..INTO...ENDLOOP. LOOP...ITO TRANSPORT... ENDLOOP.

Which of the following incomplete ABAP pre-defined data types? Note: There are 3 correct answers to this question (3). N. T. D. X. P.

You write a program that updates a data record in the database using the following statements. UPDATE scar FROM Is_scarr, which of the following task does the database interface perform? (2). It translates the statement to native SQL. It restricts the access to the logon client. It checks the authorization of the current user. It applies a logical lock to the updated date record.

In which event block can you overwrite the default value of PARAMETERS field on the selection screen?. START-OF-SELECTION. INITIALIZATION. START-OF-SELECTION. PROCESS BEFORE OUTPUT.

A class is defined as follows CLASS my _class DEFINITION PUBLIC SECTION METHODS do something EVENTS state_changed CLASS Methods staticl PRIVATE SECTION TYPES t_table type Standard table OF 1001 CONSTANTS gc_constTYPE I ENDCLASS which components of the class can static method staticl address directly? (2). The state_changed event. The t_table type. The gc_const constant. The do_something method.

You have declared a sorted internal table with the columns A AND B AND C AND D. The key consists of columns A AND B AND C in this order. Which combination of columns in the where clause of a Loop statement allows the system to optimize the access to table? (2) Note: There are 2 correct answers to this question. A AND B. C AND D. B and C. A AND BAND C AND D.

You want to deploy a program that processes character type data. When you implement the program, you can either use the classical string statement or the newer string expressions and functions what are the main benefits of using the newer string expressions and string functions? Note: There are 2 correct answers to this question (2). You can improve the performance significantly. You can write compact syntax instead a long sequence of statements. You can reduce the number of intermediate variables. You can write code that is very easy to read and understand.

What do enhancements spots manage? Note: There are 3 correct answers to this question (3). Classic BADI. Implicit enhancement points. Explicit enhancement sections. Explicit enhancement points. New BADIS.

You are making changes to a program that already has transaction code ZZZZ linked to it. Your colleague is testing transaction code ZZZZ in the same system. When does the changed version of the program becomes visible to your colleague via transaction code ZZZZ?. When you execute the program from the ABAP Editor. When the syntax of the program is correct. When you active the program. When you save the program.

Which of the following program type can contain screens? Note: There are 3 correct answers to this question. (3). Function groups. Module pools. Interface pools. Class pools. Executable programs.

Which are the functions of the ABAP dispatcher? Note: There are 3 correct answers to this question (3). It integrates the presentation layer. It saves the processing request in request in request queues. It performs a roll-in and roll-out of user context. It requests the data from the database or the buffers. It distributes the request among the work processes.

Which of the following setting can you define for both structures and transparent tables in the ABAP Dictionary? Note: There are 2 correct answers to this question. (2). Storage type. Enhancement category. Size category. Foreign key relationships.

What must exist before you can create a new transportable function module? Note: There are 3 correct answers to this question. (3). Type group. Change request / Transparent request. Function group. Package. Module pool.

A function module that has 2 classical exceptions is called with actual parameter value in such a way that both exception conditions are fulfilled. How will the runtime system be had?. The first exception that occurs will be raised in the calling program AND sy-subrc has the value specified for the first exception. Both exception s will be raised in the calling program AND sy-subrc hac the value specified for the second exception. Both exceptions will be raised in the calling program AND sy-subrc has the value specified for the OTHER option. NO exceptions will be raised in the calling program AND sy-subrc has the value specified for the OTHER option.

In which of the following source code blocks can you define local data objects? Note: There are 3 correct answers to this question (3). Subroutine. LOAD-OF-PROGRAM. Static method. Function module. PBO module.

You are asked to enhance the GUI status of an SAP standard application. How do you identify which menu exit function code you can use?. It starts with a plus (+). It starts with a dollar sign ($). It starts with an ampersand (&). It starts with an asterisk (*).

Which database objects can you create in the ABAP Dictionary? Note: There are 2 correct answers to this question. (2). Indixes. Projection views. Logical databases. Foreign key relationships.

You program uses class CL_GUI_ALV_GRID to generate a classic ALV Grid control. What do you need in your program to react to a user double-clicking a row in the ALV Grid? Note: There are 3 correct answers to this question (3). A handler classes. A method calls to raise the double-click event. A SET HANDLER statements to the event. A handler method for the double-click event. A method calls to refresh the displa.

You have the following class definition: CLASS ICL_airplane DEFINITION PUBLIC SECTION. METHODS: set_passengers. PROTECTED SECTION CONSTANTS c_pos type i.methods get_passengers PRIVATE SECTION DATA mv_passengers TYPE I, METHODS set_attributes ENDCALSS. Which components can be addressed directly from a subclass of class ICL_airplane? (3). GET_PASSENGER. SET_ATTRIBUTES. Pos. SET_PASSENGER.

You write the following ABAP statement SELECT SINGLE carrid AND connid cityfrom AND cityto FROM spifi INTO@gs_spfi WHERE carrid=@ps_car AND connid = @pa_con How are the selected fields placed into rget Structure gs_spfir?. Into fields with the same name and same type. Into fields with the same name. From left to right. Into fields with the same type.

You want to read a single line of an internal table using table expression itab[...]. How can you identify the line? Note: There are 3 correct answers to this question (3). Specify the line index. Specify a free table key. Specify a regular expression. Specify a WHERE Condition. Specify a secondary table key.