Upload Button Icon Add office photos

Filter interviews by

WERTMARK TECHNOLOGIES Senior SQL Developer Interview Questions and Answers

Updated 28 Mar 2023

WERTMARK TECHNOLOGIES Senior SQL Developer Interview Experiences

1 interview found

Interview experience
3
Average
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Recruitment Consulltant and was interviewed in Feb 2023. 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 - Technical 

(3 Questions)

  • Q1. Write an sp to with 5 input var and one output var,all int and display the max of input variables
  • Ans. 

    SP with 5 input and 1 output var, all int. Display max of input vars.

    • Create a stored procedure with 5 input parameters and 1 output parameter

    • Use the MAX function to find the maximum value among the input parameters

    • Assign the maximum value to the output parameter

    • Test the stored procedure with sample input values

  • Answered by AI
  • Q2. Pivote table syntax, trigger syntax,
  • Q3. Write a job scheduler code to backup up database daily at a particular time
  • Ans. 

    Code to schedule daily database backup

    • Use SQL Server Agent to create a new job

    • Set the schedule to run daily at the desired time

    • Add a step to the job to backup the database

    • Specify the backup location and file name

    • Test the job to ensure it runs successfully

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Learn syntax properly, complete technical share your screen and write code

Skills evaluated in this interview

Top trending discussions

View All
Interview Tips & Stories
1w (edited)
a team lead
Why are women still asked such personal questions in interview?
I recently went for an interview… and honestly, m still trying to process what just happened. Instead of being asked about my skills, experience, or how I could add value to the company… the questions took a totally unexpected turn. The interviewer started asking things like When are you getting married? Are you engaged? And m sure, if I had said I was married, the next question would’ve been How long have you been married? What does my personal life have to do with the job m applying for? This is where I felt the gender discrimination hit hard. These types of questions are so casually thrown at women during interviews but are they ever asked to men? No one asks male candidates if they’re planning a wedding or how old their kids are. So why is it okay to ask women? Can we please stop normalising this kind of behaviour in interviews? Our careers shouldn’t be judged by our relationship status. Period.
Got a question about WERTMARK TECHNOLOGIES?
Ask anonymously on communities.

Interview questions from similar companies

I applied via Campus Placement and was interviewed before May 2021. There were 4 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 - Aptitude Test 

VERBAL QUANT DI/LR and Picture based test

Round 3 - Technical 

(1 Question)

  • Q1. Write a fibonaci series in c++ or C?
Round 4 - HR 

(1 Question)

  • Q1. Informed about the policies and made us sign a document

Interview Preparation Tips

Interview preparation tips for other job seekers - Just be calm and composed while answering the questions.

Skills evaluated in this interview

Senior SQL Developer Interview Questions Asked at Other Companies

Q1. Write a stored procedure with 5 integer input variables and one i ... read more
Q2. What is performance tuning, and what are its key components?
Q3. Write a job scheduler code to back up the database daily at a par ... read more
Q4. What are the various ways for database optimization?
asked in Healthcius
Q5. How do you split a string to convert single cell data to multiple ... read more

I appeared for an interview before Sep 2020.

Round 1 - Coding Test 

Round duration - 90 minutes
Round difficulty - Easy

This round was held during university hours and consisted of 2 coding questions.

Round 2 - Face to Face 

(1 Question)

Round duration - 120 minutes
Round difficulty - Easy

Make sure you do no cutting and are clear about the approach you'd be following. 
 

  • Q1. What is the running median of an input stream?
  • Ans. 

    Running median of an input stream is the median value of the numbers seen so far in a continuous stream of data.

    • Maintain two heaps - a max heap for the lower half of the numbers and a min heap for the upper half.

    • Keep the number of elements in the two heaps balanced or differ by at most 1.

    • If the total number of elements is odd, the median is the root of the max heap. If even, it is the average of the roots of the two he...

  • Answered by AI

Interview Preparation Tips

Professional and academic backgroundI completed Electronics & Communication Engineering from TIET - Thapar Institute of Engineering And Technology. I applied for the job as SDE - 1 in HyderabadEligibility criteria 7 CGPA Amazon interview preparation:Topics to prepare for the interview - Data Structures and Algorithms, Java, Object-Oriented Programming System, System Design, Operating System.Time required to prepare for the interview - 2 MonthsInterview preparation tips for other job seekers

Prepare for company-wise interview questions according to the company in which you are applying. Try to write the code yourself and if got stuck in between then take help from the internet. I recommend you Codezen of Coding Ninjas for practicing Data Structures and Algorithms based questions.

Application resume tips for other job seekers

Be sure 100% of what you write in your resume and prepare for that before the interview what is written on resume.

Final outcome of the interviewSelected

Skills evaluated in this interview

Interview Questionnaire 

1 Question

  • Q1. Tell me about software system

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

Interview Questionnaire 

1 Question

  • Q1. What is abstract class, what is list, SQL,ADO.net
  • Ans. 

    Abstract class is a class that cannot be instantiated, List is a collection of objects, SQL is a language used to manage databases, ADO.net is a framework for accessing databases.

    • Abstract class is used as a base class for other classes

    • List is a generic collection of objects

    • SQL is used to create, modify, and query databases

    • ADO.net provides a set of classes for accessing databases

    • Example: abstract class Animal { public a...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - The interviewer wanted to test both my knowledge and communication skills. most of asked to me Dot net quetions.

Skills evaluated in this interview

I applied via Company Website and was interviewed before Jan 2021. There were 5 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Tell me about yourself?
  • Q2. Normalization concept,Java basics inheritance overloading, encapsulation ,update table ,related to projects in final year
  • Q3. Situation based questions based on project

Interview Preparation Tips

Interview preparation tips for other job seekers - Be calm and confident and be genuine whatever you explain that should be very specific to question and if u are feeling narvous then put a gentle smile on your face,if you don't know about question ask then try little bit and say sir I will read about this.
All the Best😊😊

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

Interview Questionnaire 

4 Questions

  • Q1. Tell me about yourself?
  • Q2. What are your Strengths?
  • Q3. What are your Weakness?
  • Q4. What are your salary expectations?

Interview Preparation Tips

Interview preparation tips for other job seekers - Do your Homework?
Practice
Provide evidence &Data
Are these interview questions helpful?

I applied via Referral and was interviewed before Jun 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 tips
Round 2 - Coding Test 

Java, program logic, software engineering

Interview Preparation Tips

Topics to prepare for Infosys Software Developer interview:
  • Java
Interview preparation tips for other job seekers - Be sharp and alert, focus on topics that you know. Work your way up

I applied via Walk-in and was interviewed before Feb 2021. There were 3 interview rounds.

Round 1 - Assignment 
Round 2 - HR 

(7 Questions)

  • Q1. Share details of your previous job.
  • Q2. Why should we hire you?
  • Q3. What are your salary expectations?
  • Q4. What is your family background?
  • Q5. What are your strengths and weaknesses?
  • Q6. Tell me about yourself.
  • Q7. This opportunity is really excited for me
Round 3 - HR 

(7 Questions)

  • Q1. What are your salary expectations?
  • Q2. What is your family background?
  • Q3. Share details of your previous job.
  • Q4. What are your strengths and weaknesses?
  • Q5. Tell me about yourself.
  • Q6. Describe any difficult work situation or project that you have handled
  • Ans. 

    Handled a difficult project involving complex data migration and integration

    • Had to understand the existing data structure and map it to the new system

    • Dealt with multiple data sources and formats

    • Ensured data integrity and accuracy throughout the migration process

    • Collaborated with cross-functional teams to ensure successful integration

    • Implemented automated testing to validate data migration and integration

    • Managed project...

  • Answered by AI
  • Q7. Hard work and smart work
  • Ans. Reaching the building through steps is hard work ,smart work life is smart 6 the uses steps definitely .. reach the destination
  • Answered Anonymously

Interview Preparation Tips

Topics to prepare for Wipro Software Developer interview:
  • Software developer
  • Flash Animation
  • 3D Character Animation
  • Photography
  • Photoshop
  • Basic
  • Logo Design
Interview preparation tips for other job seekers - In my opinion,both are the key of success hardwork give experiences and smart work come from experience so both are important to achieve success

I applied via Walk-in and was interviewed in Jan 2020. There were 3 interview rounds.

Interview Questionnaire 

5 Questions

  • Q1. Basic structure of an HTML page
  • Ans. 

    Basic structure of an HTML page includes doctype declaration, html, head, and body tags.

    • DOCTYPE declaration specifies the HTML version

    • HTML tag wraps the entire content of the page

    • Head tag contains meta information, title, and links to external resources

    • Body tag contains the visible content of the page

  • Answered by AI
  • Q2. What is the difference between padding and margin?
  • Q3. What is Box Model?
  • Ans. 

    Box Model is a concept in CSS where every element is treated as a box with content, padding, border, and margin.

    • Box Model consists of content, padding, border, and margin.

    • Content is the actual content of the box.

    • Padding is the space between the content and the border.

    • Border is the line that goes around the padding and content.

    • Margin is the space outside the border.

  • Answered by AI
  • Q4. What are different types of directives in Angular?
  • Q5. Difference between JIT compiler and AOT?

Interview Preparation Tips

Interview preparation tips for other job seekers - Try to answer 80 % of the questions you are asked, you will be able to crack the interview

Skills evaluated in this interview

WERTMARK TECHNOLOGIES Interview FAQs

How many rounds are there in WERTMARK TECHNOLOGIES Senior SQL Developer interview?
WERTMARK TECHNOLOGIES interview process usually has 2 rounds. The most common rounds in the WERTMARK TECHNOLOGIES interview process are Resume Shortlist and Technical.
What are the top questions asked in WERTMARK TECHNOLOGIES Senior SQL Developer interview?

Some of the top questions asked at the WERTMARK TECHNOLOGIES Senior SQL Developer interview -

  1. write an sp to with 5 input var and one output var,all int and display the max ...read more
  2. write a job scheduler code to backup up database daily at a particular t...read more
  3. pivote table syntax, trigger synt...read more

Tell us how to improve this page.

Overall Interview Experience Rating

3/5

based on 1 interview experience

Difficulty level

Hard 100%

Duration

Less than 2 weeks 100%
View more

Interview Questions from Similar Companies

TCS Interview Questions
3.6
 • 11.1k Interviews
Accenture Interview Questions
3.7
 • 8.7k Interviews
Infosys Interview Questions
3.6
 • 7.9k Interviews
Wipro Interview Questions
3.7
 • 6.1k Interviews
Cognizant Interview Questions
3.7
 • 5.9k Interviews
Amazon Interview Questions
4.0
 • 5.4k Interviews
Capgemini Interview Questions
3.7
 • 5.1k Interviews
Tech Mahindra Interview Questions
3.5
 • 4.2k Interviews
HCLTech Interview Questions
3.5
 • 4.2k Interviews
Genpact Interview Questions
3.7
 • 3.4k Interviews
View all
Compare WERTMARK TECHNOLOGIES with

TCS

3.6
Compare

Accenture

3.7
Compare

Wipro

3.7
Compare

Cognizant

3.7
Compare
write
Share an Interview