Interview Questions

Both these are used to combine the results of different SELECT statements.

    UNION       - Selects only distinct values 

    UNION ALL - Selects duplicate values also

Syntax:

    SELECT column_name(s) FROM table1

    UNION / UNION ALL

    SELECT column_name(s) FROM table2;

Notice that each SELECT statement within the UNION must have the same number of columns. The columns must also have similar data types. Also, the columns in each SELECT statement must be in the same order.

Cache events are processed only when the Postback events occur

1) List down usecases (taken from business cases) from function specs. For each use case write a test case and categorize them into sanity tests, functionality, GUI, performance etc. Then for each test case, write its workflow. 

2) For a GUI application - make a list of all GUI controls. For each control start writing test cases for testing of the control UI, functionality (impact on the whole application), negative testing (for incorrect inputs), performance etc.  

Yield to maturity is a concept for fixed rate bonds and is the internal rate of return i.e. the rate at which future flows are discounted on a compound basis to give the present value of the bond including accrued interest.

Secondary market refers to market where securities are traded after being initially offered to the public in the primary market and/or listed on the stock exchange.

Capital Gains Tax on Property:

1. Short term,

2. Long term

Short Term Capital Gain on property is considered as a gain from selling a property which was held by you for less than 36 months. As a taxpayer, you are liable to pay tax on short term capital gain on property as per your applicable marginal income tax slab.

* Current Short Term Capital Gains tax rate is 30%.

Long Term Capital Gain

When you sell your property that is owned by you for more than three years, any gain arising from such sale will be considered as long term capital gain. Long term capital gain is calculated as the difference between net sales consideration and indexed cost of property.

* Current Long Term Capital Gains tax rate is 20%.

End of file  (10)

Duplicate key (22)

Record not found (23)

VSAM logic error  (90)

Open problem  (92)

Space problem (93)

One of the interview questions you may be asked is what you are looking for in your next job. The interview wants to know whether your goals are a match for the companies needs.

You can begin your answer with this question: Tell me, Mr./Ms. Interviewer, what is a typical career path at OPL for someone with my skills and experience?

(Based on the answer you can then respond to the original question using the phrases from the answer to frame your response).

What is important to you? Two things are very important to me. One is my professionalism at work; the second is my family life.