Info Drive Software Interview Questions and Answers

Q1. Java 8 features
Add your answer
Q2. Functional interfaces with custom functional interface coding question
Add your answer
Q3. Stream apis and one coding question
Add your answer
Q4. Spring framework,IOC container, bean scopes.
Add your answer
Q5. Different between monolithic and micro services architecture. Pros and cons.
Add your answer
Q6. REST apis
Add your answer
Q7. Few SQL queries
Add your answer

Q1. Introduction yourself
Ans. 
I am a dedicated PL/SQL developer with 5 years of experience in designing and implementing database solutions.
• Experienced in writing complex PL/SQL queries and stored procedures

• Proficient in performance tuning and optimization of SQL queries

• Skilled in database design and normalization principles

• Familiar with Oracle database technologies such as triggers and packages
Answered by AI
Add your answer
Q2. What is join and its types
Ans. 
Join is used to combine rows from two or more tables based on a related column between them.
• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• INNER JOIN returns rows when there is at least one match in both tables

• LEFT JOIN returns all rows from the left table and the matched rows from the right table

• RIGHT JOIN returns all rows from the right table and the matched rows from the left table

• FULL JOIN r...read more
Answered by AI
Add your answer

Given one at home assignment to create a lwc component

Q1. How to have different pricing based on regions
Ans. 
Different pricing based on regions can be achieved by using price rules and custom fields in Salesforce.
• Create custom fields to store region information for each account or opportunity

• Use price rules to set different prices based on the region

• Utilize workflow rules or process builder to automate the pricing based on region

• Consider using custom metadata types for easier maintenance and scalability
Answered by AI
Add your answer
Q2. Parent to child relation in lwc
Ans. 
Parent to child relation in LWC refers to the relationship between a parent component and its child components in Lightning Web Components.
• Use @api decorator in child component to expose properties to parent component

• Use @track decorator in parent component to track changes in child components

• Communicate between parent and child components using events or properties
Answered by AI
Add your answer

Q1. System design Shortner URL
Add your answer

Q1. What do you know about Emis and the role?
Add your answer

Q1. What will be your approach to ensure you are successful in the duties of the role
Add your answer

Q1. What is SEO?? Explain
Ans. 
SEO stands for Search Engine Optimization. It is the process of optimizing a website to improve its visibility on search engines.
• SEO involves optimizing website content, meta tags, and backlinks to improve search engine rankings.

• Keyword research is crucial in SEO to target relevant search terms that users are searching for.

• Creating high-quality content that is valuable to users can help improve SEO rankings.

• Technical S...read more
Answered by AI
Add your answer
Q2. What is on page and off page SEO?
Ans. 
On-page SEO refers to optimizing individual web pages to rank higher and earn more relevant traffic in search engines. Off-page SEO refers to actions taken outside of your website to impact your rankings within search engine results pages.
• On-page SEO includes optimizing content, meta tags, headings, images, and URLs on your website.

• Off-page SEO involves building backlinks, social media marketing, and influencer outreac...read more
Answered by AI
Add your answer

Q1. What is your strength
Ans. 
My strength lies in my ability to analyze data, identify trends, and implement effective SEO strategies.
• Strong analytical skills to interpret data and make informed decisions

• Ability to identify trends and adapt strategies accordingly

• Experience in implementing successful SEO campaigns

• Proficiency in using SEO tools and techniques

• Excellent communication skills to collaborate with team members and clients
Answered by AI
Add your answer
Q2. Where do you see yourself after 5 year's?
Ans. 
In 5 years, I see myself as a seasoned SEO Executive leading a team of digital marketing experts and driving successful campaigns for top clients.
• Leading a team of digital marketing experts

• Driving successful campaigns for top clients

• Continuously learning and adapting to new SEO trends and strategies

• Attending industry conferences and networking events to stay updated

• Possibly pursuing advanced certifications in SEO or di
Answered by AI
Add your answer

Easy it was having 30 questions

Coding was medium leet code questions

Q1. Technical questions that includes coding as well
Add your answer

Q1. Technical and Managerial discussion
Add your answer

Q1. Salary discussion
Add your answer

SQL Question was asked based on cte and subquery