Get Off-Campus Placement Jobs Info !!!
Programs asked in Mettl Coding Round
Click To Practce List of Programs asked in Nagarro !!!

Technical Interview Questions and Answers :: Sopra Steria

7.29K

Tot. Mock Test: 10


Total Qs: 138+

  •  Select All
  •  SQL
  •  Java
  •  C++
  •  Informatica
  •  C
  •  DBMS
  •  Data Structure
  •  HR Question in TR

    81 / 138

    What are inner-joins and outer-joins?
    Answer:

    No Discussion on this question yet!

    Please Login First :

    82 / 138

    How many joins in a SQL? Write a query for each of those joins?
    Answer:

    No Discussion on this question yet!

    Please Login First :

    83 / 138

    What is used to find unique rows in a table?
    Answer:

    No Discussion on this question yet!

    Please Login First :

    84 / 138

    Write the query two merge two tables with INNER Join.
    Answer:

    No Discussion on this question yet!

    Please Login First :

    85 / 138

    How can we rename a column in a query? And What does this renaming process called as?
    Answer:

    No Discussion on this question yet!

    Please Login First :

    86 / 138

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

    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 :

    87 / 138

    What is method overloading and overriding?
    Answer:

    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 :
    Answer:

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

    Please Login First :

    89 / 138

    What is an Interface?Can we instantiate an interface?
    Answer:

    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 :

    90 / 138

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

    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.