EFKON INDIA Product Manager Interview Questions and Answers

2 hrs test , had questions from various filed of aptitude

2 hrs test online
had questions from dynamic prog

About current project and roles and resposibilities etc

Q1. SQL COMPLEX QUERIES and PL SQL, CRON JOBS, SERVICE NOW
Add your answer
Q2. What are difference between SQL and PL SQL
Ans. 
SQL is a standard language for managing relational databases, while PL/SQL is a procedural language extension for SQL.
• SQL is a standard language for querying and manipulating data in relational databases.

• PL/SQL is a procedural language extension for SQL, allowing for more complex programming logic.

• SQL is used for data manipulation and retrieval, while PL/SQL is used for writing stored procedures and functions.

• SQL state...read more
Answered by AI
Add your answer
Q3. Explain types of joins?
Ans. 
Types of joins are used in databases to combine rows from two or more tables based on a related column between them.
• Inner Join: Returns rows when there is at least one match in both tables.

• Left Join (or Left Outer Join): Returns all rows from the left table and the matched rows from the right table.

• Right Join (or Right Outer Join): Returns all rows from the right table and the matched rows from the left table.

• Full Join...read more
Answered by AI
Add your answer
Q4. Diffence between correlated and non correlated subquary?
Ans. 
Correlated subquery refers to a subquery that is dependent on the outer query, while non-correlated subquery can be executed independently.
• Correlated subquery is executed for each row processed by the outer query, while non-correlated subquery is executed only once.

• Correlated subquery is slower in performance compared to non-correlated subquery.

• Example: SELECT * FROM table1 WHERE column1 = (SELECT MAX(column2) FROM tab
Answered by AI
Add your answer
Q5. Find departement wise total sal?
Ans. 
To find department wise total salary, sum up the salaries of employees in each department.
• Group employees by department

• Calculate total salary for each department

• Display department wise total salary
Answered by AI
Add your answer

Q1. Exception handler
Add your answer
Q2. Threads in java
Ans. 
Threads in Java allow for concurrent execution of multiple tasks within a single program.
• Threads are instances of the java.lang.Thread class.

• They allow for parallel execution of code segments.

• Threads can be created by extending the Thread class or implementing the Runnable interface.

• Example: Thread t1 = new Thread(new MyRunnable()); t1.start();
Answered by AI
Add your answer

Q1. Explain about real-time project scenario
Ans. 
Real-time project scenario involves monitoring and controlling processes as they happen, ensuring timely responses and adjustments.
• Real-time data collection and analysis

• Immediate feedback and decision-making

• Continuous monitoring and optimization

• Examples: real-time monitoring of manufacturing processes, real-time traffic management systems
Answered by AI
Add your answer

Q1. Daily activities
Add your answer

Q1. What do you understand by NFRs?
Ans. 
NFRs stand for Non-Functional Requirements, which are criteria that specify how a system should behave, rather than what it should do.
• NFRs define the quality attributes of a system, such as performance, security, usability, and scalability.

• They are often related to the user experience and overall satisfaction with the product.

• Examples of NFRs include response time, availability, reliability, and compliance with industr
Answered by AI
Add your answer
Q2. How would you deal with requirements being presented to you?
Ans. 
I would carefully analyze and prioritize the requirements, communicate with stakeholders, and create a detailed plan for implementation.
• Analyze the requirements to understand the scope and impact on the product

• Prioritize the requirements based on business goals and user needs

• Communicate with stakeholders to gather feedback and ensure alignment

• Create a detailed plan for implementation, including timelines and resources

• I...read more
Answered by AI
Add your answer
Q3. How do you usually conduct product discovery?
Ans. 
I conduct product discovery through user research, market analysis, competitor analysis, and prototyping.
• Conduct user interviews to understand needs and pain points

• Analyze market trends and customer feedback

• Research competitors to identify gaps and opportunities

• Create prototypes to test and validate ideas
Answered by AI
Add your answer

Q1. Finance marketing based questions
Add your answer
Q2. Equity and fixed income products related questions
Add your answer

Q1. What are the different types of entities?
Add your answer
Q2. What is a typelist?
Add your answer