Help!! Please help me with these questions

[Former Member]

<pre>

1. Which Open SQL statement should not be used with cluster databases?

A: UPDATE

B: MODIFY

C: DELETE

😧 INSERT

2. Assuming itab has a header line, what will be output by the following code?

READ TABLE itab INDEX 3 TRANSPORTING field1.

WRITE: /1 itab-field1, itab-field2.

A: The contents of the third row's itab-field1.

B: The contents of the third row's itab-field1 and itab-field2.

C: The contents of the third row's itab-field2.

😧 Nothing.

3. Which keyword adds a line anywhere within an internal table?

A: APPEND

B: MODIFY

C: ADD

😧 INSERT

4. If this code results in an error, the remedy is:

SELECT fld1 SUM( fld1 ) FROM tab1 INTO_

A: Remove the spaces from SUM( fld1 ).

B: Move SUM( fld1 ) before fld1.

C: Add GROUP BY f1.

😧 Change to SUM( DISTINCT f1 ).

5. The ____ type of ABAP Dictionary view consists of one or more transparent tables and may be

accessed by an ABAP program using Open SQL.

A: Database view

B: Projection view

C: Help view

😧 Entity view

6. Page footers are coded in the event:

A: TOP-OF-PAGE.

B: END-OF-SELECTION.

C: NEW-PAGE.

😧 END-OF-PAGE.

7. Assuming tab1-fld7 is not a key field, how can you prevent reading all the table rows?

SELECT fld1 fld2 fld3 FROM tab1 INTO (fld4, fld5, fld6)

WHERE fld7 = pfld7.

WRITE: /1 fld4, fld5, fld6.

ENDSELECT.

A: Take fld7 out of the WHERE clause.

B: Create an index in the ABAP Dictionary for tab1-fld7.

C: Use INTO TABLE instead of just INTO.

😧 Take theWRITE statement out of the SELECT_ENDSELECT.

8. Within the ABAP program attributes, Type = 1 represents:

A: INCLUDE program

B: Online program

C:Module pool

😧 Function group

E: Subroutine pool

9.

1 TABLES: MARC.

2 DATA: BEGIN OF ITAB OCCURS 0,

3 FIELD1(5),

4 FIELD2(5),

5 END OF ITAB.

6 READ ITABWITH KEYMATNR = '12345'.

7 IF SY-SUBRC = 0.

8WRITE:/ ITAB-MATNR.

9 ENDIF.

Referring to the above code, which line contains an error?

a) Line 2

b) Line 5

c) Line 6

d) Line 7

e) Line 8

`0. Assuming a pushbutton with function code u2018FUNCu2019 is available in the toolbar of a list report,

what event is processed when the button is clicked?

A: AT USER-COMMAND.

B: AT PFn.

C: AT SELECTION-SCREEN.

😧 END-OF-SELECTION.

11. Which of the following would be best for hiding further selection criteria until a function is

chosen?

A: AT NEW SELECTION-SCREEN

B: SELECTION-SCREEN AT LINE-SELECTION

C: SUBMIT SELECTION-SCREEN

😧 CALL SELECTION-SCREEN

12. If the following code results in a syntax error, the remedy is:

DATA: itab TYPE SORTED TABLE OF rec_typeWITH UNIQUE KEY field1

WITH HEADER LINE.

itab-field1 = 'Company'. itab-field2 = '1234'. INSERT TABLE itab.

itab-field1 = 'Bank'. itab-field2 = 'ABC'. INSERT TABLE itab.

SORT itab.

LOOP AT itab.

write: /1 itab-field1, itab-field2.

ENDLOOP.

A: There is no syntax error here

B: Remove the SORT statement

C: Change INSERT to APPEND

😧 Add aWHERE clause to the loop

13. If this code results in an error, the remedy is:

SELECT fld1 fld2 FROM tab1WHERE fld3 = pfld3.

WRITE: /1 tab1-fld1, tab1-fld2.

ENDSELECT.

A: Add a SY-SUBRC check.

B: Change theWHERE clause to use fld1 or fld2.

C: Remove the /1 from theWRITE statement.

😧 Add INTO (tab1-fld1, tab1-fld2).

14. A BDC program is used for all of the following except:

A: Downloading data to a local file

B: Data interfaces between SAP and external systems

C: Initial data transfer

😧 Entering a large amount of data

15. In regard to HIDE, which of the following is NOT a true statement?

A: Saves the contents of variables in relation to a list line's row number.

B: The hidden variables must be output on a list line.

C: The HIDE area is retrieved when using the READ LINE statement.

😧 The HIDE area is retrieved when an interactive event is triggered.

16. Database locks are sufficient in a multi-user environment.

A: True

B: False

17. To allow the user to enter a range of values on a selection screen, use the ABAP keyword:

A: DATA.

B: RANGES.

C: PARAMETERS.

😧 SELECT-OPTIONS.

18. Assuming an internal table contains 2000 entries, how many entries will it have after the following

line of code is executed?

DELETE itab FROM 1500 TO 1700.

A: This is a syntax error.

B: 1801

C: 1800

😧 1799

19. Adding a COMMITWORK statement between SELECT_ENDSELECT is a good method for improving

performance.

A: True

B: False

20. To bypass automatic field input checks, include this in PAI.

A: AT EXIT-COMMAND

B: ON INPUT

C: ON REQUEST

😧 LEAVE TO SCREEN 0.

21. To select all database entries for a certainWHERE clause into an internal table in one step, use

A: SELECT_INTO TABLE itab_

B: SELECT_INTO itab_

C: SELECT_APPENDING itab

😧 SELECT_itab_

22. The following code indicates:

SELECT fld1 fld2 FROM tab1 APPENDING TABLE itab

WHERE fld1 IN sfld1.

A: Add rows to the existing rows of itab.

B: Add rows to itab after first deleting any existing rows of itab.

C: Select rows from tab1 for matching itab entries.

😧 Nothing, this is a syntax error.

23. Which of these sentences most accurately describes the GET VBAK LATE. event?

A: This event is processed before the second time the GET VBAK event is processed.

B: This event is processed after all occurrences of the GET VBAK event are completed.

C: This event will only be processed after the user has selected a basic list row.

😧 This event is only processed if no records are selected from table VBAK.

24. When a secondary list is being processed, the data of the basic list is available by default.

A: True

B: False

25. After adding rows to an internal table with COLLECT, you should avoid adding more rows

with APPEND.

A: True

B: False

</pre>

Edited by: Nandesh Nair on Oct 23, 2009 7:08 PM

[Former Member]

Seeing as it's Friday and I'm in a particularly good mood, I'm not going to lock this.

However, if anyone gives any answers that seem even remotely helpful, the poster will go on my list.

Tob

[Former Member]

LOL!!! Rob, interesting approach.

[Former Member]

If these are meant to be ABAP certification questions, never thought it would be so easy. I think i should consider taking it this time

>

> Tob

Rob, when was your name changed to Tob?

[Former Member]

>

> Rob, when was your name changed to Tob? 

It's my alter (friendly) ego

Tob

[Former Member]

Does that mean no one's gonna help me??? Guys I just need a simple "A B C D" no explanation required.

Edited by: Nandesh Nair on Oct 23, 2009 8:37 PM

[Former Member]

>

> no explanation required.

So you don't care about the reasons behind the answers; you just need the answers?

Rob

[kesavadas_thekkillath]

what to do nandesh ... Rob is watching

[Former Member]

Hello Nandesh,

You are quite lucky that our friendly Tob hasn't yet locked this thread This may even end up in coffee corner for more funny answers. If you had read the forum rules you must have realized that you will not be getting your intended replies for these kind of questions.

Vikranth

[Former Member]

If some gives me the right options then I can search over the internet and find out the explanation myself. I tried solving these questions but I have doubts. I don't think someone would have the time and patience to give the explanation for each question. So, I request someone to post the correct options atleast. I have my certification examination next month. So please help me.

[Former Member]

then just ask your doubts.. that will be clarified very neatly..

but as per forum rules no body is going to pass you the a b c d e ...

[former_member191735]

Ohh... Read sap help and use your ABAP system.... you will find answer for every question

[Former Member]

A: UPDATE
B: MODIFY
C: DELETE
D: INSERT
E: LOCKED
F: FLAMED

I would normally have gone for E, but since there is no global lock we can use C for single posts and F for single comments...

[Clemenss]

Hi Nandesh,

it is OK that someone sent you to training after your first question

Please have mercy with SAP community for not giving the answers - we just don't know them.

Clemens