Premium Employer

Societe Generale Global Solution Centre

3.8
based on 2.4k Reviews
Filter interviews by

CSC Global Interview Questions and Answers

Updated 5 Aug 2024
Popular Designations

Q1. what is diff betn delete truncate drop

Ans.

Delete removes specific rows from a table, truncate removes all rows from a table, and drop removes an entire table.

  • Delete is a DML command, while truncate and drop are DDL commands.

  • Delete can be rolled back, while truncate and drop cannot be rolled back.

  • Delete is slower than truncate and drop as it logs individual row deletions.

  • Delete can have a WHERE clause to specify conditions, while truncate and drop do not support conditions.

  • Example: DELETE FROM table_name WHERE conditi...read more

Add your answer

Q2. Difference between parameterized and copy constructed

Ans.

Parameterized constructor accepts parameters to initialize an object, while copy constructor creates a new object by copying an existing object.

  • Parameterized constructor is used to initialize an object with specific values.

  • Copy constructor creates a new object by copying values from an existing object.

  • Example: Parameterized constructor - Car(int year, String model) { this.year = year; this.model = model; }

  • Example: Copy constructor - Car(Car otherCar) { this.year = otherCar.ye...read more

Add your answer

Q3. Difference between 2 way and 3 way merge sort

Ans.

2 way merge sort involves splitting the array into 2 parts and merging them, while 3 way merge sort involves splitting the array into 3 parts and merging them.

  • 2 way merge sort splits the array into 2 parts and merges them recursively.

  • 3 way merge sort splits the array into 3 parts and merges them recursively.

  • 2 way merge sort has a time complexity of O(n log n), same as 3 way merge sort.

Add your answer

Q4. what is polymorphism

Ans.

Polymorphism is the ability of an object to take on many forms. It allows objects of different classes to be treated as the same type.

  • Polymorphism is a fundamental concept in object-oriented programming.

  • It allows a single interface to be used for different types of objects.

  • Polymorphism is achieved through method overriding and method overloading.

  • Example: A parent class Animal can have multiple child classes like Dog, Cat, and Bird. They can all be treated as Animals.

  • Polymorph...read more

Add your answer
Discover CSC Global interview dos and don'ts from real experiences

Q5. explain joins types is joins

Ans.

Join types in SQL are used to combine rows from two or more tables based on a related column between them.

  • Inner join: returns only the matching rows from both tables

  • Left join: returns all rows from the left table and the matching rows from the right table

  • Right join: returns all rows from the right table and the matching rows from the left table

  • Full outer join: returns all rows from both tables, including the unmatched rows

  • Cross join: returns the Cartesian product of both tabl...read more

Add your answer

Q6. whsts friend function in java

Ans.

Friend function in Java is a function that is declared in a class but is not a member of that class. It can access private and protected members of the class.

  • Friend functions are not part of the class but have access to its private and protected members.

  • They are declared using the 'friend' keyword in Java.

  • Friend functions can be useful for providing access to private members of a class to external functions or classes.

Add your answer
Contribute & help others!
Write a review
Share interview
Contribute salary
Add office photos

Interview Process at CSC Global

based on 8 interviews
4 Interview rounds
Aptitude Test Round
Technical Round - 1
Technical Round - 2
HR Round
View more
Interview Tips & Stories
Ace your next interview with expert advice and inspiring stories

Top Softwaretest Engineer Interview Questions from Similar Companies

4.3
 • 23 Interview Questions
3.8
 • 16 Interview Questions
3.7
 • 15 Interview Questions
3.5
 • 14 Interview Questions
4.0
 • 13 Interview Questions
3.7
 • 13 Interview Questions
View all
Share an Interview
Stay ahead in your career. Get AmbitionBox app
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
70 Lakh+

Reviews

5 Lakh+

Interviews

4 Crore+

Salaries

1 Cr+

Users/Month

Contribute to help millions

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter