Interview Questions

The business analyst must understand IT and also has to understand the stakeholder’s needs. 

A systems analyst has the ability to look at a program or utility and see the code. They can go in and pinpoint where changes need to be made. 

Oracle constraints are used to maintain consistent of data and ensure the data is properly maintained. A constraint is more or less a restriction we try to apply on a table.
Types of constraints:
- Check constraints
- NOT NULL constraint
- PRIMARY KEY constraint
- REFERENCES constraint
- UNIQUE constraint

mysql_fetch_array:
Fetch a result row as an associative array and a numeric array.

mysql_fetch_object:
Returns an object with properties that correspond to the fetched row and moves the internal data pointer ahead. Returns an object with properties that correspond to the fetched row, or FALSE if there are no more rows.

mysql_fetch_row():
Fetches one row of data from the result associated with the specified result identifier. The row is returned as an array. Each result column is stored in an array offset, starting at offset 0.

Aggregate functions perform a calculation on a set of values and return a single value. Aggregate functions ignore NULL values except COUNT function. HAVING clause is used, along with GROUP BY, for filtering query using aggregate values.

Following functions are aggregate functions. 

AVG, MIN CHECKSUM_AGG, SUM, COUNT, STDEV, COUNT_BIG, STDEVP, GROUPING, VAR, MAX. VARP

echo() and print() are language constructs in PHP, both are used to output strings. The speed of both statements is almost the same.

echo() can take multiple expressions whereas print cannot take multiple expressions.

Print return true or false based on success or failure whereas echo doesn't return true or false.

The .Net runtime knows about all the references between the objects. It can identify all the circular references that are reachable from the root and hence finalize them to free them all at once if and when needed.

When responding to conflict resolution questions, answer with confidence since you're being considered for a supervisory position where you will frequently be required to work in teams, delegate responsibilities, and handle difficult problems.

The following is an effective way to answer conflict resolution questions:

Before proposing a solution, I collect all relevant facts surrounding the conflict. Conflicts are often resolved if sufficient time is devoted to determining root causes, while disregarding trivial or irrelevant facts.

An effective answer can also be supplemented with the following response:

When resolving a problem between employees, I serve as a neutral third party. When needed, I establish rules of conduct. For an organization to operate efficiently, employees must be on the same page. At most organizations, bad feelings exist among some employees, so a manager is responsible for ensuring that employees are placed in situations where they're comfortable to focus on their job responsibilities. In other words, employees must be situated around others they can work with so productivity is not affected.