Technical Interview Questions and Answers :: Virtusa

Procedure are used as a script

function are used as a method

procedure can returned zero , single or multiple values

function can returned one value which is mandatory

procedure have input/output parameters

function have input parameter only

procedure can not be used in select statement

function can be used in a select statement

A stored procedure is a set of per-compiled SQL commands (query statements), which are stored in the server. It is faster then the loose SQL statements processed on client, as it is per-compiled. It can execute more then one SQL commands once as they are bundled in a single entity. We can use control statements within the stored procedure, which will allow us to repeat some SQL command. It can send return values depending upon the result. Stored procedures are used to reduce network traffic.

Stack is a sequential datastructure which will follow last in first out (LIFO) rules. The mainly operations of stack are : push pop peer empty and full.

Qeque is also a sequential datastructure which will work on First In First Out(FIFI) . It is the datastructure with restriction that the insertion will be performed from one end and deletion from the another end with help of front and rear. The mainly operations will be performed are : enque and deque operations .

We can implement both by using an array (i.e. static implementation ) and another is using linklist that is dynamic implementation.

No Discussion on this question yet!

No Discussion on this question yet!

No Discussion on this question yet!

A database is a logically coherent collection of data with some inherent meaning, representing some aspect of real world and which is designed, built and populated with data for a specific purpose.

It is a collection of programs that enables the user to create and maintain a database. In other words, it is general-purpose software that provides the users with the processes of defining, constructing and manipulating the database for various applications.

The database and DBMS software together are called as Database system.

1. Reduces Data Redundancy

2. Maintains Data Consistent

3.Query to access data

4. Security

5. Easier access by tables