Interview Questions

Shared pool in oracle contains cache information that collects, parses, interprets and executes SQL statements that goes against database. This shared pool acts like a buffer for these SQL statements.

The main differenc between View and Materialized View states that -

1. View means it stores the SQL statement in the database and let you use it as a table. Everytime you access the view, the SQL statement executes.

2. Materialized view means it stores the results of the SQL in table form in the database. SQL statement only executes once and after that everytime you run the query, the stored result set is used. Advantage include quick query results.

As a consultant , I would:

• Recommend structuring of the marketing department as per the demands of the different tasks, roles and responsibilities keeping in mind the cost(budget) factor as long as it fits within the budget of the company.

• Finding out and establishing the level of skills, duties and responsibilities of the employees via job descriptions and job specifications.

• Proper and regular supervision of the department to ensure its smooth functioning

• Determine the marketing functions of the department as per the requirements (advertising,distribution channels,promotional activities)

Steps to step through the code in .NET:

1. Start the program in debug mode.


2. When the first breakpoint is reached then step through can be done in one of the two ways:

•  Press F10 to move to next line.


•  Select debug menu and click on step over. This would step over the breakpoint to next level.

       3. Other options are: “Step Into” and “Step Out”.

An abnormal situation during execution of a CICS command is called an exceptional condition:

1. Handle Condition Command: It is used to transfer control to the procedure label specified if the exceptional condition specified occurs.

2. Ignore Condition Command: It causes no action to be taken if the condition specified occurs in the program. That is control will be returned to the next instruction following the command which encountered the exceptional condition.

3. No Handle Option: This option can be specified in any CICS command and it will cause no action to be taken for any exceptional condition occurring during execution of this command.

4. RESP Option: This option can be specified in any CICS command. If the RESP option is specified in a command, CICS places a response code at a completion of the command. The application program can check this code, then proceed to the next processing.

The synchronized keyword indicates that a method can be accessed by only one thread at a time

The repayment of the loan by instalment to cover principal amount with interest is known as ‘Amortization’.

SE01 is the main screen of the Change and transport Organizer. From here the administrator can acheive all tasks related to transport requests - such as create, change, view logs, display client/delivery transports, etc. SE09 and SE10 can also be accessed from here. However, not all developers might be granted access to this transaction.

SE09 is the workbench transport requests transaction - here the developers can track changes to all ABAP workbench objects (dictionary, reports, module pools, etc). This is a developer-specific transaction and mostly all developers have access to this transaction.

SE10 is the customizing request display transaction - this displays all the customizing requests in the system. Again, this could be restricted to Business analysts if required, since they would be doing most of the customizing changes in the system.