Avalara Technologies AEM Developer Interview Questions and Answers

Question related to operating system and computer network

Q1. Traverse all child nodes in tree
Ans. 
Traverse all child nodes in a tree data structure
• Use depth-first or breadth-first traversal algorithms

• Recursively visit each child node starting from the root node

• Consider using a stack or queue data structure for traversal

• Example: Traverse all nodes in a binary tree
Answered by AI
Add your answer

Q1. Question related to cloud and oops
Add your answer

Q1. Question related to my background and how web site work
Add your answer

Q1. Basics of oops, .net framework and .net core
Add your answer
Q2. Sql query for student department id
Ans. 
SQL query to retrieve student department id.
• Use SELECT statement to retrieve data

• Specify the columns to be selected, including the department id column

• Specify the table where the student data is stored

• Use WHERE clause to filter the results based on student information
Answered by AI
Add your answer
Q3. Solid principles and design patterns
Add your answer

Q1. Asked to code palindrome
Add your answer
Q2. Code duplicate string from main string and get index of sub string
Ans. 
Code to find index of sub string in main string and duplicate the sub string
• Use a loop to iterate through the main string and check for the sub string

• If sub string is found, duplicate it and store the index

• Return the index of the duplicated sub string
Answered by AI
Add your answer

Q1. Manager asked me to code the count index of substring and sum of substring
Add your answer
Q2. Questions as HR informed, it was worst and all interviews were scheduled at night time.he was more technical than the second round team lead instead of asking manager round
Add your answer

In first round 4 coding question like 1 dsa 2 database and one is api and question is very simple . coding round was conducted in hackerrank

Q1. DSA QUESTION LIKE TREE AND GRAPH
Add your answer
Q2. DP AND SORTING APPROACH
Add your answer

Again same but dsa question and oops concept in deep level

Basic aptitude test with technical and non technical question

Q1. What is event loop
Add your answer

Q1. Rest Apis questions
Add your answer

Q1. Core java and OOPS and LLD
Add your answer

Q1. What is Common Term Expression?
Add your answer
Q2. What is Overloading and Overriding?
Ans. 
Overloading is having multiple methods in the same class with the same name but different parameters. Overriding is implementing a method in a subclass that is already defined in the parent class.
• Overloading allows a class to have multiple methods with the same name but different parameters.

• Overriding is when a subclass provides a specific implementation of a method that is already defined in its parent class.

• Example o...read more
Answered by AI
Add your answer
Q3. Examples of Server side session Management? Types of Session State?
Ans. 
Server side session management involves storing user data on the server to maintain state. Types include in-process, out-of-process, and database.
• In-process session state: Data stored in memory on the same server as the application.

• Out-of-process session state: Data stored in a separate server or service, such as a state server or Redis cache.

• Database session state: Data stored in a database, such as SQL Server or MySQ...read more
Answered by AI
Add your answer
Q4. How to Debug Stored Procedures?
Ans. 
Debugging stored procedures involves using tools like SQL Server Management Studio, setting breakpoints, and analyzing query execution.
• Use SQL Server Management Studio to debug stored procedures

• Set breakpoints in the stored procedure code to pause execution at specific points

• Analyze query execution using tools like SQL Profiler to identify issues

• Use PRINT or SELECT statements to output intermediate results for debuggin...read more
Answered by AI
Add your answer
Q5. What is Compile time binding and Runtime Binding?
Ans. 
Compile time binding occurs during compilation while runtime binding occurs during execution.
• Compile time binding is also known as early binding, where the method to be called is determined at compile time based on the type of the object.

• Runtime binding is also known as late binding, where the method to be called is determined at runtime based on the actual type of the object.

• Compile time binding is faster as it is don...read more
Answered by AI
Add your answer

Q1. Something based on hashet
Add your answer
Q2. Same with this too
Add your answer

Basic questions were given..bar graphs,pie charts

Q1. Security related scenarios.
Add your answer
Q2. Integration types and usecases.
Ans. 
Integration types include point-to-point, middleware, and API-based integrations for connecting different systems.
• Point-to-point integration involves direct connections between two systems.

• Middleware integration uses a middle layer to connect multiple systems.

• API-based integration utilizes APIs to connect systems and exchange data.

• Examples: Salesforce to SAP integration, Salesforce to MailChimp integration, Salesforce
Answered by AI
Add your answer