KEKA TECHNOLOGIES Software Developer 1 Interview Questions and Answers

Basic DSA questions, best time to buy and sell stock and its variation

Q1. Basic nosql vs sql questions
Add your answer
Q2. Designing system for google playstore
Add your answer

Q1. Discuss the project you are most proud of
Ans. 
Developed a mobile app for tracking personal fitness goals
• Used React Native to create a cross-platform app

• Implemented features such as goal setting, progress tracking, and workout logging

• Integrated with wearable devices like Fitbit for automatic data syncing
Answered by AI
Add your answer
Q2. What are ways to speed up SQL queries? List them in increasing order of complexity?
Ans. 
Ways to speed up SQL queries in increasing order of complexity
• Use indexes on columns frequently used in WHERE clauses

• Optimize queries by avoiding unnecessary joins and subqueries

• Use stored procedures to reduce network traffic and improve performance

• Consider denormalizing tables for frequently accessed data

• Use query optimization techniques like query caching and query hints
Answered by AI
Add your answer
Q3. Is Redis single-threaded or multi-threaded?
Ans. 
Redis is single-threaded.
• Redis is single-threaded, meaning it can only execute one command at a time.

• This design choice allows Redis to be extremely fast and efficient for certain use cases.

• However, it also means that Redis may not be the best choice for highly concurrent workloads.
Answered by AI
Add your answer
Q4. What sort of data types can be used as keys in Python?
Ans. 
Data types that can be used as keys in Python include strings, integers, floats, tuples, and custom objects.
• Strings are commonly used as keys in Python dictionaries.

• Integers and floats can also be used as keys.

• Tuples can be used as keys if they only contain immutable elements.

• Custom objects can be used as keys if they are hashable.

• Examples: {'name': 'John'}, {1: 'apple'}, {(1, 2): 'tuple'}
Answered by AI
Add your answer
Q5. What types of indexing exist in SQL?
Ans. 
Types of indexing in SQL include clustered, non-clustered, unique, and composite indexes.
• Clustered index physically reorders the table based on the index key

• Non-clustered index creates a separate structure for the index

• Unique index ensures that all values in the index column are unique

• Composite index uses multiple columns for indexing
Answered by AI
Add your answer

Java internals, coding questions 2sum

Q1. Hld of your previous project
Ans. 
Developed a web-based project management tool for tracking tasks and deadlines.
• Used React.js for front-end development

• Implemented RESTful APIs for backend using Node.js and Express

• Utilized MongoDB for database storage

• Incorporated authentication and authorization features for user security
Answered by AI
Add your answer
Q2. Question related to self build projects
Add your answer

Q1. Salary negotiation
Add your answer
Q2. Location constrain if any
Ans. 
Open to relocation for the right opportunity
• Willing to relocate for the right job opportunity

• Flexible with location for the right role

• Open to considering different locations for the right position
Answered by AI
Add your answer

Q1. They asked to design a database table
Add your answer

2 Leetcode Medium questions on hackerrank

Q1. Kadane algorithm based question
Add your answer
Q2. Leetcode medium
Add your answer
Q3. Resume based questions
Add your answer

Q1. Probability question math problem
Add your answer
Q2. Puzzle to solve
Add your answer
Q3. AI based question
Add your answer
Q4. 1 question to solve Leetcode medium
Add your answer

25 questions , 1 hour

1 coding , 2 logical question

Q1. For loop , 2 logical
Add your answer
Q2. About final year projrct
Add your answer

First round was coding test conducted by their IDE where you can program in any language like on hackerrank IDE . 5 question were asked from easy to hard

Q1. They ask me about my though on social media
Add your answer
Q2. They give me a situation to handle the work load
Add your answer

Q1. Difference between stack and heap ?
Ans. 
Stack is used for static memory allocation and stores local variables, while heap is used for dynamic memory allocation and stores objects.
• Stack memory is allocated in a contiguous block and is faster to access compared to heap memory.

• Variables stored on the stack have limited scope and lifetime, while objects on the heap can persist beyond the scope of the function.

• Stack memory is managed by the compiler, while heap m...read more
Answered by AI
Add your answer
Q2. Difference between complier and interpreter ?
Ans. 
Compiler translates entire code into machine code before execution, while interpreter translates code line by line during execution.
• Compiler translates entire code into machine code before execution

• Interpreter translates code line by line during execution

• Compiler generates error messages after scanning entire code

• Interpreter stops at first error encountered

• Examples: C, C++ use compilers; Python, Ruby use interpreters
Answered by AI
Add your answer

Q1. My introduction
Add your answer
Q2. I can i mange to work proficiency
Add your answer

Medium to hard questions based on arrays, dp

Q1. Quick sort algorithm
Ans. 
Quick sort is a popular sorting algorithm that uses divide and conquer strategy.
• Divides array into smaller sub-arrays based on a pivot element

• Recursively sorts sub-arrays

• Combines sorted sub-arrays to get final sorted array

• Time complexity: O(n log n) on average, O(n^2) worst case

• Example: [3, 6, 8, 10, 1, 2, 1] -> [1, 1, 2, 3, 6, 8, 10]
Answered by AI
Add your answer
Q2. Modified rotate a matrix
Ans. 
Rotate a matrix by 90 degrees in place
• Transpose the matrix

• Reverse each row of the transposed matrix
Answered by AI
Add your answer