Wednesday, May 14, 2008

IBM abap interview Questions phase - A

Memory Management

1.

How to use the new two-part roll area?

- Some data must be held in roll area and must be rolled into and out of work processes. Roll area must not drop below a minimum size. In two part roll area implementation, you can limit amount of data in roll area before extended memory is used remaining portion of roll area is used only if no further extended memory can be allocated to a user context.

DICTIONARY

1.

What is a dictionary?

- Dictionary contains Meta data or information for the data in data management system.

- It supports redundancy free data storage and data integrity.

2.

Primary Key – field or combination of fields used to uniquely identify a row of the table

3.

Foreign Key - Combination of fields in a table acting as a primary key in another table.

4.

Difference between structure and a Table ?

Ans - Using tables, data can be stored permanently in Database, and Structures contain no data.

5.

Define Structures ?

Ans - Structures are used for example in ABAP programs to define internal tables or to define the type of the interface parameters of function modules.

6.

Table attributes – Determine who is responsible for maintaining the table and which type of access is allowed for the table e.g.: Delivery class – table maintained by sap or customer.

Table maintenance allowed – Table entries accessed using std table maintenance.

Activation Type – Whether table can be activated directly from ABAP/4 dictionary or whether the runtime object must first be generated by c program.

7.

Database Utility – Interface between ABAP/4 Dictionary and the database.

8.

Data Elements – Describe the role played by a field in technical context. Fields of same semantic meaning refer same data elements.

9.

Domain – describe technical characteristics of a table field. It specifies the value range, which describes allowed values for a field.

10.

Index – Copy of database table reduced to specific fields

Function – speed up scanning of table for data records satisfying a given search criteria.

11.

Foreign key Table – Table which contains the foreign key. E.g. ZEMP table.

12.

Check Table – Table which has foreign key of another table as its primary key e.g. DEPT.

13.

Cardinality – N: M indicates how many dependent record or referenced records.

14.

View :- used to summarize data distributed among different tables type of views

15.

Types of Views

1 Database – created in database (read only)

2 Projection - used to suppress the display of table fields (all operations possible)

3 Help views – Display information in online help system

- 4 Maintenance views – used to realize commercially relevant views on data customizing vies business oriented approach to looking at data

16.

Views that cannot be used to create new views

- Structure views – used to generate a structure from several logically connected tables

- Entity views – used to represent entity type of Data Modular on tables of ABAP/4 dictionary

17.

Maintain Status – Determine if records can only be read or if it is also possible to change them.

18.

Match codes – tool to help you search for data records in the system

19.

Match codes object – describes the set of all possible search paths for the search term.

20.

Match codes Id – describes a special search path for a search term.

21.

Match codes

- fields from several tables

- built on the basis of transparent tables, clusters and pools

- restricted by stipulating selection conditions

- use as entry aids

Database index

- fields from only table

22.

Lock Objects – simultaneous access of records by two users synchronized by lock objects.

23.

Activation – During activation, the runtime object of aggregate object or tables is created. The runtime object is buffered so that the application program can access it quickly. Runtime object has information about the following objects of table

- domain – data elements – field definition – table definition

No comments:

Tutorials on SAP-ABAP

Adobe Interactive Forms Tutorials

Business Server Pages (BSP)

Userexits/BADIs

Web Dynpro for ABAP (Step by step procedure for web dynpro,Tutorials on Web Dynpro,)

ALV Tutorials

goodsites