Intellicore Consulting Group EPM Consultant Interview Questions and Answers

Q1. Nth higest salary query in sql
Add your answer
Q2. Constraints
Add your answer
Q3. Delete drop truncate
Add your answer
Q4. Identity column
Add your answer
Q5. Ref and out
Add your answer
Q6. Polymorphism code
Add your answer
Q7. Inheritance, interface, abstract class,access modifiers, solid principles,design patterns
Add your answer
Q8. Remove duplicates from an array
Ans. 
Remove duplicates from an array of strings
• Create a Set to store unique elements

• Iterate through the array and add each element to the Set

• Convert the Set back to an array to get the unique elements
Answered by AI
Add your answer

Q1. Difference between display none, visibility hidden and opacity 0 in CSS
Ans. 
display none hides the element completely, visibility hidden hides the element but still takes up space, opacity 0 makes the element transparent.
• display none removes the element from the layout

• visibility hidden hides the element but it still occupies space

• opacity 0 makes the element transparent but still occupies space

• Example: display: none; visibility: hidden; opacity: 0;
Answered by AI
Add your answer
Q2. Write a polyfill for javascript method "filter"
Ans. 
Polyfill for JavaScript method 'filter'
• Create a function called 'filter' that takes a callback function as an argument

• Loop through the array and apply the callback function to each element

• If the callback function returns true, add the element to a new array and return it
Answered by AI
Add your answer
Q3. Explain ShadowDOM
Ans. 
Shadow DOM is a way to encapsulate the styling and structure of a web component, preventing styles from leaking out and clashing with the rest of the page.
• Shadow DOM allows for creating self-contained components with their own DOM tree and styling.

• It helps in preventing styles from the main document affecting the component and vice versa.

• Shadow DOM can be created using the 'attachShadow' method in JavaScript.

• It is comm...read more
Answered by AI
Add your answer
Q4. Explain Currying in Javascript
Ans. 
Currying is a technique in JavaScript where a function with multiple arguments is transformed into a sequence of functions, each taking a single argument.
• Currying allows you to create reusable functions with partial application of arguments.

• It helps in creating more flexible and composable functions.

• Example: const add = (a) => (b) => a + b; const add5 = add(5); console.log(add5(3)); // Output: 8
Answered by AI
Add your answer
Q5. What is Event Deligation in javascript
Ans. 
Event delegation in JavaScript is a technique where a single event listener is attached to a parent element to handle events for multiple child elements.
• Event delegation helps improve performance by reducing the number of event listeners.

• It is useful for dynamically created elements or elements with similar behavior.

• Event delegation works by utilizing event bubbling, where events on child elements bubble up to the pare
Answered by AI
Add your answer

Q1. Internal working of Hashmap
Ans. 
HashMap in Java is a data structure that stores key-value pairs and uses hashing to efficiently retrieve values.
• HashMap uses an array of buckets to store key-value pairs.

• Keys are hashed to determine the index where the value will be stored.

• In case of hash collisions, a linked list or balanced tree is used to store multiple entries in the same bucket.

• HashMap allows one null key and multiple null values.

• Example: HashMap&...read more
Answered by AI
Add your answer
Q2. JAVA 8 Stream API coding questions
Add your answer

Q1. JAVA 8 advanced coding question
Add your answer
Q2. Specific questions on client requirements
Add your answer

Q1. General questions on expectations
Add your answer

Q1. Shipping point determination
Add your answer
Q2. Plant determination with order of preference
Ans. 
Plant determination can be done by considering various factors in order of preference.
• Start by looking at the plant's physical characteristics such as leaves, flowers, and stems.

• Next, consider the plant's habitat and location to narrow down possibilities.

• Use plant identification guides or apps for further assistance.

• Consult with botanical experts or horticulturists for accurate identification.

• Consider factors like seas...read more
Answered by AI
Add your answer
Q3. Difference between s4 hana and ecc
Ans. 
SAP S/4HANA is the next-generation business suite designed to run on SAP HANA, while ECC is the previous version of SAP's ERP software.
• S/4HANA is built on the SAP HANA platform for real-time data processing, while ECC runs on traditional databases.

• S/4HANA offers a simplified data model and user interface, while ECC has a more complex structure.

• S/4HANA includes advanced features like predictive analytics and machine lea...read more
Answered by AI
Add your answer
Q4. Difference between Greenfield and brownfield implementation
Ans. 
Greenfield is starting a new project from scratch, while brownfield is implementing changes to an existing project.
• Greenfield involves building a new system or project from the ground up.

• Brownfield involves making changes or improvements to an existing system or project.

• Greenfield projects are typically more time-consuming and costly due to starting from scratch.

• Brownfield projects may have limitations or constraints d...read more
Answered by AI
Add your answer
Q5. Scenario based questions around Product allocation and back order processing bop
Add your answer
Q6. Business partner and what tables are updated in backend in sap s4 hana, why is the old tables like kna1, knb1 still required?
Ans. 
Old tables like KNA1, KNB1 are still required in SAP S4 HANA for compatibility and historical data purposes.
• Old tables like KNA1, KNB1 are still required in SAP S4 HANA for compatibility with existing programs and reports.

• Some custom developments may still be using the old tables, requiring them to be maintained.

• Historical data stored in the old tables may still be needed for reference or reporting purposes.
Answered by AI
Add your answer
Q7. Questions on current project
Add your answer
Q8. S4 Hana einvoice - consolidated invoice
Add your answer
Q9. Why are you looking for a change(Exp in curren company<= 2 years)
Ans. 
Seeking new challenges and growth opportunities after gaining valuable experience in current role.
• Looking for new challenges and opportunities for growth

• Seeking a role with more responsibility and impact

• Want to expand my skill set and knowledge in a different environment
Answered by AI
Add your answer

Q1. Sql related questions were askwd
Add your answer
Q2. Adf related questions were asked
Add your answer

Q1. Ci cd questions were asked
Add your answer
Q2. Team work related questions were asked
Add your answer

Q1. Fitment round with location
Add your answer

Voice assesment,which will be evaluated by ai

Q1. Introduce yourself
Add your answer
Q2. Basic dsa question on printing pattern
Add your answer

Q1. Technical questions L2 level
Add your answer
Q2. Technical questions L3 level
Add your answer

Q1. Technical questions
Add your answer
Q2. Technical questions L3
Add your answer

Q1. Salary expectation
Add your answer
Q2. Salary discussion
Add your answer