Interview Questions

In a SQL Database, a 'correlated subquery' is a kind of sub query yet connected subquery is dependent on another query for a value that is returned. In case of execution, the sub query is executed first and afterwards the correlated query will be executed.

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>

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

The System.Collections namespace contains all the collection classes.

There are three ways to integrate CSS into a Web page 

1. Inline: HTML elements may have CSS applied to them via the STYLE attribute.

2. Embedded: By placing the code in a STYLE element within the HEAD element.

3. Linked/ Imported: Place the CSS in an external file and link it via a link element.

SSIS, SSAS and SSRS are the most important reporting systems that BI professionals work with. On a detailed level, I have worked with data mining, master data management, data profiling and data cleansing and analysis.

Information provided by Assembly Manifest:

1.  Assembly Name


2.  Version Number


3.  Culture


4.  Strong name


5.  List of files inside the assembly


6.  Reference information

A data warehouse is a relational database that is designed for query and analysis rather than transaction processing. It usually contains historical data that is derived from transaction data, but it can include data from other sources. Data warehouses are designed to help you analyze your data.