Pelican.ai Software Engineer Trainee Interview Questions and Answers

2 DSA Questions and questions from springboot for java

Q1. Build Project in springboot and asked questions from the same
Add your answer

Q1. System design questions for High level design
Add your answer

Q1. Behavioral round asked question about the organization.
Add your answer

It was leetcode questions for 60 min for 2 questions.

Q1. Tell me about your self
Add your answer

Q1. Tell me about your work experience
Add your answer

Given a text need to understand and solve

Some Java based and system design api was allowed to made

Q1. Introduction of myself
Add your answer
Q2. Salary discussion was done
Add your answer

10 mcq, 2 dsa, 1 assignment question

Q1. Javascript basics
Add your answer
Q2. Previous projects
Ans. 
Developed a web application for tracking inventory and sales data
• Used React for front-end development

• Implemented RESTful APIs for backend using Node.js

• Utilized MongoDB for database storage
Answered by AI
Add your answer

Q1. Behavorial questions
Add your answer

Q1. What is closure? Application and concept understanding
Ans. 
Closure is a function that captures the environment in which it was created, allowing it to access variables from that environment even after the function has finished executing.
• Closure allows a function to access variables from its outer scope even after the function has finished executing.

• It 'closes over' the variables from the outer scope, preserving their values.

• Example: function outerFunction() { let outerVar = 'I...read more
Answered by AI
Add your answer
Q2. What is event loop?
Ans. 
Event loop is a mechanism that allows for asynchronous programming by handling and executing events in a loop.
• Event loop is a part of the runtime environment that listens for events and executes callback functions.

• It allows for non-blocking I/O operations by delegating tasks to the operating system.

• Event loop is commonly used in JavaScript for handling asynchronous operations like setTimeout, setInterval, and AJAX requ
Answered by AI
Add your answer

Q1. Past Experience and System Design
Add your answer

Q1. DSA and System Design
Add your answer

Q1. Past Experience and System Design
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