Technical Interview Questions and Answers :: Syntel Inc.


Tot. Mock Test: 4

Total Qs: 156+

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

    1 / 156

    What is commit, savepoint and Rollback?

    To delete the data permanently we use 'commit' statement, to roll the transaction back to a certain point, without rolling back the entire transaction we use 'savepoint', to get deleted data rollback is used.

    Please Login First :

    2 / 156

    What is Cursor and How many types of Cursor you have used?

    Cursors help us to do an operation on a set of data that we retrieve by commands such as Select columns from a table. For example : If we have duplicate records in a table we can remove it by declaring a cursor which would check the records during retrieval.

    There are mainly 2 types of cursors .
    1) Implicit Cursor.
    2) Explicit Cursor.

    Implicit Cursor: Oracle will implicitly creates an area for the DML operations. Programmer will not have control on implicit cursors. The only useful attribute on this implicit cursor is SQL%ROWCOUNT , it will give the number of rows affected by the recent DML operation.

    Explicit Cursor: created by the programmer and programmer have control on it Programmer can
    1) Open 2) Close 3) Fetch
    one by one and remove rows which have duplicate values.

    Explicit Cursors are classified into
    1) Normal cursor
    2) Parameterized cursor
    3) Cursor For Loops and
    4) REF cursors

    Please Login First :


    Please Login First :

    4 / 156

    What are the principle concepts of OOPS?

    1. Abstraction
    2. Encapsulation
    3. Inheritance
    4. Polymorphism
    5. Classes and Object

    Please Login First :

    Inheritance means, we use the methods or function or other public members of the parent class by child class. So to do this we have to extend the the parent class through it child class.
    For Ex:- Amitabh bacchan's fames inherited by his child Abhishek.

    Program Ex:-

    class A{
    System.out.println("HELLLO ");

    class B extends class A{
    public static void main(String... args){
    A pr=new A();

    Things to remember:---
    * Every class in java inherited by its parent class Object which is in the package:- java.lang.Object when the class is not extended by any child class only.
    * Java does not support "Multiple Inheritance" except in the case of Interface Concept.
    Because one class cannot extend more than one class but Interface able to extend more than one.

    Please Login First :

    6 / 156

    What is Polymorphism/Late Binding? Explain the different forms of Polymorphism.

    When an object is sent a message then it does not know itself what type it is, the runtime environment will decide about function calling over an object. This feature of connecting an object with its associated message at runtime is known as Polymorphism or Late binding or Dynamic binding.

    Please Login First :

    7 / 156

    What is method overloading and overriding?

    Method Overloading:
    A method with changed formal parameters will lead to implementing method overloading.
    int calculateSum(int i,int j)
    float calculateSum(float i,int j)
    double calculateSum(double i,int j)
    float calculateSum(int i,float j)

    Method Overriding:
    The method with the same signature but with changed implementation lead to method overriding and that can occur in a parent child relation of classes. A method defined in parent class can be overridden in its child class with different implementation from its base class.
    1. Pointers are supported in C++ while not in Java. The memory management is done automatically with help of part of JVM called Garbage Collector.
    2. Multiple inheritance is not supported in Java but supported in C++.
    3. There are no structures and unions in Java.
    4. There is no scope resolution operator in Java (::).
    5. There are no destructors in Java like C++.
    6. There is no virtual keyword in Java because all non-static method use dynamic binding.

    Please Login First :

    super is a keyword in java used to refer to the base class in inheritance

    Please Login First :

    9 / 156

    What is an Interface?Can we instantiate an interface?

    No, an interface can't be instantiated. Interface is similar to class. Interface can only have abstract methods. A class can implement an interface.

    Please Login First :

    10 / 156

    What is an abstract class?Can we instantiate an abstract class?

    A virtual function, equated to zero is called a pure virtual function. It is a function declared in a base class that has no definition relative to the base class. A class containing such pure function is called an abstract class.
    It objectives are
    • Provide some traits to the derived classes.
    • To create a base pointer required for achieving run time polymorphism.

    Please Login First :

Most Frequent Qs.