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.  

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.

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.

End of file  (10)

Duplicate key (22)

Record not found (23)

VSAM logic error  (90)

Open problem  (92)

Space problem (93)

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%.

If exception is generated  in try and if that exception is not catch by any catch then finally is executed.

If exception is generated in try and if that exception is caught by one of catch statements then also finally is executed.

if no exception is generated then also finally is executed.