Interview Questions

Use SELECT DISTINCT ..... in DB2 query

The DISTINCT keyword can be used to return only distinct (different) values.

Syntax:

     SELECT DISTINCT column1,column2

      FROM table_name;

This command is used when a large processing of data has occurred. If any large amount of deletions, any modifications, or Bulk Copy into the tables has occurred, it has to update the indexes to take these changes into account. UPDATE_STATISTICS updates the indexes on these tables accordingly.

In Visual Basic, the basic syntax of a LINQ query starts with the From clause and ends with the Select or Group By clause. In addition, you can use the Where, Order By, and Order By Descending clauses to perform additional functions, such as filtering data and generating the data in a specific order.

In C#, the basic syntax of a LINQ query starts with the From clause and ends with the Select or group by clause. In addition, you can use the where, orderby, and Orderby descending clauses to perform additional functions, such as filtering data and generating the data in a specific order.

In the light of competition, it may be seen that competitors may initiate price changes. If the cutting off on prices does not affect the company, then the current pricing strategy itself can be continued to maintain the profitability of the company. However if the price change on one firm is affecting the other, then it can:

a.reduce the product price at par with competitors’ price or below competitors’ price

or

b. Provide added advantage to the existing product like better quality, or ‘a buy one get one free’ offer.

or

c.Provide better quality of the product at a higher price thereby not being at par with the competitors.

CURSOR STABILITY:

- CS is a row level locking

- Acquires an exclusive lock on the row that is to be updated

- When the control is moved to the next updatable row, the lock is released

REPEATABLE READ:

- RR is a page level locking

- Acquires an exclusive lock on the entire page which is the source of row availability

- When the control is moved to the next updatable page the lock is released

6 months after graduating or quitting school when you have to start paying back the loans.

A grace period is one term that’s provided for student loans that allow you to delay payments up to a certain length of time, without penalty. During a grace period no late charges would apply, and the loan would not risk falling into default for missed payments. The grace period allows you time to find financial stability prior to having to make payments on your student loans.

Many students use student loans to help pay for their college expenses, including tuition, books, room and board, and other living expenses. Students are expected to repay these loans when they graduate.

SELECT * FROM table_name ORDER BY column_name desc Fetch first 5 rows only;

Quality Assurance (QA): QA refers to the planned and systematic way of monitoring the quality of process which is followed to produce a quality product. QA tracks the outcomes and adjusts the process to meet the expectation.

Quality Control (QC): Concern with the quality of the product. QC finds the defects and suggests improvements. The process set by QA is implemented by QC. The QC is the responsibility of the tester.

Software Testing: is the process of ensuring that product which is developed by the developer meets the user requirement. The motive to perform testing is to find the bugs and make sure that they get fixed.