Home
Communities
Companies
- Companies
  
  Discover best places to work
- Compare Companies
  
  Compare & find best workplace
- Add Office Photos
  
  Bring your workplace to life
- Add Company Benefits
  
  Highlight your company's perks
Reviews
- Company reviews
  
  Read reviews for 6L+ companies
- Write a review
  
  Rate your former or current company
Salaries
- Browse salaries
  
  Discover salaries for 6L+ companies
- Salary calculator
  
  Calculate your take home salary
- Are you paid fairly?
  
  Check your market value
- Share your salary
  
  Help other jobseekers
- Gratuity calculator
  
  Check your gratuity amount
- HRA calculator
  
  Check how much of your HRA is tax-free
- Salary hike calculator
  
  Check your salary hike
Interviews
- Company interviews
  
  Read interviews for 40K+ companies
- Campus placements
  
  Interviews questions for 2K+ colleges
- Share interview questions
  
  Contribute your interview questions
Jobs
Awards

WINNERS AWAITED!
- ABECA 2025
  
  WINNERS AWAITED!
  
  AmbitionBox Employee Choice Awards - 4th Edition
- ABECA 2024
  
  AmbitionBox Employee Choice Awards - 3rd Edition
- AmbitionBox Best Places to Work 2022
  
  2nd Edition
- AmbitionBox Best Places to Work 2021
  
  1st Edition

Add office photos

Employer? Claim Account for FREE

WERTMARK TECHNOLOGIES

Compare

3.6

based on 3 Reviews

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

Senior SQL Developer Interview Questions & Answers

Anonymous

posted on 28 Mar 2023

Interview experience

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

Add your answer

Q2. Pivote table syntax, trigger syntax,

Add your answer

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

Add your answer

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

I have been shortlisted for an interview at Bloomberg for the investment / real estate reporter role. How can I prepare for the interview? What all do I need to keep in mind for my prep? Please help, I am very nervous! Thank you

Got a question about WERTMARK TECHNOLOGIES?

Ask anonymously on communities.

Interview questions from similar companies

Software Developer Interview Questions & Answers

TCS

Ashish Kumar

posted on 15 Dec 2021

I applied via Company Website and was interviewed before Dec 2020. There were 4 interview rounds.

Interview Questionnaire

1 Question

Q1. Questions on Java,SQL,some trending technologies(IOT,Big data),pattern questions, programming questions with different approaches.

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare basics of DSA, have knowledge about the databases, some common dml ,ddl statements, programming knowledge of a particular language like C,Java, python,etc...have good command on oops concepts... little bit of frameworks knowledge will also help

Software Developer Interview Questions & Answers

TCS

Anonymous

posted on 18 Jun 2022

I applied via Newspaper Ad and was interviewed before Jun 2021. There were 3 interview rounds.

Round 1 - Aptitude Test

Round 2 - Technical

(1 Question)

Q1. Basic questions of java.

Add your answer

Round 3 - HR

(1 Question)

Q1. Intro and other hr related questions.

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Cover the basic questions regarding the programming language.

Software Developer Interview Questions & Answers

Infosys

Anonymous

posted on 12 Apr 2022

I applied via Referral and was interviewed before Apr 2021. There were 2 interview rounds.

Round 1 - Aptitude Test

Puzzles, Psychometric Test

Round 2 - One-on-one

(1 Question)

Q1. Some water in 3 Jars question, you had to measure out 5L correctly

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Make the interview interactive, I got this input from another Senior. Before i went into the interview room the volunteers were telling all those who goes into Room No 1 is screwed. I was praying i don't get room no 1. But fortunately for me I got room no 1 because when the interviewer gave me the puzzle and handed over pen and paper he went back to relax his posture and when i explained i will fill the 5L Jar first, he immediately came forward to listen to me, at that moment i knew i got the job because i felt the previous candidates never made their interview interactive and that's why he went back to relax his posture.

Software Developer Interview Questions & Answers

TCS

Anonymous

posted on 29 Jun 2022

I applied via Company Website and was interviewed before Jun 2021. There were 2 interview rounds.

Round 1 - Aptitude Test

First round was coding as well as aptitude done together went well I guess focusing on codes helps a lot.

Round 2 - Technical

(1 Question)

Q1. 2nd round included tr and mr round went quite enegritic

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Resume skills matters a lot don't fill resume the technologies you don't even aware of

Software Developer Interview Questions & Answers

Infosys

Anonymous

posted on 19 Jun 2017

I was interviewed in Sep 2016.

Interview Questionnaire

3 Questions

Q1. Tell me about yourself

Ans.

I am a passionate software developer with experience in Java, Python, and web development.

Experienced in Java, Python, and web development technologies
Strong problem-solving skills and ability to work in a team
Completed multiple projects including a web-based inventory management system

Answered by AI

Add your answer

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 -

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