Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by ZeroCodeHR Team. If you also belong to the team, you can get access from here

ZeroCodeHR Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

ZeroCodeHR Senior Database Developer Interview Questions and Answers

Updated 2 Nov 2024

ZeroCodeHR Senior Database Developer Interview Experiences

1 interview found

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Nov 2023. There were 3 interview rounds.

Round 1 - Coding Test 

SQL Queries on Cursors, complex joins, highest sal, stored procs, funcs asked

Round 2 - Technical 

(3 Questions)

  • Q1. Performance queries on SQL server
  • Ans. 

    Performance tuning queries on SQL server involves optimizing query execution plans and indexing strategies.

    • Use indexes to speed up query performance

    • Avoid using SELECT * and only retrieve necessary columns

    • Optimize joins by using appropriate join types (e.g. INNER JOIN, LEFT JOIN)

    • Consider using stored procedures for frequently executed queries

    • Monitor query performance using tools like SQL Server Profiler

  • Answered by AI
  • Q2. ETL - SSIS, Pentaho related questions
  • Q3. SQL Server Concepts like cursors, triggers, joins etc
Round 3 - HR 

(2 Questions)

  • Q1. Salary negotiations
  • Q2. Personal details etc

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

It’s an average test experience

Round 2 - Coding Test 

Best questions with tricky one

Round 3 - HR 

(1 Question)

  • Q1. Salary expectations
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Referral and was interviewed in Oct 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Promises in javascript
  • Ans. 

    Promises in JavaScript are objects representing the eventual completion or failure of an asynchronous operation.

    • Promises are used to handle asynchronous operations in JavaScript.

    • They can be in one of three states: pending, fulfilled, or rejected.

    • Promises can be chained using .then() to handle success and .catch() to handle errors.

  • Answered by AI

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(3 Questions)

  • Q1. Resume based questions
  • Q2. Event loop in nodejs
  • Ans. 

    Event loop in Node.js manages asynchronous operations by executing callback functions when certain events occur.

    • Event loop is responsible for handling I/O operations, timers, and callbacks in Node.js

    • It allows Node.js to perform non-blocking operations efficiently

    • Event loop continuously checks the event queue for new events to execute

  • Answered by AI
  • Q3. Javascript es6 questions

Skills evaluated in this interview

Interview experience
1
Bad
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Feb 2023. There were 2 interview rounds.

Round 1 - Aptitude Test 

The test was very weird one.
They did have planned anything for the test, They came and given a link on bit.ly and given an another link that is in google form for the answers.
And they selection of people for second round is not sensible.

Round 2 - Coding Test 

This round was also be a weird.
They give each candidates with different questions.
They told us to write logic on the paper and you can use internet for your reference.
But after this round they announced the results but that is not in genuine one.

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't get into this type of process.
Before the start of interview ask them to what is they want from the candidates
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - MCQ 

(1 Question)

  • Q1. Basic dsa questions predict output
Round 2 - Coding Test 

Medium level problem,

Round 3 - HR 

(1 Question)

  • Q1. Based on resume
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-

I applied via Campus Placement and was interviewed in May 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

45 min apps and technical question

Round 2 - Coding Test 

45 min coding round you can refer net for first 15 min

Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Tell Me about yourself
  • Q2. What is C# and coding.
Round 2 - HR 

(1 Question)

  • Q1. What is your CCTC?

Interview Preparation Tips

Interview preparation tips for other job seekers - Consider this company your last choice.
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed before Jul 2023. There was 1 interview round.

Round 1 - One-on-one 

(3 Questions)

  • Q1. What is useState?
  • Ans. 

    useState is a hook in React that allows functional components to have state.

    • useState is a React hook used in functional components to manage state.

    • It returns an array with the current state value and a function to update that value.

    • Example: const [count, setCount] = useState(0);

  • Answered by AI
  • Q2. What's useEffect?
  • Ans. 

    useEffect is a hook in React that allows performing side effects in function components.

    • Used in React functional components to perform side effects

    • Executes after render and after every update

    • Can be used to fetch data, subscribe to events, update the DOM, etc.

  • Answered by AI
  • Q3. What is Redux and state management?
  • Ans. 

    Redux is a predictable state container for JavaScript apps. It helps manage the state of an application in a centralized way.

    • Redux is a state management library commonly used with React.

    • It allows for a single source of truth for the state of an application.

    • Actions are dispatched to update the state, and reducers specify how the state changes in response to actions.

    • Redux DevTools can be used to track state changes and d...

  • Answered by AI

Skills evaluated in this interview

Software Developer Interview Questions & Answers

Sciative Solutions user image 20ECE1008 Anjali Deshpande

posted on 16 Oct 2023

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-

I applied via Campus Placement

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 Resume tips
Round 2 - Coding Test 

2 hrs Python and aptitude

Round 3 - Technical 

(1 Question)

  • Q1. DSA questions with optimized solutions
Contribute & help others!
anonymous
You can choose to be anonymous

ZeroCodeHR Interview FAQs

How many rounds are there in ZeroCodeHR Senior Database Developer interview?
ZeroCodeHR interview process usually has 3 rounds. The most common rounds in the ZeroCodeHR interview process are Coding Test, Technical and HR.
What are the top questions asked in ZeroCodeHR Senior Database Developer interview?

Some of the top questions asked at the ZeroCodeHR Senior Database Developer interview -

  1. Performance queries on SQL ser...read more
  2. SQL Server Concepts like cursors, triggers, joins ...read more
  3. ETL - SSIS, Pentaho related questi...read more

Recently Viewed

INTERVIEWS

Groww

No Interviews

INTERVIEWS

ZeroCodeHR

No Interviews

INTERVIEWS

ZeroCodeHR

No Interviews

INTERVIEWS

ADF Data Science

No Interviews

INTERVIEWS

ADF Data Science

No Interviews

INTERVIEWS

Hiver

No Interviews

INTERVIEWS

MTX Group

No Interviews

INTERVIEWS

Groww

No Interviews

INTERVIEWS

Outcomes Operating India Private Limited

No Interviews

INTERVIEWS

ZeroCodeHR

No Interviews

Tell us how to improve this page.

ZeroCodeHR Senior Database Developer Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

PeopleStrong Interview Questions
3.4
 • 50 Interviews
Darwinbox Interview Questions
3.9
 • 43 Interviews
greytHR Interview Questions
3.8
 • 22 Interviews
View all
Software Engineer
19 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Implementation Analyst
18 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Implementation Analyst
7 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Developer
6 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Analyst
5 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare ZeroCodeHR with

PeopleStrong

3.4
Compare

Darwinbox

3.9
Compare

sumHR - HRMS Software

3.5
Compare

greytHR

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