IT Interview Questions

Where do u code the HIDE statement?

Ans      In a LOOP statement

 

Types of BDC’s?

Ans      There are two types of BDC’s:

1)      Transaction Method

2)      Session Method

 

Advantages & Disadvantages of different types of BDC’s?

Ans      Transaction Method:

1)      It is faster than session method.

2)      While executing, it starts from starting.

 

Session Method:

1)      It is slower than transaction method.

2)      While executing, it does not start from starting.

 

What are the events used in Interactive Reports.

1) What is SAP R/3?
Ans.  SAP R/3 refers to Systems Application and Product for data processing Real-time having a 3 tier architecture i.e. Presentation layer, Application layer and Database layer.

2) What are the programming standards followed?

3) What are the contents in technical specifications?
Ans.  There are five contents in Technical Settings: Data Class, Size Category, Buffering Permission, Buffering Type and Logging.

4) What is an instance?
Ans.  When you call a function module, an instance of its function group plus its data, is loaded into the memory area of the internal session. An ABAP program can load several instances by calling function modules from different function groups.

11) Can u print decimals in type N? What is difference between float and packed data type?
Ans.  No, we cannot print decimals in type N because decimal places are not permitted with N data type.
     Float Data Type: It cannot be declared in Parameters.

     Packed Number: It can be declared in Parameters. For e.g.

     PARAMETERS : A(4) TYPE P DECIMALS 2,

    B(4) TYPE P DECIMALS 2.

     DATA : C(4) TYPE P DECIMALS 2.

   C = A + B.

    WRITE : / ‘THE SUM IS’ , C.

1. What is a Cartesian product? What causes it?

Expected answer:
A Cartesian product is the result of an unrestricted join of two or more tables. The result set of a three table Cartesian product will have x * y * z number of rows where x, y, z correspond to the number of rows in each table involved in the join. It is causes by specifying a table in the FROM clause without joining it to another table.

2. What is an advantage to using a stored procedure as opposed to passing an SQL query from an application.

• What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
  • Cursors allow row-by-row processing of the resultsets. Types of cursors: Static, Dynamic, Forward-only, Keyset-driven. See books online for more information. Disadvantages of cursors: Each time you fetch a row from the cursor, it results in a network roundtrip, where as a normal SELECT query makes only one roundtrip, however large the resultset is. Cursors are also costly because they require more resources and temporary storage (results in more IO operations). Further, there are restrictions on the SELECT statements that can be used with some types of cursors. Most of the times, set based operations can be used instead of cursors. Here is an example: If you have to give a flat hike to your employees using the following criteria: Salary between 30000 and 40000 — 5000 hike Salary between 40000 and 55000 — 7000 hike Salary between 55000 and 65000 — 9000 hike. In this situation many developers tend to use a cursor, determine each employee’s salary and update his salary according to the above formula. But the same can be achieved by multiple update statements or can be combined in a single UPDATE statement as shown below: