Technology 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

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

- A web page with large number of images takes a longer time to load. This is because each image separately sends out a http request.

- The concept of CSS sprite helps in reducing this loading time for a web page by combining various small images into one image. This reduces the numbers of http request and hence the loading time.

- A clustered index is a special type of index that reorders the way records in the table are physically stored. Therefore table can have only one clustered index. The leaf nodes of a clustered index contain the data pages.

- A non clustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows on disk. The leaf node of a non clustered index does not consist of the data pages. Instead, the leaf nodes contain index rows.

.NET Framework is a complete environment that allows developers to develop, run, and deploy the following applications:

 => Console applications
 => Windows Forms applications
 => Windows Presentation Foundation (WPF) applications
 => Web applications (ASP.NET applications)
 => Web services
 => Windows services
 => Service-oriented applications using Windows Communication Foundation (WCF)
 => Workflow-enabled applications using Windows Workflow Foundation (WF)

The following commands are available for the Program Control services:

LINK: To pass control to another program at the lower level, expecting to be returned. XCTL: To pass control to another program at the same level, not expecting to be returned.

RETURN:  To return to the next higher-level program or CICS. 

LOAD: To load a program. 

RELEASE: To release a program.

When a class is derived from another class, then the members of the base class become the members of the derived class. The access modifier used while accessing members of the base class specifies the access status of the base class members inside the derived class.

The syntax to inherit a class from another class in C# is as follows:
class MyNewClass : MyBaseclass