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

Clear (1)

Sunknowledge Services Database Admin Interview Questions, Process, and Tips

Updated 4 Apr 2022

Sunknowledge Services Database Admin Interview Experiences

1 interview found

I was interviewed 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 Company Website and was interviewed in Aug 2022. There were 3 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 Resume tips
Round 2 - Assignment 

I am a B.sc computer science graduated
I am a fresher
I am live in Kolhapur
Shivaji University Kolhapur

Round 3 - Technical 

(2 Questions)

  • Q1. Java subject interview question
  • Q2. Java subject asking me please

Interview Preparation Tips

Topics to prepare for Wipro Database Admin interview:
  • Java
Interview preparation tips for other job seekers - I am a b.sc computer science graduated
I am a fresher.
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
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 Resume tips
Round 2 - Technical 

(2 Questions)

  • Q1. Performance tuning and high availability
  • Q2. Allways on and log shipping

Interview Preparation Tips

Interview preparation tips for other job seekers - prepare well in technical more and practice real time scenearios

I applied via Naukri.com and was interviewed in Nov 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Mainly go with high availability, performance tuning.

Interview Preparation Tips

Interview preparation tips for other job seekers - Over all good be confident while taking interview.
Round 1 - Case Study 

Speak about this work

Round 2 - Aptitude Test 

Lcm and hcf,logarthims,probability etc.,

Round 3 - HR 

(1 Question)

  • Q1. We know about computer skill

Interview Preparation Tips

Interview preparation tips for other job seekers - We love our job and enjoy your work.don't be stress refreshing your mind and concentrate your work

I applied via Recruitment Consulltant and was interviewed before Apr 2021. 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 Resume tips
Round 2 - Technical 

(1 Question)

  • Q1. All nosql fundamentals, all work based questions, scenario based questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared with all basic stuffs in nosql and make your fundamentals strong, be confident on what you are saying
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-

I was interviewed in Jul 2023.

Round 1 - Technical 

(1 Question)

  • Q1. What is role of HAS in RAC systems?
  • Ans. 

    HAS (High Availability Services) in RAC systems provides automatic failover and load balancing for improved system reliability.

    • HAS monitors the health of each node in the RAC cluster

    • It automatically relocates services to healthy nodes in case of node failure

    • It ensures high availability and scalability for the RAC system

    • Examples: Oracle Clusterware, Oracle Grid Infrastructure

  • Answered by AI
Round 2 - HR 

(1 Question)

  • Q1. How would you manage the upcoming challenging opportunities in the new role?

Interview Preparation Tips

Interview preparation tips for other job seekers - Think before you answer each question, as your answers may lead to other question.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Aug 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Scenario baes questions
Interview experience
4
Good
Difficulty level
-
Process Duration
Less than 2 weeks
Result
Selected Selected

I was interviewed before Apr 2022.

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 Resume tips
Round 2 - Technical 

(2 Questions)

  • Q1. Technically questions they are asking
  • Q2. Migration errors
Round 3 - HR 

(1 Question)

  • Q1. Package and team handling

Interview Preparation Tips

Interview preparation tips for other job seekers - Learn multiple skills with automation
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Selected Selected

I applied via Company Website and was interviewed before Apr 2023. There was 1 interview round.

Round 1 - Technical 

(3 Questions)

  • Q1. Simple interview questions on MySQL
  • Q2. Difference between Storage engines
  • Ans. 

    Storage engines are components that handle the storage, retrieval, and indexing of data in a database management system.

    • Different storage engines have different features and capabilities.

    • Examples of storage engines include InnoDB, MyISAM, and MongoDB.

    • InnoDB is known for its support of transactions and foreign keys.

    • MyISAM is known for its simplicity and fast read operations.

    • MongoDB is a NoSQL database that uses a docume

  • Answered by AI
  • Q3. MySQL Crash recovery
Contribute & help others!
anonymous
You can choose to be anonymous

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.

Recently Viewed

INTERVIEWS

Hinduja Group

No Interviews

INTERVIEWS

Hinduja Group

No Interviews

SALARIES

AGS Health

REVIEWS

Poonawalla Housing Finance

No Reviews

REVIEWS

Poonawalla Housing Finance

No Reviews

SALARIES

Poonawalla Housing Finance

INTERVIEWS

Hinduja Group

No Interviews

INTERVIEWS

Hinduja Group

No Interviews

INTERVIEWS

Sunknowledge Services

20 top interview questions

COMPANY BENEFITS

Poonawalla Housing Finance

No Benefits

Tell us how to improve this page.

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.5k Interviews
Accenture Interview Questions
3.8
 • 8.2k Interviews
Infosys Interview Questions
3.6
 • 7.6k Interviews
Wipro Interview Questions
3.7
 • 5.6k Interviews
Cognizant Interview Questions
3.7
 • 5.6k Interviews
Omega Healthcare Interview Questions
3.7
 • 439 Interviews
IKS Health Interview Questions
3.6
 • 232 Interviews
IntouchCX Interview Questions
2.9
 • 192 Interviews
View all
Sunknowledge Services Database Admin Salary
based on 4 salaries
₹3.4 L/yr - ₹4.4 L/yr
50% less than the average Database Admin Salary in India
View more details
Process Associate
1.2k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Process Associate
128 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

AR Analyst
86 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Management Trainee
75 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Team Lead
68 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Sunknowledge Services with

Omega Healthcare

3.7
Compare

GeBBS Healthcare Solutions

3.7
Compare

VeeTechnologies

3.7
Compare

Invensis Technologies

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