AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
CCS Global Tech Associate Software Engineer Interview Questions, Process, and Tips
Top CCS Global Tech Associate Software Engineer Interview Questions and Answers
- Q1. Write q query to fetch the details of employees who are in the same department
- Q2. What is difference between delete and truncate command in SQL?
- Q3. What's the difference between where and having clause
CCS Global Tech Associate Software Engineer Interview Experiences
2 interviews found
Anonymous
I applied via Company Website and was interviewed in Feb 2023. There were 2 interview rounds.
(5 Questions)
- Q1. What is oops and what are its advantages
- Ans.
OOPs is a programming paradigm that uses objects to represent real-world entities and provides encapsulation, inheritance, and polymorphism.
Encapsulation: Hides the implementation details of an object from the outside world
Inheritance: Allows creating a new class from an existing class
Polymorphism: Allows objects of different classes to be treated as if they are of the same class
Advantages: Reusability, Modularity, Fle...
- Q2. Different types of joins
- Ans.
Different types of joins are Inner Join, Left Join, Right Join, and Full Outer Join.
Inner Join returns only the matching rows from both tables.
Left Join returns all the rows from the left table and matching rows from the right table.
Right Join returns all the rows from the right table and matching rows from the left table.
Full Outer Join returns all the rows from both tables, including non-matching rows.
- Q3. Primary Key and unique key
- Q4. What's the difference between where and having clause
- Ans.
WHERE clause filters rows before grouping, HAVING clause filters groups after grouping.
WHERE clause is used to filter rows based on a condition
HAVING clause is used to filter groups based on a condition
WHERE clause is used before GROUP BY clause
HAVING clause is used after GROUP BY clause
WHERE clause cannot contain aggregate functions
HAVING clause can contain aggregate functions
Example: SELECT department, AVG(salary) FR...
- Q5. Write q query to fetch the details of employees who are in the same department
- Ans.
Query to fetch details of employees in the same department
Use SELECT statement to fetch employee details
Use JOIN to join employee and department tables
Use WHERE clause to filter employees in the same department
Interview Preparation Tips
Skills evaluated in this interview
Selected
I applied via Approached by Company and was interviewed before Aug 2022. There were 3 interview rounds.
(2 Questions)
- Q1. What are your skills?
- Q2. What is your background?
(3 Questions)
- Q1. What is difference between delete and truncate command in SQL?
- Ans.
Delete command removes rows one by one while truncate command removes all rows at once.
Delete is a DML command while truncate is a DDL command.
Delete can be rolled back while truncate cannot be rolled back.
Delete command fires triggers for each row deleted, while truncate does not.
Delete command is slower as it maintains logs for each row deleted, while truncate is faster as it does not maintain logs.
Delete command can...
- Q2. How to join two table with inner join?
- Ans.
To join two tables with inner join, use the JOIN keyword along with the ON clause to specify the join condition.
Use the JOIN keyword to combine rows from two tables based on a related column between them
Specify the join condition using the ON keyword followed by the columns to join on
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
- Q3. How to delete duplicate records in a table?
- Ans.
Use SQL query with GROUP BY and HAVING clause to delete duplicate records in a table.
Identify the columns that define a duplicate record
Write a SQL query to select the duplicate records using GROUP BY and HAVING clause
Delete the duplicate records using DELETE statement with the identified criteria
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
I was interviewed in Jan 2025.
(2 Questions)
- Q1. Circular wait Ans A circular chain with two or more processes, each one waiting for a resource held by the next process within the chain
- Q2. Hold and wait Ans A process must be holding at least one resource while waiting to acquire additional resources held by other process holding them
(2 Questions)
- Q1. The phrase 'lavish with his hospitality' in the third sentence of the first paragraph means Ans Extravagance in entertaining guest
- Q2. What is an Accenture coding Test Ans The Accenture coding Test but not like the one in the first stage,its much lengthier and more comprehensive.
Interview Preparation Tips
. Act kindly to everyone
. Send follow-up emails
. Learn job keywords
. Be mindful of your job location
Associate Software Engineer Interview Questions & Answers
Tech Mahindra
Punit Kumar
posted on 20 Nov 2024
(5 Questions)
- Q1. Swap two variables, prime number
- Ans.
To swap two variables, use a temporary variable to store one value before swapping them.
Create a temporary variable to store one of the values
Assign the first variable to the temporary variable
Assign the second variable to the first variable
Assign the temporary variable to the second variable
- Q2. Based on Linux, SQL and other
- Q3. What are pointers
- Ans.
Pointers are variables that store memory addresses of other variables or functions.
Pointers are used to access and manipulate memory directly.
They are commonly used in programming languages like C and C++.
Example: int *ptr; // declaring a pointer to an integer variable
- Q4. Commands on SQL and Linux
- Q5. Questions related to HR
Selected
I applied via Campus Placement and was interviewed in Nov 2024. There was 1 interview round.
(2 Questions)
- Q1. What is the difference between drop and delete in SQL?
- Ans.
Drop removes a table from the database while delete removes specific rows from a table.
DROP is a DDL (Data Definition Language) command used to remove a table and its data from the database.
DELETE is a DML (Data Manipulation Language) command used to remove specific rows from a table based on a condition.
DROP command is irreversible and all the data in the table is lost, while DELETE can be rolled back if used within a...
- Q2. What are the different commands in SQL?
- Ans.
SQL commands are used to interact with databases and perform various operations like querying, updating, and deleting data.
SELECT - retrieves data from a database
INSERT - adds new data to a database
UPDATE - modifies existing data in a database
DELETE - removes data from a database
CREATE - creates a new database or table
ALTER - modifies the structure of a database object
DROP - deletes a database object
JOIN - combines row...
There were two coding questions
There was oncampus coding round , where 1 question was given.
(2 Questions)
- Q1. Tell me something about yourself?
- Q2. What are your projects?
(1 Question)
- Q1. Where do you see yourself after 5 years?
(2 Questions)
- Q1. Read the sentence
- Q2. Listen and repeat the sentence
Mercel platform 1 hour
(2 Questions)
- Q1. Explain ur project
- Ans.
Developed a web-based project management tool for tracking tasks and deadlines.
Used HTML, CSS, and JavaScript for front-end development
Implemented backend functionality using Node.js and MongoDB
Incorporated user authentication and authorization features
Utilized RESTful APIs for communication between front-end and back-end
- Q2. One code according to ur cluster
- Ans.
I would write a code snippet based on the specific cluster or category provided.
Identify the specific cluster or category provided in the question
Write a code snippet that aligns with the requirements of the cluster
Ensure the code is accurate and relevant to the given cluster
Selected
I applied via Campus Placement
General aptitude, behaviourial and some analytical questions
(3 Questions)
- Q1. Tell me about yourself
- Q2. Questions from projects mentioned in resume
- Q3. Few basic technical questions
(2 Questions)
- Q1. What is const pointer
- Q2. What is pointer to constant
Pointers full depth question and programs
Associate Software Engineer Interview Questions & Answers
Wipro
A praneeth Kumar Reddy
posted on 24 Oct 2024
Numerical based questions are there mostly
Good basic level coding questions
(2 Questions)
- Q1. Tell me about urself
- Q2. Tell about ur projects
- Ans.
I have worked on various projects including a web application for online shopping and a mobile app for task management.
Developed a web application using HTML, CSS, and JavaScript for online shopping
Created a mobile app using React Native for task management
Implemented RESTful APIs for communication between front-end and back-end systems
CCS Global Tech Interview FAQs
Some of the top questions asked at the CCS Global Tech Associate Software Engineer interview -
Tell us how to improve this page.
Interview Questions for Popular Designations
- Software Engineer Interview Questions
- Senior Software Engineer Interview Questions
- Softwaretest Engineer Interview Questions
- Software Engineer Trainee Interview Questions
- Software Developer Intern Interview Questions
- Software Developer Interview Questions
- Software Development Engineer Interview Questions
- Junior Software Developer Interview Questions
- Show more
CCS Global Tech Associate Software Engineer Interview Process
based on 2 interviews
Interview experience
Associate Software Engineer Interview Questions from Similar Companies
CCS Global Tech Associate Software Engineer Reviews and Ratings
based on 1 review
Rating in categories
|
Data Engineer
5
salaries
|  ₹4.5 L/yr - ₹10 L/yr |
|
Associate Software Engineer
4
salaries
| ₹4.5 L/yr - ₹9 L/yr |
|
Assistant Manager
4
salaries
| ₹5 L/yr - ₹15.5 L/yr |
|
Business Development Executive
4
salaries
| ₹3 L/yr - ₹4.8 L/yr |
|
Research Analyst
3
salaries
| ₹4.5 L/yr - ₹6 L/yr |
TCS
Infosys
Wipro
HCLTech
- Home >
- Interviews >
- CCS Global Tech Interview Questions >
- CCS Global Tech Associate Software Engineer Interview Questions
