Lockeys Technologies Senior BI Consultant Interview Questions and Answers

Q1. Tell me about yourself
Add your answer
Q2. Write program to check string is palindrom
Add your answer
Q3. Write programm to Remove number from array who occur more than once
Add your answer
Q4. String Buffer vs String Builder
Add your answer
Q5. If String s="Deloitte"; and String s2=new String("Deloitte"); what will be s1.equals(s2) and if(s1==s2)
Add your answer
Q6. Why spring boot is better than spring ? Annotations of spring
Add your answer
Q7. Query for count employee in each department
Add your answer
Q8. How to create react app ? npm commands to create react app
Add your answer
Q9. How routing works in react
Add your answer
Q10. Dml dcl and ddl command
Add your answer

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

Percentage and averages, number and alphabet series, compound interest (CI) and simple interest (SI).

Basic programs include: 1. A program to perform the addition of two numbers, 2. A program to print a star pattern, and 3. A program to generate a triangle output, among others.

Q1. What challenges did we face?
Ans. 
We faced challenges related to communication, resource allocation, and project timelines.
• Communication breakdown between team members

• Limited resources available for the project

• Struggling to meet project deadlines
Answered by AI
Add your answer
Q2. Where do you see yourself in the next five years?
Ans. 
In five years, I see myself as a senior consultant leading projects and mentoring junior team members.
• Advancing to a senior consultant role

• Leading projects and teams

• Mentoring junior team members

• Continuing professional development through training and certifications
Answered by AI
Add your answer
Q3. What strategies can be employed to overcome failures?
Ans. 
Strategies to overcome failures include learning from mistakes, staying positive, seeking feedback, and setting new goals.
• Learn from mistakes by analyzing what went wrong and how to improve

• Stay positive and maintain a growth mindset to bounce back from setbacks

• Seek feedback from mentors or colleagues to gain different perspectives

• Set new goals and create a plan to move forward with renewed motivation
Answered by AI
Add your answer
Q4. Are you able to work effectively under pressure?
Ans. 
Yes, I thrive under pressure and can effectively manage my time and priorities to meet deadlines.
• I have experience working in fast-paced environments where quick decision-making and adaptability are key.

• I am able to stay calm and focused under pressure, allowing me to deliver high-quality work even in challenging situations.

• I prioritize tasks effectively to ensure that deadlines are met without compromising on quality.

• ...read more
Answered by AI
Add your answer

Q1. Java Based Questions
Add your answer

Q1. They were asking very logical and technical questions on interview time
Add your answer
Q2. They were test our skills and time punctuation
Add your answer

Q1. They were discussed with some technical questions and based on knowledge
Add your answer

Q1. Tell me the high level overview of dataguard installation?
Add your answer
Q2. What are your daily tasks adn what things you handel in your team?
Add your answer

Q1. Explain inter company accounting
Ans. 
Inter company accounting involves recording financial transactions between different entities within the same organization.
• Inter company accounting ensures accurate financial reporting within a group of companies.

• Transactions between entities are eliminated to avoid double counting.

• Common inter company transactions include sales, purchases, loans, and transfers of assets.

• Inter company accounts are used to track these t...read more
Answered by AI
Add your answer
Q2. Foreign Currency Revaluation
Add your answer

Q1. Explain the process you follow for support project
Add your answer
Q2. How do you manage a team
Ans. 
I manage a team by setting clear goals, providing support and resources, fostering open communication, and recognizing achievements.
• Set clear goals and expectations for team members

• Provide necessary support and resources for team to succeed

• Foster open communication and encourage collaboration

• Recognize and reward team achievements

• Delegate tasks effectively based on team members' strengths and skills
Answered by AI
Add your answer