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.

A web application resides in the server and serves the client’s requests over internet. The client access the web page using browser from his machine. When a client makes a request, it receives the result in the form of HTML which are interpreted and displayed by the browser.

A web application on the server side runs under the management of Microsoft Internet Information Services (IIS). IIS passes the request received from client to the application. The application returns the requested result in the form of HTML to IIS, which in turn, sends the result to the client.

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

PL/SQL exceptions are raised using the RAISE command. This command is used when exceptions are defined by programmer and not implicit exceptions.

Example:

Declare and raising an exception:

DECLARE

short_of_attendance EXCEPTION;

min_attendance NUMBER(4);

BEGIN

...

IF min_attendance < 10 THEN

RAISE short_of_attendance;

END IF;

EXCEPTION

WHEN short_of_attendance THEN

-- handle the error

END;

The System.Collections namespace contains all the collection classes.

Verification: Verification is a process to ensure that the software that is made, matches the original design. In other words, it checks whether the software is made according to the criteria and specification described in the requirement document. It is to check whether you built the product right as per design. It is a low level checking. (It is done in walk-through meetings generally). It checked whether it is made accordingly to the design..

Validation: Validation is a process to check whether the product design fits the client’s need. It checks whether you built the right thing. It checks whether it is designed properly.

READNEXT reads the next record from a browse operation for any of the three VSAM files.