AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
WERTMARK TECHNOLOGIES Senior SQL Developer Interview Questions and Answers
WERTMARK TECHNOLOGIES Senior SQL Developer Interview Experiences
1 interview found
Anonymous
I applied via Recruitment Consulltant and was interviewed in Feb 2023. There were 2 interview rounds.
(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
- 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
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
I applied via Company Website and was interviewed before Jun 2021. There were 2 interview rounds.
First round was coding as well as aptitude done together went well I guess focusing on codes helps a lot.
(1 Question)
- Q1. 2nd round included tr and mr round went quite enegritic
Interview Preparation Tips
Trisha Kundu
I applied via Campus Placement and was interviewed in Apr 2020. There was 1 interview round.
Interview Questionnaire
2 Questions
- Q1. Are you willing to relocate?
- Ans.
Yes, I am open to relocating for the right opportunity that aligns with my career goals and personal growth.
Relocation can provide exposure to new technologies and methodologies.
I am excited about the prospect of working in diverse teams and cultures.
For example, moving to a tech hub like San Francisco could enhance my career.
I understand the challenges of relocating, but I see them as opportunities for growth.
- Q2. Why should I hire you?
- Ans.
I bring a unique blend of skills, experience, and passion for software development that aligns perfectly with your team's goals.
Proven experience in developing scalable applications, such as a recent project where I improved performance by 30%.
Strong problem-solving skills demonstrated through my contributions to open-source projects, enhancing functionality and fixing bugs.
Excellent teamwork and communication abilitie...
Interview Preparation Tips
I applied via LinkedIn and was interviewed before Jul 2021. There were 2 interview rounds.
Easy logical questions
basic quant
Easy level coding questions
Counting frequency of alphabets
Interview Preparation Tips
Hoisting
Siddhesh Hirulkar
Interview Questionnaire
1 Question
- Q1. How to use multiple dispatch in redux?
- Ans.
Multiple dispatch is not a feature of Redux. It can be achieved using middleware or custom logic.
Middleware like redux-thunk or redux-saga can be used to dispatch multiple actions based on a single action.
Custom logic can be implemented in the reducer to handle multiple actions based on a single action type.
For example, a single 'ADD_ITEM' action can trigger multiple actions like 'UPDATE_TOTAL', 'UPDATE_HISTORY', etc.
M...
Skills evaluated in this interview
I applied via Campus Placement and was interviewed before Jun 2020. There were 3 interview rounds.
Interview Questionnaire
2 Questions
- Q1. Simple program
- Q2. I wrote a simple program in C
Interview Preparation Tips
I applied via Naukri.com and was interviewed before Oct 2019. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. What technical challenges have you faced in your work till now and how did you overcome it?
- Ans.
Faced various technical challenges, including system integration and performance optimization, which I successfully navigated through strategic solutions.
Integration of legacy systems with modern applications: I utilized APIs and middleware to ensure seamless data flow.
Performance bottlenecks in a web application: Implemented caching strategies and optimized database queries, resulting in a 40% speed increase.
Debugging...
Interview Preparation Tips
Manmeet Sinha
I applied via Walk-in and was interviewed before Sep 2019. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. 1.Technical Ques(OOPS Concept)and 2. Area of Interest 3. About Company 4. more
Interview Preparation Tips
Sharing some tips while facing Interview Assessment or GD Round Assessment.
1. Be Confident always give the answer what they ask for, Never connect your answer with different topic.
2. Always go through Company Portal or wiki about their Operation & Function.
3. Always have positive vibes that whatever yes or No, You will surely gain something.
All the Best..!!
I applied via Naukri.com and was interviewed before Apr 2020. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Technical questions
Interview Preparation Tips
Interview Questionnaire
3 Questions
- Q1. Tell me something about yourself
- Ans.
I am a passionate software developer with 5 years of experience in developing web applications using various technologies.
5 years of experience in software development
Proficient in developing web applications
Skilled in using various technologies
Passionate about coding and problem-solving
- Q2. What is the difference between encapsulation and polymorphism?
- Q3. What do you mean by deadlock in OS?
- Ans.
Deadlock is a situation in which two or more processes are unable to proceed because each is waiting for the other to release a resource.
Deadlock occurs when two or more processes are stuck in a circular waiting state.
It happens when processes compete for resources and each process holds a resource that another process needs.
Four necessary conditions for deadlock are mutual exclusion, hold and wait, no preemption, and ...
Interview Preparation Tips
Experience: We were asked to solve a questionnaire containing 25 questions based on logical reasoning and basic mathematics. We went to the test center in their recruitment center where there were many desktops for the candidates to sit and give the test. At the entrance, they checked the letter we got from them to authenticate us.Then they gave us a login ID and password. Exactly when the test started, the portal became active and we were asked to enter the credentials. I completed the test in half the time as it was pretty easy and straightforward.
Tips: Practice simple aptitude questions for greater speed and accuracy.
Duration: 1 hour
Total Questions: 20
Round: Group Discussion
Experience: Ten candidates who were shortlisted from the written test attended the group discussion. The topic given to us was fairly simple and lucky for me, I used to work as an anchor, and being a strong feminist person, I had a lot of valid points to put forward. I was the one to start the discussion, and I felt I was the best speaker there. The topic was something that I follow regularly, yet I came across a few unique points from the other candidates.
Tips: Improve your English speaking skills. Be assertive and speak concisely.
Duration: 15 minutes
Round: HR Interview
Experience: The interview basically revolved around this one question which had a few follow-up questions, such as who all are there in my family, what are my strengths and weaknesses, and why am I fit for this job.
Tips: Be confident and honest about yourself.
Round: Technical Interview
Experience: I tried to be as calm and confident as possible during the whole of the interview
College Name: Guru Nanak Institute of Technology (GNIT)
Skills evaluated in this interview
WERTMARK TECHNOLOGIES Interview FAQs
Some of the top questions asked at the WERTMARK TECHNOLOGIES Senior SQL Developer interview -
Tell us how to improve this page.
Interview Questions for Popular Designations
- Software Developer Interview Questions
- Java Developer Interview Questions
- Senior Engineer Interview Questions
- Senior Consultant Interview Questions
- Web Developer Interview Questions
- Senior Software Developer Interview Questions
- Application Developer Interview Questions
- Salesforce Developer Interview Questions
- Show more
Overall Interview Experience Rating
based on 1 interview experience
Difficulty level
Duration
Interview Questions from Similar Companies
TCS
Accenture
Wipro
Cognizant
- Home >
- Interviews >
- WERTMARK TECHNOLOGIES Interview Questions
