KC Overseas Education Senior Software Engineer Interview Questions and Answers

Q1. Practical questions regarding database like sp,trigger,rank
Add your answer
Q2. Difference b/w sp and function
Ans. 
Stored procedures are precompiled SQL queries stored in the database, while functions are blocks of code that can be called within SQL queries.
• Stored procedures are stored in the database and can be called using a specific name.

• Functions are defined using CREATE FUNCTION and can be called within SQL queries.

• Stored procedures can have input and output parameters, while functions can only return a single value.

• Stored pro...read more
Answered by AI
Add your answer

Q1. Salary negotiations
Add your answer

Q1. Basic Questions based on pervious project
Add your answer

Q1. Data structures
Add your answer

Q1. System Design fundamentals
Add your answer

Q1. System Design questions
Add your answer

Q1. What do you think about the negative news going around the company
Add your answer

Q1. Why join this company
Add your answer

Q1. Explain about Android lifecycle
Ans. 
Android lifecycle refers to the series of states that an activity or fragment goes through from creation to destruction.
• Android lifecycle includes states like onCreate, onStart, onResume, onPause, onStop, onDestroy, etc.

• Activities and fragments transition between these states based on user interactions and system events.

• Understanding Android lifecycle is crucial for managing resources, saving state, and handling config...read more
Answered by AI
Add your answer
Q2. Explain about fragment lifecycle
Ans. 
Fragment lifecycle refers to the series of events that occur in the lifespan of a fragment in an Android app.
• Fragments go through various states like created, started, resumed, paused, stopped, and destroyed.

• Fragment lifecycle methods include onCreate(), onCreateView(), onResume(), onPause(), onStop(), onDestroy(), etc.

• Fragment lifecycle is closely tied to the hosting activity's lifecycle.

• Understanding fragment lifecyc...read more
Answered by AI
Add your answer

Q1. Question on Binary trees: if symmetric, easy string question using hashmap
Add your answer
Q2. If we are hosting a live test how to show real time ranking, HLD for this and what algorithms can we use
Add your answer

Q1. Database schema design for a feature where user can be free, gold, platinum.
Ans. 
Use a user table with a column for user type (free, gold, platinum)
• Create a user table with columns for user ID, name, email, user type

• Use a separate table for user types with columns for type ID and type name

• Establish a one-to-many relationship between user and user type tables

• Example: user table - user_id, name, email, type_id; user_type table - type_id, type_name
Answered by AI
Add your answer

Q1. HLD for live rank dashboard for a live test where millions of users are doing test
Ans. 
High-level design for a live rank dashboard for a live test with millions of users.
• Use a scalable architecture to handle millions of users concurrently.

• Implement real-time data processing to update ranks dynamically.

• Utilize caching mechanisms to improve performance and reduce load on the database.

• Design a user-friendly interface with intuitive data visualization.

• Include features for filtering, sorting, and searching to
Answered by AI
Add your answer

Aptitude test with situations based questions

Q1. About past experience,Case studies
Add your answer