Zidio Development HR Executive Interview Questions and Answers

Quant, Verbal, DI, Reasoning etc

Domain Based MCQ and 1 SQL Query + 1 Programming question

Q1. 1. Introduction 2. Project Explaination 3. DSA Questions: a) Strings b) Trees c) Graphs 4. What is Stream Processing?
Add your answer

Q1. 1.Ask about yourself 2.From which city you come from? 3. SWOT Analysis
Add your answer

Q1. What is your experience
Add your answer
Q2. Reverse given string
Ans. 
Reverse a given string
• Use a loop to iterate through the characters of the string and build a new string in reverse order

• Alternatively, you can use built-in functions like reverse() or StringBuilder in some programming languages
Answered by AI
Add your answer
Q3. How to find if string is palindrome
Ans. 
Check if a string reads the same forwards and backwards
• Iterate through the string from both ends and compare characters

• Use built-in functions like reverse() or slice() to check for palindrome

• Ignore spaces and punctuation when checking for palindrome
Answered by AI
Add your answer

Questions were moderate but we need to manage time to clear this round

Q1. Asked to tell about me
Add your answer
Q2. Questions on OOPS concept
Add your answer
Q3. And basic To moderate SQL questions
Add your answer
Q4. Question on DSA
Add your answer

Q1. Asked me to tell about me
Add your answer
Q2. And asked about my projects
Add your answer
Q3. Asked me to tell what my expectations are from Kanerika
Add your answer

70 questions in 90 minutes with 7 sections

Q1. Introduce yourself
Add your answer
Q2. Project description
Ans. 
Developed a web application for tracking project progress and managing tasks
• Used React.js for front-end development

• Implemented RESTful APIs using Node.js and Express for back-end

• Utilized MongoDB for database storage

• Incorporated authentication and authorization features for user security
Answered by AI
Add your answer
Q3. Second highest salary
Ans. 
To find the second highest salary in a table, you can use a SQL query with the MAX() function and a subquery.
• Use a SQL query to select the MAX() salary from the table.

• Use a subquery to select the MAX() salary that is less than the overall MAX() salary.

• Combine both queries to get the second highest salary.
Answered by AI
Add your answer
Q4. What is indexing
Ans. 
Indexing is a technique used to optimize the performance of databases by creating a data structure that allows for quick retrieval of data.
• Indexing involves creating a data structure that maps the values of specific columns in a database table to their physical location on disk.

• It helps in speeding up data retrieval operations by allowing the database to quickly locate the rows that match a certain condition.

• Examples o...read more
Answered by AI
Add your answer

Q1. Introduce 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

• Team player with excellent communication skills
Answered by AI
Add your answer
Q2. Project description
Ans. 
Developed a web application for tracking project progress and managing tasks
• Used React.js for front-end development

• Implemented RESTful APIs using Node.js and Express for back-end

• Utilized MongoDB for database storage

• Incorporated authentication and authorization features for user security
Answered by AI
Add your answer
Q3. Difference between truncate and delete
Ans. 
Truncate is a DDL command that removes all records from a table, while delete is a DML command that removes specific records.
• Truncate is faster than delete as it does not log individual row deletions.

• Truncate resets the identity seed of the table, while delete does not.

• Truncate cannot be rolled back, while delete can be rolled back using a transaction.

• Truncate does not fire triggers, while delete does.
Answered by AI
Add your answer

Q1. Why you join company
Add your answer
Q2. Where you see yourself after 5 years
Ans. 
In 5 years, I see myself as a senior software developer leading a team and working on cutting-edge technologies.
• Leading a team of developers on innovative projects

• Continuing to enhance my technical skills and knowledge

• Contributing to the growth and success of the company

• Possibly pursuing further education or certifications in software development
Answered by AI
Add your answer

Q1. Tech questions asked by non tech interviewers
Add your answer

Q1. Management related questions
Add your answer

Q1. Ask Salary expectations which you tell to HR during initial conversations
Add your answer

Q1. Repetitive Tech questions
Add your answer

Q1. There are two to three rounds generally first and second round are technical rounds which includes theory as well as coding problem.
Add your answer

Q1. Similar to round 1
Add your answer

Q1. This is managerial round which deals with personality check and work ethics.
Add your answer

Create The Given Design

Q1. Discussion of Approach to solve
Add your answer

Q1. What is Hoisting?
Ans. 
Hoisting is a JavaScript mechanism where variable and function declarations are moved to the top of their containing scope during compilation.
• Variable and function declarations are hoisted to the top of their scope.

• Only declarations are hoisted, not initializations.

• Function declarations take precedence over variable declarations.

• Hoisting can lead to unexpected behavior if not understood properly.
Answered by AI
Add your answer
Q2. What is Closures?
Ans. 
Closures are functions that have access to variables from their containing scope even after the parent function has finished executing.
• Closures allow functions to maintain access to variables from their outer scope

• They are created when a function is defined within another function

• Closures are commonly used in event handlers and callbacks
Answered by AI
Add your answer
Q3. What is Promises?
Ans. 
Promises are a way to handle asynchronous operations in JavaScript, providing a cleaner alternative to callbacks.
• Promises represent the eventual completion (or failure) of an asynchronous operation.

• They allow you to chain multiple asynchronous operations together.

• Promises have states: pending, fulfilled, or rejected.

• You can handle the result of a promise using .then() and .catch() methods.

• Example: const myPromise = new
Answered by AI
Add your answer
Q4. What is Callback Hell?
Ans. 
Callback Hell is a situation in asynchronous programming where multiple nested callbacks make the code hard to read and maintain.
• Occurs when multiple asynchronous operations are nested within each other

• Leads to deeply nested code which is hard to read and maintain

• Can be avoided by using Promises or async/await syntax
Answered by AI
Add your answer
Q5. What is Async/Await ?
Ans. 
Async/Await is a feature in JavaScript that allows for asynchronous programming using promises.
• Async/Await is syntactic sugar built on top of promises in JavaScript.

• It allows for writing asynchronous code that looks synchronous, making it easier to read and maintain.

• Async functions return a promise, which allows for chaining multiple asynchronous operations.

• Await keyword is used inside async functions to wait for a pro...read more
Answered by AI
Add your answer

Q1. Code A Todo List in React ?
Ans. 
A simple Todo List app built using React
• Create a new React project using create-react-app

• Create a Todo component to display the list of todos

• Use state to manage the list of todos and input field for adding new todos

• Implement functionality to add, delete, and mark todos as completed
Answered by AI
Add your answer
Q2. Difference Between RestApi and Graphql ?
Ans. 
REST API is a standard protocol for web services using HTTP, while GraphQL is a query language for APIs.
• REST API follows a client-server architecture with stateless communication, while GraphQL allows clients to request only the data they need.

• REST API typically uses multiple endpoints for different resources, while GraphQL uses a single endpoint for flexible data retrieval.

• REST API has predefined data structures, whil...read more
Answered by AI
Add your answer