Interview Questions

GROUP BY partitions the selected rows on the distinct values of the column on which you group by. HAVING selects GROUPs which match the criteria specified

I/O operations like reading or writing a file is not possible with client-side javascript. However , this can be done by coding a Java applet that reads files for the script. 

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

ADO or Active X Data objects, allows developers to create applications that can interoperate well with other data application services.

Customer Information Control System (CICS) is an online transaction processing monitor from IBM that acts as an interface between the operating system and application programs to provide rapid high-volume online transaction processing.

A network in which there are multiple network links between computers to provide multiple paths for data to travel.

UNION selects only distinct values whereas UNION ALL selects all values and not just distinct ones