Technology Questions

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.

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.

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.

Dashboards are real-time business intelligence interfaces. They allow a huge amount of data to be read in a single interface in order to analyse the success or failure of the business or project in question

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

The System.Collections namespace contains all the collection classes.

State is quite an innovative concept in Web development because it eliminates the drawback of losing state data due to reloading of a Web page. By using states in a Web application, you can preserve the state of the application either at the server or client end. The state of a Web application helps you to store the runtime changes that have been made to the Web application. For example, as already described earlier, a change in the data source of the Web application might be initiated by a user when he/she selects and saves some products in the shopping cart.

If you are not using states, these changes are discarded and are not saved. You may think that the whole concept of storing states is optional. However, under certain circumstances, using states with applications is imperative. For example, it is necessary to store states for Web applications, such as an e-commerce shopping site or an Intranet site of a company, to keep track of the requests of the users for the items they have selected on the shopping site or the days requested for vacation on the Intranet site.