Take FREE!! Online Mettl Mock Test to Crack TechM and Other Companies Written Exams.
Get Off-Campus Placement Jobs Info !!!
Practice Tech Mahindra Essay Topics

Technical Interview Questions and Answers :: Virtusa

130.4K

Tot. Mock Test: 3


Total Qs: 221+

  •  Select All
  •  SQL
  •  C++
  •  .NET
  •  Oracle PLSQL
  •  Informatica
  •  WebMethod
  •  DBMS
  •  Soft. Engineering
  •  Data Structure
  •  Networking
  •  C
  •  Operating System
  •  HR Question in TR
  •  Java

    111 / 221

    What is difference between Procedure and Function?
    Answer:

    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

    Please Login First :

    112 / 221

    What is a Stored Procedure? State its advantage.
    Answer:

    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.

    Please Login First :

    113 / 221

    What is stack and queue?
    Answer:

    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.

    Please Login First :

    114 / 221

    What are the basic difference between STACK AND QUEUE.
    Answer:

    No Discussion on this question yet!

    Please Login First :

    115 / 221

    Access modifier in c and java?
    Answer:

    No Discussion on this question yet!

    Please Login First :

    116 / 221

    Explain Software Development Life Cycle (SDLC).
    Answer:

    No Discussion on this question yet!

    Please Login First :
    Answer:

    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.

    Please Login First :
    Answer:

    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.

    Please Login First :

    119 / 221

    What is a Database system?
    Answer:

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

    Please Login First :
    Answer:

    1. Reduces Data Redundancy

    2. Maintains Data Consistent

    3.Query to access data

    4. Security

    5. Easier access by tables

    Please Login First :


Most Frequent Qs.