Technology 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.

ASP.NET is a specification developed by Microsoft to create dynamic Web applications, Web sites, and Web services. It is a part of .NET Framework. You can create ASP.NET applications in most of the .NET compatible languages, such as Visual Basic, C#, and J#. The ASP.NET compiles the Web pages and provides much better performance than scripting languages, such as VBScript. The Web Forms support to create powerful forms-based Web pages. You can use ASP.NET Web server controls to create interactive Web applications. With the help of Web server controls, you can easily create a Web application.

Dimensional modeling is often used in Data warehousing. In simpler words it is a rational or consistent design technique used to build a data warehouse. DM uses facts and dimensions of a warehouse for its design. A snow and star flake schema represent data modeling.

Because SALARY is not declared to have NULLs and the employees for whom the salary is not known are also counted.

For both client server and web based applications, the testing is the same except one thing: We test web based applications in different browsers, for example, Internet Explorer (will test in different versions like IE 5.0, IE 6.0, IE 7.0), Firefox, Safari (for Mac) and so on where as for client server, we don’t need to test in the browsers.

Advantages      : More efficient and quality of service is better.

Dis advantages: Expensive, complicated

Executing more than one program simultaniously.(i.e at time)

Ex:

Windows media player  is a program

Internet explorer(IE) is another program executing both the programs  at a time is called multi tasking.

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.