Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Sunknowledge Services Team. If you also belong to the team, you can get access from here

Sunknowledge Services Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Sunknowledge Services Database Admin Interview Questions, Process, and Tips

Updated 4 Apr 2022

Sunknowledge Services Database Admin Interview Experiences

1 interview found

I appeared for an interview in May 2021.

Round 1 - Video Call 

(6 Questions)

Round duration - 60 minutes
Round difficulty - Easy

Technical Interview round with questions on DBMS, SQL Server etc.

  • Q1. What are the different types of joins in SQL?
  • Ans. 

    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.

  • Answered by AI
  • Q2. What are aggregate functions in DBMS?
  • Ans. 

    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.

  • Answered by AI
  • Q3. What is the use of the WHERE clause in SQL?
  • Ans. 

    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;

  • Answered by AI
  • Q4. What is the difference between classification and clustering in the context of database management systems?
  • Ans. 

    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...

  • Answered by AI
  • Q5. What is TempDB in MySQL?
  • Ans. 

    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.

  • Answered by AI
  • Q6. What is SSIS?
  • Ans. 

    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...

  • Answered by AI
Round 2 - HR 

Round duration - 30 minutes
Round difficulty - Easy

HR round with typical behavioral problems.

Interview Preparation Tips

Eligibility criteriaAbove 7 CGPASun Knowledge interview preparation:Topics to prepare for the interview - Database Management System, SQL, Servers, Algorithms, System Design, OOPSTime required to prepare for the interview - 6 monthsInterview preparation tips for other job seekers

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.

Application resume tips for other job seekers

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.

Final outcome of the interviewSelected

Skills evaluated in this interview

Interview questions from similar companies

I applied via Indeed and was interviewed in Feb 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Self introduction and kilometer radius to provide a cab and salary because they will provide less

Interview Preparation Tips

Interview preparation tips for other job seekers - No update after assessment

I applied via Naukri.com and was interviewed in May 2020. There were 5 interview rounds.

Interview Questionnaire 

5 Questions

  • Q1. 1. If you are experienced, They'll ask you regarding the projects that you have worked for.
  • Q2. 2. There would be some questions regarding the project which you would be working with the co.
  • Q3. 3. The operations manager would come in, and ask for some personal experience with the previous employer of yours.
  • Q4. 4. Client Round - The client would ask about the memorable experience in any project that you have worked for.
  • Q5. Amswer as per the experience.

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't get nervous. This is one of the cool co in the BPO zone to work for.

Try getting some assistance and test yourself for the versant round. I think that would be the most critical part of the interview.
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Aug 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - One-on-one 

(2 Questions)

  • Q1. Tell me your self my name is pavan kumar I am studying complete degree My birth place Ongole Andra pradesh Now staying sr nagar Hyderabad
  • Q2. I am waiting for the job

Interview Preparation Tips

Interview preparation tips for other job seekers - Empty
Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Aug 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - HR 

(2 Questions)

  • Q1. Self introduction, questions regarding the job profile.
  • Q2. Movie explaination

Interview Preparation Tips

Topics to prepare for Bpo Convergence Customer Service Executive interview:
  • Spoken English
  • Communication Skills
  • Hobby
Interview preparation tips for other job seekers - Be confident and calm, prepare the script of how you spend your day or weekend or the past whole week. ALSO Do not be in rush while giving the answers.

I applied via Naukri.com

Interview Questionnaire 

4 Questions

  • Q1. Explain the basis of handling customer in inbound or outbound,how u deal with angry customer?
  • Ans. 

    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...

  • Answered by AI
  • Q2. Which process is best suited for your -voice or web?
  • Ans. 

    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.

  • Answered by AI
  • Q3. Explain the difference between BPO and call centre?
  • Ans. 

    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,...

  • Answered by AI
  • Q4. Explain what is a call centre ?
  • Ans. 

    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 ...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Have confidence on yourself.
Have great communication skills.
Be polite to every customer.
Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(2 Questions)

  • Q1. Tell us about yourself
  • Q2. How much salary expectation
Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Jun 2023. There was 1 interview round.

Round 1 - HR 

(3 Questions)

  • Q1. Tell me about yourself. Why should we hire you?
  • Q2. Why should we hire you
  • Q3. Why do you want to join us?
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Job Fair and was interviewed in Feb 2023. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - HR 

(2 Questions)

  • Q1. Tell me about your self
  • Q2. Why should we hire you

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and professional i cannot complete fifteen words sentences
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - HR 

(2 Questions)

  • Q1. Anatomy basics and coding basic
  • Ans. Also physiology basics. First yr syllabus only
  • Answered Anonymously
  • Q2. Just go through the topics relevant to coding

Interview Preparation Tips

Interview preparation tips for other job seekers - Good luck. Even if you don't know they ll train you. So have confidence and answer.

Sunknowledge Services Interview FAQs

How to prepare for Sunknowledge Services Database Admin interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Sunknowledge Services . The most common topics and skills that interviewers at Sunknowledge Services expect are Database Administration, Postgresql, SQL, High Availability and Oracle DBA.

Tell us how to improve this page.

Interview Questions from Similar Companies

IKS Health Interview Questions
3.6
 • 235 Interviews
IntouchCX Interview Questions
2.9
 • 194 Interviews
Globiva Interview Questions
3.1
 • 107 Interviews
Provana Interview Questions
3.9
 • 100 Interviews
ReSource Pro Interview Questions
4.0
 • 93 Interviews
Alorica Interview Questions
3.1
 • 72 Interviews
MiraMed Ajuba Interview Questions
3.9
 • 55 Interviews
Bpo Convergence Interview Questions
3.5
 • 50 Interviews
AM Infoweb Interview Questions
3.6
 • 48 Interviews
View all
Sunknowledge Services Database Admin Salary
based on 4 salaries
₹3.4 L/yr - ₹4.4 L/yr
51% less than the average Database Admin Salary in India
View more details
Process Associate
1.2k salaries
unlock blur

₹1.4 L/yr - ₹3.5 L/yr

Senior Process Associate
131 salaries
unlock blur

₹1.6 L/yr - ₹3.5 L/yr

AR Analyst
88 salaries
unlock blur

₹1.8 L/yr - ₹4.6 L/yr

Management Trainee
75 salaries
unlock blur

₹1.5 L/yr - ₹2.5 L/yr

Team Lead
68 salaries
unlock blur

₹2.5 L/yr - ₹6.7 L/yr

Explore more salaries
Compare Sunknowledge Services with

Statestreet HCL Services

3.3
Compare

IKS Health

3.6
Compare

IntouchCX

2.9
Compare

Globiva

3.1
Compare
Did you find this page helpful?
Yes No
write
Share an Interview