ZeroCodeHR Senior Database Developer Interview Questions and Answers

Nuts and bolts game, to output date in a certain format, one SQL query

Q1. Stacks and Queues
Add your answer
Q2. Linked lists, arrays, and many more basic fundamental Dsa questions.
Add your answer

Q1. More about your resume projects.
Add your answer
Q2. Puzzles and reasoning is asked
Add your answer

Data structure and aptitude

10 mins given for prepare for the problem and after completing the problem (program ) they asked to explain and asked to upgrade the program by reduce time complexity

Q1. Topic given and want to explain
Add your answer
Q2. Reverse string without buildin funtion and for loop
Ans. 
Reverse a string without using built-in functions or for loops
• Use recursion to reverse the string

• Pass the substring excluding the first character to the recursive function

• Base case: return the character itself if the length of the string is 1

• Concatenate the last character of the string with the result of the recursive call
Answered by AI
Add your answer

Q1. Introduce your self
Ans. 
I am a passionate software developer with experience in Java, Python, and web development.
• Experienced in Java and Python programming languages

• Skilled in web development technologies like HTML, CSS, and JavaScript

• Worked on projects involving database management with SQL
Answered by AI
Add your answer
Q2. Are you ok with agreement
Ans. 
Yes, I am okay with agreement.
• I am comfortable with signing agreements related to software development projects.

• I understand the importance of agreements in protecting both parties involved in a project.

• I am willing to review and negotiate agreements to ensure they are fair and reasonable.
Answered by AI
Add your answer

Divisibility, LCM, HCF.
Numbers, Decimals, Fractions, Powers.
Profit, Loss.
Simple interest and Compound interest.
Speed, Distance, Time.
Work and wages.
Trains, Boats, Streams-upstream/downstream, Circular track questions.
Cistern and pipes.

Coding interviews test candidates' technical knowledge, coding ability, problem solving skills, and creativity, typically on a whiteboard.

Choose a topic based on the assignment.
2 Conduct research.
3 Write a thesis statement

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
Add your answer

Q1. About self in a short way
Add your answer

It's was appti based on simple logics and SQL questions Java basics mcq

Q1. They will ask SQL and plsql concepts
Add your answer

Discussion on experience and current role and responsibilities

Q1. 1. Discuss one past project
Add your answer
Q2. 2. Design a job scheduler
Ans. 
A job scheduler is a software application that manages the scheduling of tasks or jobs to be executed by a computer system.
• Define the job scheduling requirements such as priority, deadline, resource constraints, etc.

• Implement a scheduling algorithm like First Come First Serve, Shortest Job First, Round Robin, etc.

• Maintain a queue of jobs to be executed and allocate resources accordingly.

• Monitor job execution and handle...read more
Answered by AI
Add your answer

There were 50 question out of which if you score 20 you were passed out to next round, No negative markings.