Take FREE!! Online AMCAT Mock Test to Crack Wipro NLTH, Capgemini, etc.
Get Off-Campus Placement Jobs Info !!!
Practice Given Here Wipro NLTH Practice Q&A

Technical Interview Questions and Answers :: iGate

37.86K

Tot. Mock Test: 11


Total Qs: 160+

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

    1. Reduces Data Redundancy

    2. Maintains Data Consistent

    3.Query to access data

    4. Security

    5. Easier access by tables

    Please Login First :

    52 / 160

    Disadvantage in File Processing System?
    Answer:

    1. Redundant Data

    2. Inconsistency

    3. Not easy to access data.

    4. No security

    5. Concurrent access is not allowed.

    Please Login First :

    53 / 160

    Describe the three levels of data abstraction?
    Answer:

    Physical Level - This is the lowest level of data abstraction which describes which describes how the data is to be stored in the database.

    Logical level - The level describes the data in the database as well as relations between these database.

    View Level- This is the highest level of data abstraction , only some part of actual database is viewed to the user.

    Please Login First :

    54 / 160

    Define the "integrity rules"
    Answer:

    There are two Integrity rules.
    > Entity Integrity: States that “Primary key cannot have NULL value”
    > Referential Integrity: States that “Foreign Key can be either a NULL value or should be Primary Key value of other relation.

    Please Login First :

    55 / 160

    What is System R? What are its two major subsystems?
    Answer:

    System R was designed and developed over a period of 1974-79 at IBM San Jose Research Center. It is a prototype and its purpose was to demonstrate that it is possible to build a Relational System that can be used in a real life environment to solve real life problems, with the performance at least comparable to that of the existing system.
    Its two subsystems are
    > Research Storage
    > System Relational Data System.

    Please Login First :

    56 / 160

    What is a view? How it is related to data independence?
    Answer:

    A view may be thought of as a virtual table, that is, a table that does not really exist in its own right but is instead derived from one or more underlying base table. In other words, there is no stored file that directly represents the view instead a definition of the view is stored in data dictionary.
    Growth and restructuring of base tables are not reflected in views. Thus the view can insulate users from the effects of restructuring and growth in the database. Hence accounts for logical data independence.

    Please Login First :
    Answer:

    A collection of conceptual tools for describing data, data relationships data semantics and constraints.

    Please Login First :
    Answer:

    This data model is based on the real world that consists of basic objects called entities and of a relationship among these objects. Entities are described in a database by a set of attributes.

    Please Login First :

    59 / 160

    What is an Entity?
    Answer:

    It is a 'thing' in the real world with an independent existence.

    Please Login First :

    60 / 160

    What is an Entity type?
    Answer:

    It is a collection (set) of entities that have same attributes.

    Please Login First :


Most Frequent Qs.