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 Campus Placement and was interviewed before May 2021. There were 4 interview rounds.
VERBAL QUANT DI/LR and Picture based test
(1 Question)
- Q1. Write a fibonaci series in c++ or C?
(1 Question)
- Q1. Informed about the policies and made us sign a document
Interview Preparation Tips
Skills evaluated in this interview
I appeared for an interview before Sep 2020.
Round duration - 90 minutes
Round difficulty - Easy
This round was held during university hours and consisted of 2 coding questions.
(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...
Interview Preparation Tips
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 seekersBe 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 interviewSelectedSkills 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...
Interview Preparation Tips
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
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
Practice
Provide evidence &Data
I applied via Referral and was interviewed before Jun 2021. There were 2 interview rounds.
Java, program logic, software engineering
Interview Preparation Tips
- Java
I applied via Walk-in and was interviewed before Feb 2021. There were 3 interview rounds.
(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
(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...
- 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
Interview Preparation Tips
- Software developer
- Flash Animation
- 3D Character Animation
- Photography
- Photoshop
- Basic
- Logo Design
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
- 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.
- Q4. What are different types of directives in Angular?
- Q5. Difference between JIT compiler and AOT?
Interview Preparation Tips
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
