AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
WNS
Compare
Filter interviews by
WNS SQL Database Administrator Interview Questions and Answers
WNS SQL Database Administrator Interview Experiences
1 interview found
Aptitude , reasoning, general questions
(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...
- 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,
(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.
Skills evaluated in this interview
Interview questions from similar companies
Interview Questionnaire
1 Question
- Q1. Multiple questions and basically
Interview Preparation Tips
Software Engineer Interview Questions & Answers
Concentrix Corporation
Anonymous
posted on 17 May 2021
Interview Questionnaire
1 Question
- Q1. To develop a product catalogue in core Java using Maven.
Nikshep Shankar
I applied via Referral and was interviewed in Apr 2021. There were 7 interview rounds.
Interview Questionnaire
2 Questions
- Q1. Name
- Q2. Introduction
Interview Preparation Tips
I applied via Newspaper Ad and was interviewed before May 2021. There were 2 interview rounds.
Group discussion,aptitude test
Aptitude test
Interview Preparation Tips
I applied via Naukri.com and was interviewed in May 2021. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. What is object oriented programming
- Ans.
Object oriented programming is a programming paradigm that uses objects to represent and manipulate data.
Objects encapsulate data and behavior
Classes define the blueprint for objects
Inheritance allows for code reuse and polymorphism
Examples include Java, C++, and Python
Interview Preparation Tips
Software Engineer Interview Questions & Answers
Conneqt Business Solutions
Anonymous
posted on 12 Jan 2022
I applied via Naukri.com and was interviewed before Jan 2021. There was 1 interview round.
Interview Questionnaire
3 Questions
- Q1. That place how I am work
- Q2. What is software engineer
- Ans.
A software engineer is a professional who designs, develops, and maintains software applications.
Designs and develops software applications
Uses programming languages and tools to write code
Tests and debugs software to ensure it functions properly
Collaborates with other engineers and stakeholders to ensure software meets requirements
Continuously learns and adapts to new technologies and industry trends
- Q3. What is technical science
- Ans.
Technical science is the application of scientific principles and methods to solve practical problems in technology.
It involves the use of scientific knowledge to design, develop, and improve technology.
Examples include computer science, electrical engineering, and mechanical engineering.
Technical science is interdisciplinary, drawing on knowledge from physics, chemistry, and mathematics.
It is essential for innovation ...
Interview Preparation Tips
I applied via Naukri.com and was interviewed before Oct 2020. There were 3 interview rounds.
Interview Questionnaire
2 Questions
- Q1. How HashMap works internally
- Ans.
HashMap is a data structure that stores key-value pairs and uses hashing to retrieve values quickly.
HashMap uses an array of buckets to store key-value pairs
The hash code of the key is used to determine the index of the bucket
If multiple keys have the same hash code, they are stored in a linked list within the bucket
When retrieving a value, the hash code of the key is used to find the bucket and then the linked list is...
- Q2. What is OOP in Java
- Ans.
OOP in Java stands for Object-Oriented Programming which is a programming paradigm based on objects.
OOP focuses on creating objects that have properties and methods
Encapsulation, Inheritance, and Polymorphism are the key concepts of OOP
Java supports OOP through classes and interfaces
Example: A car can be represented as an object with properties like color, model, and methods like start, stop, and accelerate
Interview Preparation Tips
Skills evaluated in this interview
I applied via Campus Placement and was interviewed before May 2021. There was 1 interview round.
(2 Questions)
- Q1. Core language and logical basic oops questions you have to learn
- Q2. 1. Tell me about your self, 2. How many years of experience you have in which is your core language? 3. Explain me oops concepts? 4. Focus on inheritance & abstraction questions? 5. Give some logical codin...
Interview Preparation Tips
- Core Java
- Spring
- Spring Boot
- Maven
- JUnit
- Jira
- Azuredevops
- OOPS
- Microservices
They have so many projects directly they are put you in some projects then provide KT and you have to start work.
I applied via Campus Placement and was interviewed before Sep 2020. There were 2 interview rounds.
Interview Preparation Tips
WNS Interview FAQs
Tell us how to improve this page.
WNS Interviews By Designations
- WNS Senior Associate Interview Questions
- WNS Associate Interview Questions
- WNS Operations Associate Interview Questions
- WNS Associate Lead Interview Questions
- WNS Senior Associate Operations Interview Questions
- WNS Assistant Manager Interview Questions
- WNS Back Office Executive Interview Questions
- WNS Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
- Oracle Database Administrator Interview Questions
- Database Developer Interview Questions
- SQL Server Database Administrator Interview Questions
- Senior Database Administrator Interview Questions
- MS SQL DBA Interview Questions
- Database Engineer Interview Questions
- Database Architect Interview Questions
- Mysql Database Administrator Interview Questions
- Show more
WNS SQL Database Administrator Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
WNS SQL Database Administrator Reviews and Ratings
based on 1 review
Rating in categories
|
Senior Associate
13.6k
salaries
|  ₹0.6 L/yr - ₹8 L/yr |
|
Associate
4.8k
salaries
| ₹1 L/yr - ₹7 L/yr |
|
Associate Lead
3.2k
salaries
| ₹2.8 L/yr - ₹11 L/yr |
|
Assistant Manager
3.2k
salaries
| ₹5 L/yr - ₹16.2 L/yr |
|
Senior Associate Operations
2.8k
salaries
| ₹1.1 L/yr - ₹8 L/yr |
Teleperformance
Concentrix Corporation
iEnergizer
Infosys BPM
- Home >
- Interviews >
- WNS Interview Questions >
- WNS SQL Database Administrator Interview Questions
