i
Sunknowledge Services
Filter interviews by
I appeared for an interview in May 2021.
Round duration - 60 minutes
Round difficulty - Easy
Technical Interview round with questions on DBMS, SQL Server etc.
Different types of joins in SQL include inner join, left join, right join, and full outer join.
Inner join: Returns rows when there is at least one match in both tables.
Left join: Returns all rows from the left table and the matched rows from the right table.
Right join: Returns all rows from the right table and the matched rows from the left table.
Full outer join: Returns rows when there is a match in one of the tables.
Aggregate functions in DBMS are functions that operate on a set of values and return a single value as output.
Aggregate functions perform calculations on multiple rows to return a single result.
Examples include SUM, AVG, COUNT, MIN, and MAX.
They are commonly used with the GROUP BY clause in SQL queries.
The WHERE clause in SQL is used to filter records based on specified conditions.
Used to specify a condition while fetching data from a table
Filters records based on the specified condition
Can be used with SELECT, UPDATE, DELETE statements
Examples: SELECT * FROM table_name WHERE column_name = 'value';
Examples: UPDATE table_name SET column_name = 'new_value' WHERE condition;
Classification assigns predefined categories to data, while clustering groups similar data points together based on their characteristics.
Classification involves labeling data into predefined classes or categories based on certain criteria.
Clustering groups data points based on their similarities without predefined categories.
Classification is supervised learning, while clustering is unsupervised learning.
Example of cl...
TempDB in MySQL is a temporary database used for storing temporary data during query processing.
TempDB is used for storing temporary tables, intermediate results, and other temporary data.
It is automatically created by MySQL when needed and is dropped when the server is restarted.
TempDB helps in optimizing query performance by reducing disk I/O and improving query execution time.
SSIS stands for SQL Server Integration Services, a platform for building high-performance data integration and workflow solutions.
SSIS is a component of Microsoft SQL Server used for data integration and workflow applications.
It allows users to create packages that move data between various sources and destinations.
SSIS includes tools for data extraction, transformation, and loading (ETL).
It supports various data forma...
Round duration - 30 minutes
Round difficulty - Easy
HR round with typical behavioral problems.
Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Interview process is quite easier. Strong knowledge of query writing and Query optimization required.
Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.
I applied via Indeed and was interviewed in Feb 2021. There were 3 interview rounds.
I applied via Naukri.com and was interviewed in May 2020. There were 5 interview rounds.
posted on 15 Aug 2023
I applied via Naukri.com and was interviewed before Aug 2022. There were 2 interview rounds.
posted on 19 Aug 2023
I applied via Referral and was interviewed before Aug 2022. There were 2 interview rounds.
posted on 12 Sep 2020
I applied via Naukri.com
Handling customers in inbound or outbound involves understanding their needs and providing appropriate solutions. Dealing with angry customers requires empathy, active listening, and problem-solving skills.
In inbound customer service, the focus is on addressing customer queries and providing support.
In outbound customer service, the focus is on making proactive calls to customers for sales or follow-ups.
To handle angry...
The best process for me is voice.
Voice communication allows for immediate and direct interaction with customers.
It enables me to provide personalized assistance and address customer concerns effectively.
Voice communication also allows for better understanding of customer emotions and tone.
Examples: Resolving complex issues over the phone, providing step-by-step guidance verbally.
BPO and call centre are related but have distinct differences.
BPO (Business Process Outsourcing) refers to outsourcing various business processes to a third-party service provider.
Call centre specifically focuses on handling customer calls and providing support.
BPO involves a wider range of services such as data entry, payroll processing, HR services, etc.
Call centre primarily deals with customer inquiries, complaints,...
A call centre is a centralized office where customer calls are received and handled by customer service representatives.
A call centre is a facility used by companies to manage customer interactions through various channels such as telephone, email, chat, etc.
It serves as a hub for handling customer inquiries, complaints, and providing support.
Call centre agents are trained to handle a wide range of customer issues and ...
posted on 14 Nov 2024
posted on 2 Jun 2024
I applied via Referral and was interviewed before Jun 2023. There was 1 interview round.
I applied via Job Fair and was interviewed in Feb 2023. There were 2 interview rounds.
Process Associate
1.2k
salaries
| ₹1.4 L/yr - ₹3.5 L/yr |
Senior Process Associate
131
salaries
| ₹1.6 L/yr - ₹3.5 L/yr |
AR Analyst
88
salaries
| ₹1.8 L/yr - ₹4.6 L/yr |
Management Trainee
75
salaries
| ₹1.5 L/yr - ₹2.5 L/yr |
Team Lead
68
salaries
| ₹2.5 L/yr - ₹6.7 L/yr |
Statestreet HCL Services
IKS Health
IntouchCX
Globiva