Interview Questions

In a correlated query, the outer query is related to the inner query. This means one or more columns in the outer query are referenced. It’s used when the outer queries value is being used by inner query. For example, we need to find which employee had more perks in the current month than they did in the previous month. The correlated subquery is executed for each row of perks information in the parent query to first determine what the perks were for each employee in the previous month. This data, in turn, is compared to perks for each employee in the current month, and only those employees whose perks in the current month were greater that their previous month's perks are returned.

Canvas is an element that is used for the graphics for the web page. It uses JavaScript to bring the graphics functionality live. It allows easy way to draw the graphics and use different types of tools to create drawing on the web page. Canvas is just a rectangular area that controls the pixel of every element that is used in the web page. Canvas uses methods like paths, circles, etc. The canvas element will be used as follows:

<canvas id="can" width="200" height="100"></canvas>

The canvas element includes id, width and height settings and with the javascript it gets used like:

<script type="text/javascript">

var c=document.getElementById("can");

var ctx=c.getContext("2d");

ctx.fillStyle="#FF0000";

ctx.fillRect(0,0,150,75);

</script>

We can tune the report by using index awarness in universe

To make an image draggable, the draggable attribute is set to true:

<img draggable="true">

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.

Open Market Operations (OMO) refer to the buying and selling of government securities in the open market in order to expand or contract the amount of money in the banking system.

An index is a object which is used to improve performance during retrieval of records.

CREATE [UNIQUE] INDEX index_name 

ON employee[emp_id, emp_name,dept_id]

[COMPUTE STATISTICS]

The UNIQUE keyword is used when combined values of the index should be unique.

The COMPUTE STATISTICS during the creation of index optimizes the plan of execution of the SQL statement and improves performance.