Upload Button Icon Add office photos

Filter interviews by

Clear (1)

Aadiswan Info Consultants SQL Developer Interview Questions and Answers

Updated 5 Jun 2020

Aadiswan Info Consultants SQL Developer Interview Experiences

1 interview found

SQL Developer Interview Questions & Answers

user image Anonymous

posted on 29 May 2020

Interview Questionnaire 

3 Questions

  • Q1. Basic SQL Questions
  • Q2. Question on XML
  • Q3. Qustion on Indexs

Interview questions from similar companies

I applied via Referral and was interviewed before Aug 2021. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. How find unique values in a table
  • Ans. 

    Use SELECT DISTINCT statement to find unique values in a table.

    • Use SELECT DISTINCT column_name FROM table_name

    • DISTINCT keyword returns only unique values

    • Can be used with multiple columns

    • Can be combined with other SQL statements like WHERE and ORDER BY

  • Answered by AI
  • Q2. How to troubleshoot a stored procedure
  • Ans. 

    To troubleshoot a stored procedure, check for syntax errors, run the procedure with test data, and use debugging tools.

    • Check for syntax errors in the stored procedure code

    • Run the procedure with test data to identify any logical errors

    • Use debugging tools like SQL Server Profiler or Visual Studio Debugger to step through the code and identify issues

    • Check for any database connectivity issues or permission errors

    • Review the...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well and attended with confidence

Skills evaluated in this interview

I was interviewed before Sep 2016.

Interview Preparation Tips

Round: Group Discussion
Experience: Interview was scheduled in Grab Job consultancy. In that, a class room, where we all asked to sit and interviewer was sitting in front and asked to speak one by one on the topic traffic situation in Hyderabad.
Tips: Just speak once two to three lines. Don't rush to speak. Take ur time and don't try speak repeatedly.
Duration: 35 minutes

Round: Technical Interview
Experience: System based test. Easy question from java , c, data structure.

Round: HR Interview
Experience: Not held because already we got too late.

Skills: Proficiency In English, Basic Coding
College Name: Medak College of engineering

I was interviewed in Mar 2017.

Interview Questionnaire 

5 Questions

  • Q1. Oops concepts in Java?
  • Ans. 

    Oops concepts in Java

    • Encapsulation - hiding implementation details

    • Inheritance - reusing code and creating parent-child relationships

    • Polymorphism - multiple forms of a method or object

    • Abstraction - creating abstract classes and interfaces

    • Example: Encapsulation - using private variables and public methods

    • Example: Inheritance - creating a subclass that inherits from a superclass

    • Example: Polymorphism - using method overloa...

  • Answered by AI
  • Q2. Altering columns in Databases?
  • Ans. 

    Altering columns in databases involves modifying the structure of a table by adding, deleting or modifying columns.

    • Use ALTER TABLE statement to modify columns

    • Add new columns using ADD COLUMN

    • Delete columns using DROP COLUMN

    • Modify columns using MODIFY COLUMN

    • Changing column data type may result in data loss

  • Answered by AI
  • Q3. Asked some queries in SQL
  • Q4. Reversing a number in java?
  • Ans. 

    Reversing a number in Java

    • Convert the number to a string

    • Use StringBuilder to reverse the string

    • Convert the reversed string back to a number

  • Answered by AI
  • Q5. Extracting words from a line in java?
  • Ans. 

    To extract words from a line in Java, split the line using whitespace as delimiter.

    • Use the split() method of String class

    • Pass the whitespace regex as argument to split() method

    • Iterate over the resulting array to get individual words

  • Answered by AI

Interview Preparation Tips

Round: Technical Interview
Experience: Started with the question "Tell me about yourself". Asked me about Core Java. Asked to solve some questions related to Java and SQL.
Tips: Be prepared with high knowledge in Java, Data Structures and SQL.

Skills: Java Programming, Data Strrutures, SQL
College Name: IIITDM Jabalpur

Skills evaluated in this interview

Associate Interview Questions & Answers

Capgemini user image Vivek kumar Singh

posted on 26 Jul 2017

Interview Questionnaire 

1 Question

  • Q1. Self intro Technical

Interview Preparation Tips

Round: Technical round
Experience: Computer skills

Round: Manager Round
Experience: Manager asked about experience and academics questions

Software Developer Interview Questions & Answers

Capgemini user image Dwarkesh Maheshwari

posted on 23 Sep 2017

I was interviewed in Sep 2017.

Interview Questionnaire 

1 Question

  • Q1. Basic c questions and sorting Then about projects

Interview Preparation Tips

Round: Test
Experience: Basic apti questions
But reasoning was tricky
Tips: Don't waste time
Duration: 1 hour
Total Questions: 32

Round: Technical test
Experience: Basic c question
SQL questions
Tips: Must have deep knowledge in c

Round: Technical Interview
Experience: Briefly explain my project and then successfully answerd questions asked
Tips: Complete knowledge of your project

College Name: KIET

Interview Questionnaire 

1 Question

  • Q1. What is the advantage of generic collection, when and why we should approach for that?
  • Ans. 

    Generic collections provide type safety and reusability in software development.

    • Generic collections allow us to store and manipulate objects of any type in a type-safe manner.

    • They provide compile-time type checking, reducing the chances of runtime errors.

    • They promote code reusability by allowing the same collection to be used with different types.

    • Generic collections improve performance by eliminating the need for boxin...

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: It was and off campus drive, first round was written test on computer as MCQ.
Aptitude, reasoning, English and programming sudo codes.
60 questions 90 minutes.
Duration: 2 hours 30 minutes
Total Questions: 60

Round: Group Discussion
Experience: It was a very interesting round, we were given sufficient time to think about topic.
First we were asked to speak individually on the topic ,later panel member asked is to make same topic as debate.
Tips: Don't sit silent, if you are not getting a chance to speak, you can interrupt to the people and seek a chance to put your point.
Duration: 30 minutes

Round: Technical + HR Interview
Tips: Be confident and tell the exact you know, don't try make customised concepts.
Try to drag interviewer towards the fields of your strength.

I was interviewed before Jun 2016.

Interview Questionnaire 

4 Questions

  • Q1. Tell me something about yourself
  • Ans. 

    I am a passionate software developer with 5 years of experience in web development and a strong background in computer science.

    • 5 years of experience in web development

    • Strong background in computer science

    • Passionate about software development

  • Answered by AI
  • Q2. Questions related to project I have worked on during college days
  • Q3. Core Java concepts
  • Q4. Why do you use two mobile numbers
  • Ans. 

    To separate personal and professional calls, and to ensure availability and accessibility.

    • Separate personal and professional calls

    • Ensure availability and accessibility

    • Maintain work-life balance

    • Avoid mixing personal and work-related contacts

  • Answered by AI

Interview Preparation Tips

Round: Test
Total Questions: 60

College Name: Watumull Institute Of Electronics Engineering And Computer Technology ( WIEECT )

I was interviewed in Jul 2017.

Interview Questionnaire 

1 Question

  • Q1. Android basics and programs

Interview Preparation Tips

Round: Resume Shortlist
Experience: Resume shortlisted on the basis of 60% through out and experience in development more than 6 months.

Round: Technical Interview
Experience: Core java.. String, oops, exception,

Round: HR Interview
Experience: As usual.. tell me about your self.expectations and salary discussion.
Tips: Be confident whatever you say.

I was interviewed in Apr 2017.

Interview Questionnaire 

2 Questions

  • Q1. What is firmware and where it is used?
  • Ans. 

    Firmware is a type of software that is embedded in hardware devices to control their functionality.

    • Firmware is a combination of hardware and software.

    • It is used to control the behavior of hardware devices.

    • Firmware is typically stored in non-volatile memory, such as ROM or flash memory.

    • Examples of devices that use firmware include routers, printers, and digital cameras.

  • Answered by AI
  • Q2. Tell me about yourself only.
  • Ans. 

    I am a passionate software developer with experience in building web applications and solving complex problems.

    • Experienced in programming languages such as Java, JavaScript, and Python

    • Familiar with front-end technologies like HTML, CSS, and React

    • Strong problem-solving skills and ability to work in a team environment

    • Previous projects include developing a customer management system for a small business

  • Answered by AI

Interview Preparation Tips

Round: aptitude
Experience: the test had around 70 questions to be answered in 1 hour
Tips: keep watch on time and be quick enough because each sections has sectional cutoff.

Round: Technical Interview
Experience: the test had around 70 questions to be answered in 1 hour
Tips: keep watch on time and be quick enough because each sections has sectional cutoff.

Round: HR Interview
Experience: they tested my core knowledge and learning skill.
Tips: be strong in your basics.

Skills: Ability To Think Beyond Boundaries
College Name: mnm jec

Skills evaluated in this interview

Contribute & help others!
anonymous
You can choose to be anonymous

Aadiswan Info Consultants Interview FAQs

How to prepare for Aadiswan Info Consultants SQL Developer 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 Aadiswan Info Consultants. The most common topics and skills that interviewers at Aadiswan Info Consultants expect are Configuration, Database Design, Performance Tuning, Procedures and Triggers.
What are the top questions asked in Aadiswan Info Consultants SQL Developer interview?

Some of the top questions asked at the Aadiswan Info Consultants SQL Developer interview -

  1. Basic SQL Questio...read more
  2. Question on X...read more
  3. Qustion on Ind...read more

Recently Viewed

SALARIES

Agilent Technologies

LIST OF COMPANIES

Aadiswan Info Consultants

Locations

INTERVIEWS

10405090xyzabc

20 top interview questions

INTERVIEWS

American Express

No Interviews

INTERVIEWS

Ather Energy

No Interviews

INTERVIEWS

Guidewire Software

No Interviews

INTERVIEWS

10405090xyzabc

No Interviews

INTERVIEWS

Moody's Analytics

No Interviews

INTERVIEWS

Agilent Technologies

No Interviews

INTERVIEWS

HSBC Group

No Interviews

Tell us how to improve this page.

Aadiswan Info Consultants SQL Developer Salary
based on 4 salaries
₹3 L/yr - ₹4.5 L/yr
28% less than the average SQL Developer Salary in India
View more details
Business Analyst
11 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Developer
9 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Consultant
7 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer
7 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Software Engineer
6 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Aadiswan Info Consultants with

TCS

3.7
Compare

Infosys

3.6
Compare

Wipro

3.7
Compare

HCLTech

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