151 - You define a formal parameter to a subroutine that accepts only internal table of type standard and type sorted as actual parameters. Which of the following generic ABAP data types must you use? Index table Standard table Hashed table Sorted table.
152 - You want to select data from two tables and store the result in as structure.CAIU NO MEU EXAME
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.
If sy-subrc<>0. CLEAR wa_result-cont_id
APPEND wa_result TO lt_result. ENDIF.
ENDSELECT. 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’. 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 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 partner-kind EQ ‘Residential’ INTO CORRESPONDING FIELDS OF TABLE lt_result WHERE division eq ‘Water’.
153 - When you add programming logic to your ABAP program that checks authorizations, which of the following do you have to create? Anauthorization Access Anauthorization profile Anauthorization role Anauthorization object.
154 - You always want to check the user authorization for data entered in an input field of a selection screen.Where do you do this? In the event block AT SELECTION-SCREEN on VALUE-REQUEST
In the event block AT SELECTION-SCREEN In the event block AT SELECTION-SCREEN OUTPUT In the event block INITIALIZATION.
155 - Which of the following ABAP statements throws an error at the syntax check? CAIU NO MEU EXAME DATA variable DATA variable(5) TYPE t. DATA variable(5) TYPE n. DATA variable(5) TYPE p.
156 - Which of the following must you do to be able to use a Business Add-in(BADI)? CAIU NO MEU EXAME Create the BADI implementation Activate the enhancement project Modify the adapter class Write code for methods.
157 - Table A and table B are partially buffered. CAIU NO MEU EXAME
Which of the following SELECT statements always access the database? SELECT SINGLE FOR UPDATE a b FROM table A INTO CORRESPONDING FIELDS OF ls_A WHERE c EQ ‘1234’. SELECT a b FROM table A INTO CORRESPONDING FIELDS OF TABLE lt_AB SELECT a b c d FROM table A JOIN table B ON table A~a EQ table B~
eINTO CORRESPONDING FIELDS OF TABLE lt_A_B. ( ) SELECT SINGLE CLIENT SPECIFIED a b FROM table A
INTO CORRESPONDING FIELDS OF ls_AB.
158 - For which of the following purposes can you use the ABAP dictionary?CAIU NO MEU EXAME To activate logging for transparent tables To create development classes To create lock objects To maintain program translations.
159 - Where can you define global data types that are visible system-wide? In a global interface In a function module In a method of a global class In the ABAP Dictionary
In a global class.
160 - Which of the following tools belong to the ABAP Workbench? Form Builder Function Builder Screen Painter Class Builder Easy Access Menu.
161 - Which of the following enhancement options does not require any preparation from SAP? Implicit enhancement point Explicit enhancement sections New BAdIs Explicitenhancement point.
162 - Which of the following predefined ABAP types is incomplete? P XSTRING F STRING.
163 - What will happen at runtime when accessing a buffered table? If table data is read using indexes, the table buffer will not be filled. If data is read from the table buffer, the existing indexes are not used. All SELECT statements will read data from the buffer. Following an update to a buffered record, all table buffers in the system will be updated.
164 - Which of the following transactions can you use to define transparent tables? CAIU NO MEU EXAME SE11 SE38 SE16N SM37.
165 - You create a function group ZATP. What is the name of the corresponding main program? SAPLZATP SAPFZATP SAPMZATP ZATP.
166 - Which of the following are valid control level changes within a loop over an internal table? COLLECT SUM LAST END of<f>.
167 - Which task does the dispatcher perform ? Administrates the lock table in the shared memory Distributes requests to the work process Verifies the correctness of ABAP programs Executes programs that run without user interaction.
168 - You count all customers within the same country. You want to display only the cities where three or more customers exist. Which of the following SQL statements you should use ? SELECT country city from customers INTO TABLE it_customers GROUP BY country city HAVING COUNT(*)>=3. SELECT country city cust_name FROM customers INTO TABLE it_customers GROUP BY country city cust_name HAVING COUNT (*) GE 3. SELECT country city cust_name COUNT(*) AS number FROM customers INTO TABLE it_customers GROUP BY country city HAVING number >=3. SELECT country city COUNT(*) AS number FROM customers INTO TABLE it_customers GROUP BY country city HAVING number GE 3.
169 - Before you can add programming logic to your ABAP program that checks authorizations, which of the following do you have to create ? An authorization object
An authorization role
An authorization profile
An authorization field.
170 - You have two web dynpro component controllers A and B. A uses B for display functions. Which of the following describe the external context mapping between A and B ? The mapping origin is defined on the context node of A. The mapping target is defined on the context node of A. The 'Interface Node' property is set on context nodes of B. The 'Interface Node' property is set on context nodes of A.
171 - Which of the following are fully-specified internal table types ? Any Standard Index Hashed.
172 - Which of the following customer modification options are available in the table maintenance generator ? Search helps Maintenance screens Events Append searches.
173 - The statement INITIALIZATION Sets a variable to value NULL Sets a variable to a initial value specified in the statement Is executed before the selection screen is displayed on the screen Is executed after the selection screen is displayed on the screen.
174 - How do you embed a subscreen in a screen? Use CALL SUBSCREEN in the flow logic of the main screen. Use SET SUBSCREEN in the flow logic of the main screen. Use SET SUBSCREEN in a PBO module of the main screen.
Use CALL SUBSCREEN in a PBO module of the main screen.
175 - You implement a search help that displays data selected via an outer join. Which view type can you use? Maintenance view Help view Protection view Database view.
176 - At the end of a project, the developers of a team need to release their tasks and the project lead needs to release their change request R1. Now another developer who does not belong to this team needs to maintain the object O1 that is part of the change request R1. When will this developer be able to change the object O1? After the request R1 has been released. After the task that contains the object O1 has been released After all objects of the request R1 have been imported successfully into the next system.
After the object O1 has been activated.
177 - To insert the data for ONE transaction (BDC_INSERT) into a session. To transfer the data, you require an internal table (BDC table). You must specify the following parameters: TCODE (transaction code) DYNPROTAB (BDC table) DYNPRO NAME. All the above .
178 - Which one of the. following statements creates a GUI-status in a dialog program? Set pf-status 'ABC'. Set screen 'ABC'. Set Pf_gui ' ABC '. Set gui-status = ZABC '.
179 - Which of the Following Fields are NOT for BDCDATA Structure? PROGRAM FINAME DYNPRO FVAL.
180 - What is the result of the following code?
Data : a(3) , b(3). A = '123'. B = '456'.
Perform modify using a b.
Write a. Write b.
Form abc using x value(y).
X = 'abc'.
Y = 'xyz'.
Endform. abcxyz is written to the screen 123456 is written to the screen abc456 is written to the screen abcxyz (on separate lines) is written to the screen.
181 - Which of the following enhancement options does not require any preparation from SAP? New BAdIs Explicit enhancement point Explicit enhancement sections Implicit enhancement point .
182 - How many lists can exist in parallel in an interactive reporting? An Interactive report can have 1 basic list and up to 20 Secondary lists. An Interactive report can have 1 basic list and up to 19 Secondary lists. An Interactive report can have 1 basic list and up to 19 Secondary lists. An Interactive report can have 1 basic list and up to 21 Secondary lists.
183 - What is the default mode for passing actual parameters in a Perform? By Value By Reference By Changing By Value and Return.
184 - A customer changes the code of a standard SAP ABAP program. How do you call this action? Correction Customizing Modification Personalization.
185 - Maximum of How many key fields per table is allowed? 12 Key Fields 16 Key Fields 10 Key Fields
14 Key Fields.
186 - Which ABAP statement using the local type gty_1 correctly defines a data object? DATA gv_1 TYPE gty_1 VALUE ‘1’. CONSTANTS gc_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'. .
187 - Which type pool is used for ALV Type-pools? SY-SLIS TYP-SLIS SILS SLIS.
188 - Syntax for BDCDATA Structure to declare in the Program? DATA LIKE BDCDATA occurs 0. DATA BDCDATA occurs 0 With HEADERLINE. DATA LIKE BDCTYPE occurs 0 With HEADERLINE.
DATA LIKE BDCDATA occurs 0 With HEADERLINE.
189 - Page headers for a secondary list should be coded in which event? TOP-OF-PAGE.
TOP-OF-PAGE DURING LINE-SELECTION
AT USER-COMMAND .
190 - How can you improve the performance of a database table access using a given SELECT statement? Define appropriate indexes for the database table Convert the database table to a polled table Use appropriate table buffering for the database table
Put the database table in the special fast access tablespace of the database.
191 - Which solutions are part of the SAP Business Suite? SAP Enterprise Resource Planning SAP Business One SAP Supply Chain Management SAP Business ByDesign SAP Product Lifecycle Management.
192 - TOP-OF-PAGE does one of the following Takes the cursor to the first line Event to generate page heading and Footer Event to generate page heading Takes the cursor to the first line of next page.
193 - Which definitions are NOT allowed in ABAP Objects? (2) Definitions of table types Definitions of internal types with headers lines
Definitions using the TABLES statement.
Definitions of nested structures
Definitions of deep structures.
194 - Which additional features have domains compared to ABAP Dictionary build-in types? Value tables Fixed values Search helps Parameter ID’s Conversion exits.
195 - You want to develop a classical screen (dynpro) with an input field. You define the input field with reference to a component of an ABAP Dictionary structure. How do you implement an automatic value check for the field? Define a foreign key relationship for the structure component Implement a PBO module to check the field value Assign a value table to the underlying domain Assign a search help to the input field.
196 - Colors can be associated with the report fields using one of the following commands Set color on Format colors on Format color on Formats color on.
197 - The message types are one of the following: A S W All the above .
198 - Which components are part of SAP NetWeaver? Business Warehouse (BW). Master Data Management (MDM). Enterprise Resource Planning (ERP). Customer Relationship Management (CRM). Product Lifecycle Management (PLM).
199 - What can you do using the class builder? Convert methods to function modules. Test classes in a simulated runtime environment Import classical screens from your program. Redesign classes and interfaces using the refactoring assistant Import local classes and local interfaces from your program.
200 - You want to have the system branch to list processing form within a screen. Which of the following statements apply here? You must place the command LEAVE TO LIST-PROCESSING at the end of the PAI of the respective screen. You have to program the two commands CALL SELECTION-SCREEN <screen no> and LEAVE TO LIST-PROCESSING. You have to program the command LEAVE TO LIST-PROCESSING. The list buffer must first be read (READ LIST).