ABAPTM Interview Questions
Thanks to all contributors for these questions.
Previous..
31. Two internal tables are equal if
a) Internal tables cannot be compared for equality
b) It has same number of lines
c) Each pair of corresponding lines is equal
d) A and B both
32. Which of the following will happen if you write ‘DELETE itab’ statement in your program?
a) All entries of Internal table will be deleted
b) Only the header line will be deleted
c) The row corresponding to header line will be deleted from the internal table
d) The program will give syntax error.
33. Which of the following statements is/are syntactically correct?
a) PERFORM sub1 TABLES itab
CHANGING var1.
b) PERFORM sub1 CHANGING var1
TABLES itab .
c) Both of the above
d) None of the above
34. Which of the following will happen if you write ‘DELETE itab’ statement?
a) All entries of Internal table will be deleted
b) Only the header line will be deleted
c) The row corresponding to header line will be deleted from the internal table
d) The program will give syntax error.
35. Transparent table ztable consists of field1 and field2.
Internal Table Itab has structure like ztable.
Which one of the following is the fastest way to fill an internal table given the information above?
a) select * into corresponding-fields of itab
from ztable where field1 = '10'.
b) select field1 field2 into (itab-field1, itab-field2)
from ztable where field1 = '10'.
Append itab.
Endselect.
c) select * into table itab from ztable
where field1 = '10'.
d) select * from ztable
where field1 = '10'.
Move ztable to wa.
Append itab from wa.
Endselect.
36.
data: begin of itab occurs 0,
num1 type I,
num2 type I,
num3 type I,
mark,
end of itab.
Itab entries:
1 2 3 D
2 3 4
3 4 5 D
4 5 6 D
7 8 9 d
7 8 9 D
Delete from itab where mark eq 'D'.
Given the ITAB entries, what are the contents of ITAB after executing the above code?
a) 2 3 4
3 4 5 D
4 5 6 D
7 8 9 d
7 8 9 D
b) 1 2 3 D
2 3 4
3 4 5 D
4 5 6 D
7 8 9 d
c) 2 3 4
7 8 9 d
d) 2 3 4
Which of the following statements define internal tables with a header line?
a) Data: Begin of itab occurs 0,
field1,
End of itab.
b) Data: Itab1 like itab occurs 0.
c) Data: Itab1 type itab occurs 0.
d) Data: Begin of itab1 occurs 0.
Include structure itab.
Data: End of itab1.
37.
DATA: BEGIN OF ICODE OCCURS 0,
FIELD1(5),
FIELD2(5),
END OF ICODE.
The internal table icode contains the following entries:
Field1 Field2
------- ------
John 12345
Alice 23478
Sam 54321
john 50000
READ TABLE ICODE WITH KEY FIELD1 = 'John' BINARY SEARCH.
Why does executing the above code return a sy-subrc of 4?
a) The internal table has an incorrect structure.
b) Icode-field2 must be a numeric field.
c) Both internal table fields must be used in the search.
d) The internal table must be sorted first.
38. 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.
39.
data: begin of itab occurs 0,
field1,
end of itab.
Do 3 times.
Append initial line to itab.
Append 'X' to itab.
Enddo.
Describe table itab.
Write: sy-tfill.
What is the value of sy-tfill after executing the above code?
a) 1
b) 2
c) 3
d) 6
40. Loop at itab.
Write itab.
Endloop.
From where is the written line derived in the above loop statement?
a) The table header
b) The table work area
c) sy-index
d) sy-lisel
41.
DATA TEXT(72).
DATA CODE LIKE TABLE OF TEXT.
TEXT = 'This is the first line.'.
APPEND TEXT TO CODE.
TEXT = 'This is the second line. '.
APPEND TEXT TO CODE.
TEXT = 'This is the third line.'.
APPEND TEXT TO CODE.
WRITE 'not' TO CODE+8 INDEX 3.
WRITE 'modified line.' to code+12 INDEX 2.
LOOP AT CODE INTO TEXT.
WRITE / TEXT.
ENDLOOP.
What is the result of the above code after execution?
a) This is the first line.
This is the modified line.
This is not the third line.
b) This is the first line.
This is the modified line.
This is not third line.
c) This is the first line.
This is the modified second line.
This is not third line.
d) This is the first line.
This is the second line.
This is the third line.
ABAP/4 Data Dictionary
42. Can you create a table with fields not referring to data elements?
a) Yes
b) No
c) Not Applicable
d) Not Applicable
43. Which transaction code is used for deleting entire table contents?
a) SE17
b) SE30
c) SE14
d) SE09
44. Which of the following are true?
a) Pooled tables can be used to store control data like screen sequences, program parameters etc.
b) Several cluster tables are stored in one corresponding table on the database.
c) Both
d) None
45. Which database object is used for storing the system variables?
a) SYST table
b) SYST structure
c) SYSTEM table
d) SYSTEM structure
46. What makes a text table?
a) The type of foreign key field defined must be “No Key/Candidates”
b) The key of the text table consists of the key of the check table plus an additional language key
c) Cardinality must be defined as 1:1
d) The table has to be client independent
47. From the list below which is not a data class in the Dictionary?
a) Master Data
b) Organizational Data
c) Project Data
d) System Data
48. Identify the case where table buffering is set to off.
a) When the most current data is required
b) When the most current data is not required
c) Small static tables i.e. tables do not change much
d) b and c
49. When using SAP Buffering on database tables, which statement does NOT result in database access?
a) select distinct..
b) select single..
c) using (Is null) in the where clause
d) using aggregate functions in the select clause
50. A structured type in the ABAP dictionary that has no physical table definition in the underlying database is referred to as :
a) Table
b) Table Type
c) Structured Type
d) Structure
51. When are Dictionary changes made available to a program?
a) Immediately provided object is activated
b) Next time user logs on
c) Next time program is regenerated
d) After Database is re-organized
52. Which of the following do not exist in the underlying database?
a) Transparent Table
b) Structure
c) View
d) Internal tables
53. Full buffering would be appropriate for what type of tables:
a) Small static tables
b) Transaction Tables
c) Tables with generic keys
d) b and c
54. You have added an append structure to a standard SAP table. What happens to the standard table when a new version of table is imported during an SAP version upgrade:
a) The standard table is returned to standard. Therefore, the append structure must be manually re-applied
b) The append fields are automatically appended to the table upon activation but you must still convert the table
c) All append structures are deleted. A new append structure must be created and added to the standard table
d) When the standard tables are activated, the append structure is automatically added to the standard table
55. Which of the following are TRUE for SQL trace utility (tcode ST05) in SAP -
a) SQL trace utility traces database access for a specific program
b) SQL trace utility traces database access for all transactions by a specific user
c) SQL trace result shows details of queries on database tables
d) SQL trace result can show details of queries on internal tables
56. A table ztest has the following secondary index: tnum, tcode.
Select * from ztest where tnum ne '123' and tcode = '456'.
Why does a SQL trace confirm that the secondary index is NOT used in the code above?
a) Client is not in the where clause
b) NE invalidates the use of an index
c) Variables must be used, NOT literals
d) Indexes are not allowed on Z tables
Batch Data Communication
57. How do you create a batch input session for a transaction?
a) We create a bdc and use ‘call transaction’ in background mode.
b) We create a bdc and use ‘call transaction’ in error mode.
c) We create a bdc and use ‘bdc_insert’ for the transaction.
d) None of the above.
58. What is the alternative to batch input session?
a) Load module
b) Call transaction
c) BAPI
d) Idoc segment
59. Which SAP table stores the BDC session queue information?
a) APQD
b) APQL
c) APQQ
d) APQI
60. Which program can be used to release BDC sessions within a job?
a) RSBDCSUB
b) RSBDCJOB
c) RSSUBBDC
d) BDCRECXX
Previous |
Next
|
