|
ABAP CERTIFICATION QUESTIONS
Questions 1. When using Open SQL statements in an ABAP/4 program,
you must ensure the following. a) The database system being addressed must be supported
by SAP. b) The database tables being addressed must be defined
in the ABAP/4 dictionary. c) Both a and b d) None Ans. c ____________________________________________________________________________ 2. Which of the following statements are correct? a) A database interface translates SAP’s Open SQL
statements into SQL commands specific to the database in use. Native SQL statements
access the database directly. b) When you use Native SQL, the addressed database
tables do not have to be known to the ABAP/4 dictionary. In Open SQL, the
addressed database tables must be defined in the ABAP/4 dictionary. c) There is automatic client handling in Native SQL
whereas clients must always be specified in Open SQL. Ans. a,b ____________________________________________________________________________ 3. Which of the following are true? a) TABLE is used as a synonym for STANDARD TABLE b) You can only access a hashed table using the generic
key operations. Explicit or implicit index operations (such as LOOP ... FROM oe
INSERT itab within a c) All hashed tables are index tables. d) We have to define the hash procedure explicitly for
HASHED TABLE. Ans. a, b ____________________________________________________________________________ 4. Can a transparent table exist in data dictionary but
not in the database physically? a)
True b)
False Ans. b _____________________________________________________________________________ 5. Can you create a table with fields not referring to
data elements? a)
Yes b)
No Ans. a _____________________________________________________________________________ 6. How do you create a batch input session for a
transaction? a) ‘Call transaction’ in background mode. b) ‘Call transaction’ in error mode. c) ‘Bdc_insert’ for the transaction. d) None of the above. Ans. c ____________________________________________________________________________ 7. What is the alternative to batch input session? a)
Load module b) Call transaction c) BAPI d) Idoc segment Ans. b ____________________________________________________________________________ 8. The following are true about ‘EXEC SQL’. a) You can end the Native SQL with a semicolon. b) You can end the Native SQL with a period. c) You cannot perform reliable authorization checks
using EXEC SQL. d) Host variables in the Native SQL are identified with
a preceding hash (#). Ans. a, c ____________________________________________________________________________ 9. The following are true about database locking. a) Database systems set physical locks on all lines
affected by a database call. b) Read locks prevent the setting of further read locks
for the objects in question. c) Read locks prevent other transactions from setting
write locks for the objects in question. d) Write locks allow other transactions to set read
locks for the objects in question. Ans. a, c ____________________________________________________________________________ 10. What are field symbols? a) Field symbols are like pointers in C that can point
to any data object in ABAP/4 and to structures defined in ABAP/4 dictionary. b) Field symbols have to be created with type
specifications only. c) You cannot assign one field symbol to another. d) All operations you have programmed with the field
symbol are carried out with the assigned field. Ans. a, d ____________________________________________________________________________ 11. EXTRACT statement a) The first EXTRACT statement extracts the first
extract record. b) The first EXTRACT statement creates the extract dataset
and adds the first extract record. c) Each extract record contains, if specified, the
fields of the field group. d) Each extract record contains, if specified, the
fields of the field symbol. Ans. b, c ____________________________________________________________________________ 12. You cannot assign a local data object defined in a
subroutine or function module to a field group. a)
True b)
False Ans. a ____________________________________________________________________________ 13. Which of the following are true? a) COLLECT can only be used with STANDARD TABLE. b) To use COLLECT, the internal table should be derived
from a database table with an explicit key. c) If the system finds a numeric component, that is not
part of the key, the numeric fields that are not part of the table key (see
ABAP number types) are added to the sum total of the existing entries. If it
does not find an entry, control passes on to the next record in the internal
table. d) If the system finds a numeric component, that is not
part of the key, the numeric fields that are not part of the table key (see
ABAP number types) are added to the sum total of the existing entries. If it
does not find an entry, the system creates a new entry instead. Ans. d _________________________________________________________________________ 14. Which of the following are true? a) ABAP queries are created by associating them to a
logical database or through a direct read/data retrieval program. b) ABAP queries are created from functional areas that
are created from a logical database or through a direct read/retrieval program. c) ABAP queries are created from user groups attached to
the functional areas that are created from a logical database or through a
direct read/retrieval program. d) ABAP queries are created through the regular report
program. Ans. c ____________________________________________________________________________ 15. A logical unit of work (LUW or transaction) begins a) Each time you start a transaction. b) Each time you end a transaction. c) When the database changes of the previous LUW have
been confirmed (database commit). d) Before the database changes of the previous LUW have
been cancelled (database rollback). Ans. a, d. ____________________________________________________________________________ 16. A database commit is triggered by a) ABAP/4 command COMMIT WORK. b) CALL SCREEN, CALL DIALOG. c) A Remote Function Call d)
CALL TRANSACTION Ans. a, b, c, d ____________________________________________________________________________ 17. The following are true about SAPscript control
commands. a) If a control command is unknown or it contains syntax
errors, the line containing it will be printed out as it is. b) If a control command is unknown or it contains syntax
errors, the line containing it will be treated as a comment line. c) A maximum of one control command may appear in each
line. d) A maximum of six control commands may appear in each
line. Ans. b, c ____________________________________________________________________________ 18. To output SAPscript layout sets, in the print program a) You must always start the output with OPEN_FORM and
end it with CLOSE_FORM. b) Within one transaction, you can use only one
OPEN_FORM and CLOSE_FORM to open and close a layout set. c) WRITE_FORM should be used within an OPEN_FORM and
CLOSE_FORM. d) WRITE_FORM can be used without an OPEN_FORM and CLOSE_FORM. Ans. a, c ____________________________________________________________________________ 19. The transaction CMOD and SMOD are a) Used to create enhancements to standard SAP programs. b) Used to create enhancements to ABAP queries. c) Used to create the user exits, menu exits and screen
exits. d) Used to modify the standard function groups. Ans. a, c ____________________________________________________________________________ 20. Which of the following are tools to report data in
ABAP? e) ALV f)
ALE g) LSMW h) SmartForms Ans: a ____________________________________________________________________________ 21. ABAP Query tool is used to: a) Enquire about a running-program status b) Automatically generate code for reporting c) Perform database operations for user-written programs d) None of the above Ans: b. ____________________________________________________________________________ 22. In ABAP Query tool... e) Each user can be assigned to several user-groups f)
Each user can be
assigned to several functional areas g) Each functional area can be assigned to several
user-groups h) One user can be assigned only to one user-group. Ans: a, b, c ____________________________________________________________________________ 23. Logical databases must be used to create an ABAP
Query a) True b) False Ans: b ____________________________________________________________________________ 24. In a BDC program, how would you handle errored
records? Would you… a) Rerun the program b) Report the errored records c) Generate a batch-input session with errored records d) Create an output file, to be run again after
corrections Ans: b, c, d ____________________________________________________________________________ 25. What are IDocs? a) Documentation of executable programs b) Documents used for data-transport between SAP and
non-SAP s/w. c) Documents used for data-transport between two
different SAP systems d) Documents used for one-time data-migration
activities. Ans: b, c ____________________________________________________________________________ 26. For transportation of data from a presentation server
into SAP, the function module used is a) UPLOAD b) WS_UPLOAD c) FILE_UPLOAD d) DATA_UPLOAD Ans: a, b ____________________________________________________________________________ 27. For one-time high volume data-uploads into SAP from
non-reliable systems, the following are generally used: a) BDC b) LSMW c) Direct table update d) Idocs Ans: a, b ____________________________________________________________________________ 28. In an ABAP program, the INITIALIZATION event is
invoked a) Before the AT-SELECTION-SCREEN event b) After the AT-SELECTION-SCREEN event c) Could be either way d) Cannot be predicted Ans: a ____________________________________________________________________________ 29. The statement to check whether an internal table
itab_test has no records, is: IF
itab_test is initial. a) TRUE b) FALSE Ans: b. ____________________________________________________________________________ 30. The statement used to clear all the contents of an
internal table is: a) CLEAR itab. b) REFRESH itab. c) FREE itab. d) DELETE itab. Ans: b, c ____________________________________________________________________________ 31. The AT-SELECTION-SCREEN event is triggered when… a) ENTER key is hit on the selection-screen b) F8 key is hit on the selection-screen c) Any field on selection-screen is populated d) F4 key is hit on the selection-screen Ans: a, b ____________________________________________________________________________ 32. What is the transaction-code for viewing batch-runs
of a program? a) SE37 b) SM37 c) SM35 d) SM30 Ans: b ____________________________________________________________________________ 33. SY-BATCH can be used to determine whether a program
is being run in batch-mode, within the AT-SELECTION-SCREEN event. a) TRUE b) FALSE Ans: b ____________________________________________________________________________ 34. The following statements will clear the header-line
of an internal table: a) DELETE ITAB. b) FREE ITAB. c) REFRESH ITAB. d) CLEAR ITAB. Ans: d ____________________________________________________________________________ 35. The SAP Logon password is always case-insensitive. a) TRUE b) FALSE Ans: b ____________________________________________________________________________ 36. Data: BEGIN OF ITAB OCCURS 0, FIELD1(10), FIELD2(10), END OF ITAB. DO 20 TIMES. ITAB-FIELD1 = ‘Field1’. ITAB-FIELD2 = ‘Field2’. ENDDO. a) The internal table has 20 entries. b) The internal table has one entry. c) The internal table has no entry. d) Unpredictable. Ans: c ____________________________________________________________________________ 37. READ TABLE ITAB_TEST WITH KEY VBELN = k_vbeln. If multiple records in table ITAB
satisfy the condition, then a) All records are fetched b) The last record is fetched c) The first record is fetched d) Compilation error Ans: c ____________________________________________________________________________ 38. If ITAB has 1000 entries, and DBTAB is a large table,
which is better in terms of performance? i)
LOOP AT ITAB. SELECT
* INTO ITAB_2 FROM DBTAB WHERE KEY1 = ITAB-KEY1. APPEND
ITAB_2. ENDSELECT. ENDLOOP. ii)
LOOP AT ITAB. SELECT
* INTO TABLE ITAB_2 FROM DBTAB WHERE KEY1
= ITAB-KEY1. ENDLOOP. iii)
SELECT * INTO
TABLE ITAB_2 FROM DBTAB FOR ALL
ENTRIES IN ITAB WHERE KEY1 = ITAB-KEY1. a) (i) is better than (ii), and (ii) is better than
(iii). b) (ii) is better than (iii), and (iii) is better than
(i). c) (iii) is
better than (i) and (i) is better than (ii). d) (iii) is better than (ii) and (ii) is better than
(i). Ans: d ____________________________________________________________________________ 39. DATA: BEGIN OF ITAB OCCURS 0, Fld1 (1), Fld2 (1), Fld3 (1), END OF ITAB. ITAB has 5 records – [ (1,1,1), (1,1,2),
(1,2, 2), (2,2,2), (2,2,3) ]. The code segment: LOOP
AT ITAB. AT NEW fld3. WRITE fld3. ENDAT. ENDLOOP. Produces the output: a) 1 2 2
2 3 b) 1 2 3 c) 1 1 2
2 2 d) 1 1 1
2 2 Ans: a ____________________________________________________________________________ 40. TYPES: BEGIN OF TYPE1, FLD1, FLD2, FLD3, END OF
TYPE1. DATA: ITAB1 TYPE STANDARD TABLE OF
TYPE1. ITAB1-FLD1 = ‘a’. ITAB1-FLD2 = ‘b’. ITAB1-FLD3 = ‘c’. APPEND
ITAB1. a) The table has one record, with values (a, b, c ). b) The table has no records. c) Compilation error due to method of declaration of
type. d) Compilation error due to method of declaration of
table. Ans: d ____________________________________________________________________________ 41. The fastest way to read a value in an internal table
is to: a) Specify key, and do a binary search b) Specify the table-keys c) Directly specify the index value d) Use a work-area with same structure as the internal
table. Ans: c ____________________________________________________________________________ 42. If COLLECT is used on an internal table, which has a
non-key character field, a) The first record’s value is used in the collected
version. b) The last record’s value is used in the collected
version. c) Compilation error d) Cannot be predicted Ans: c ____________________________________________________________________________ 43. Which is the correct syntax for sorting an internal
table? a) SORT ITAB USING key1 key2. b) SORT ITAB BY key1 key2. c) SORT ITAB WITH key1 key2. d) SORT ITAB key1 key2. Ans: b ____________________________________________________________________________ 44. If we need to fetch all database entries
corresponding to a given key, X records at a time, the syntax to be
used is: a) SELECT…PACKET SIZE X…. b) SELECT…PACKAGE SIZE X… c) SELECT…UPTO X RECORDS…. d) This facility is not available in ABAP. Ans: b | ||||