Upload Button Icon Add office photos

Filter interviews by

WNS SQL Database Administrator Interview Questions and Answers

Updated 16 Sep 2024

WNS SQL Database Administrator Interview Experiences

1 interview found

Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Aptitude , reasoning, general questions

Round 2 - Technical 

(2 Questions)

  • Q1. What is spark architecture and partitions
  • Ans. 

    Spark architecture refers to the structure of Apache Spark framework, while partitions are units of data distribution for parallel processing.

    • Spark architecture includes components like Driver, Executor, and Cluster Manager

    • Partitions are units of data distribution for parallel processing in Spark RDDs

    • Increasing the number of partitions can improve parallelism and performance

    • Example: In Spark, data is divided into parti...

  • Answered by AI
  • Q2. What is rdd, trsnsformations
  • Ans. 

    RDD (Resilient Distributed Dataset) is a fundamental data structure in Apache Spark for distributed data processing. Transformations are operations that create a new RDD from an existing one.

    • RDD is a fault-tolerant collection of elements that can be operated on in parallel.

    • Transformations are functions that produce a new RDD by applying a computation on the existing RDD.

    • Examples of transformations include map, filter,

  • Answered by AI
Round 3 - HR 

(2 Questions)

  • Q1. Salary expectations
  • Q2. Current ctc n expected ctc
  • Ans. 

    The current CTC (Cost to Company) and expected CTC (Cost to Company) are typically discussed during salary negotiations.

    • Be honest about your current salary and provide a realistic expectation for your future salary.

    • Consider factors such as your experience, skills, industry standards, and the company's budget when discussing CTC.

    • It is important to have a clear understanding of your worth and negotiate accordingly.

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

Interview Questionnaire 

1 Question

  • Q1. Multiple questions and basically

Interview Preparation Tips

Interview preparation tips for other job seekers - In online campus .in database in client support

Interview Questionnaire 

2 Questions

  • Q1. What is the next steps
  • Ans. 

    The next steps depend on the current task or project at hand.

    • Assess the current status of the project

    • Identify any potential roadblocks or challenges

    • Develop a plan of action to address any issues

    • Communicate with stakeholders and team members

    • Execute the plan and monitor progress

    • Document any changes or updates

    • Continuously evaluate and improve the system

  • Answered by AI
  • Q2. When is the interview date and time

Interview Preparation Tips

Interview preparation tips for other job seekers - I have an extensive knoledge inthe administration of the microsoft SQL server FIELD AND HAVE THE SPECIFIC SKILLS YOU ARE LOOKING FOR

Interview Questionnaire 

1 Question

  • Q1. Multiple questions and basically

Interview Preparation Tips

Interview preparation tips for other job seekers - In online campus .in database in client support

I applied via Naukri.com and was interviewed in Oct 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Prepare basic

Interview Preparation Tips

Interview preparation tips for other job seekers - Just focus on basics of sql

WNS Interview FAQs

How many rounds are there in WNS SQL Database Administrator interview?
WNS interview process usually has 3 rounds. The most common rounds in the WNS interview process are Aptitude Test, Technical and HR.
How to prepare for WNS SQL Database Administrator 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 WNS. The most common topics and skills that interviewers at WNS expect are SQL DBA, Performance Tuning, Clustering, High Availability and SSRS.
What are the top questions asked in WNS SQL Database Administrator interview?

Some of the top questions asked at the WNS SQL Database Administrator interview -

  1. What is spark architecture and partiti...read more
  2. What is rdd, trsnsformati...read more
  3. Current ctc n expected ...read more

Tell us how to improve this page.

WNS SQL Database Administrator Interview Process

based on 1 interview

Interview experience

1
  
Bad
View more
WNS SQL Database Administrator Salary
based on 11 salaries
₹3.1 L/yr - ₹7 L/yr
26% less than the average SQL Database Administrator Salary in India
View more details

WNS SQL Database Administrator Reviews and Ratings

based on 1 review

4.0/5

Rating in categories

5.0

Skill development

4.0

Work-life balance

4.0

Salary

4.0

Job security

4.0

Company culture

4.0

Promotions

5.0

Work satisfaction

Explore 1 Review and Rating
Senior Associate
11.6k salaries
unlock blur

₹0.8 L/yr - ₹8 L/yr

Associate
3.9k salaries
unlock blur

₹1 L/yr - ₹7 L/yr

Associate Lead
3.2k salaries
unlock blur

₹2.7 L/yr - ₹11 L/yr

Assistant Manager
2.9k salaries
unlock blur

₹4 L/yr - ₹16 L/yr

Senior Associate Operations
2.7k salaries
unlock blur

₹1.1 L/yr - ₹7.9 L/yr

Explore more salaries
Compare WNS with

TCS

3.7
Compare

Infosys

3.6
Compare

HCLTech

3.5
Compare

Tech Mahindra

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