Wisilica Interview Questions, Process, and Tips

Q1. SQL Questions - Constraints- how to optimize long SQL query without changing the output
Add your answer

Sql mcq questions with medium difficulty

Q1. What is inheritance? What are advantages of oops? What's indexing in sql?
Ans. 
Inheritance is a concept in object-oriented programming where a class inherits properties and behaviors from another class.
• Advantages of OOPs include reusability, modularity, and flexibility in code design.

• Indexing in SQL is a way to optimize database queries by creating indexes on columns to improve search performance.
Answered by AI
Add your answer

Q1. What was your previous job role? What methodologies did you follow while working?
Ans. 
I was a Software Developer at XYZ Company. I followed Agile and Scrum methodologies.
• Worked as a Software Developer at XYZ Company

• Followed Agile and Scrum methodologies for project management

• Participated in daily stand-up meetings, sprint planning, and retrospectives
Answered by AI
Add your answer

Q1. What are you leaving your current organization?
Ans. 
Seeking new challenges and opportunities for growth.
• Looking for new challenges and opportunities for professional growth

• Interested in working on different technologies or projects

• Seeking a more collaborative or innovative work environment
Answered by AI
Add your answer

Q1. Reconciliation based question medium
Add your answer

Q1. It was mostly on scenario based questions and I was asked to code online.
Add your answer

Q1. Discussion were there past projects, how different objectives were done.
Add your answer

Q1. Round 1 was hackerrank test. MCQs and coding questions.
Add your answer
Q2. Kafka related questions.
Add your answer
Q3. Java 8 related questions. Java streams.
Add your answer

Q1. Starting from full form of SQL to RDBMS, CTE and some most common window functions, they asked everything. Questions were easy.
Add your answer

Q1. Concept of Hoisting in Javascript
Ans. 
Hoisting is a JavaScript behavior where variable and function declarations are moved to the top of their containing scope during compilation.
• Variable declarations are hoisted to the top of their scope, but not their initializations.

• Function declarations are fully hoisted, including their definitions.

• Hoisting can lead to unexpected behavior if not understood properly.
Answered by AI
Add your answer
Q2. What is arrow function
Ans. 
Arrow functions are a concise way to write functions in JavaScript.
• Arrow functions are anonymous functions defined using the '=>' syntax.

• They have a shorter syntax compared to traditional function expressions.

• Arrow functions do not have their own 'this' keyword, instead they inherit it from the parent scope.
Answered by AI
Add your answer
Q3. Polyfill of Promise
Ans. 
Polyfill of Promise is a code that adds Promise functionality to browsers that do not support it natively.
• Polyfill is a piece of code that provides the technology that you expect the browser to provide natively.

• Polyfill for Promise adds Promise functionality to browsers that do not support it, allowing developers to use Promises in their code.

• Examples of Promise polyfills include 'es6-promise' and 'promise-polyfill'.
Answered by AI
Add your answer

Q1. Implementation of carousel
Ans. 
Implementing a carousel for displaying multiple images or content in a rotating manner.
• Use a library like Slick or Owl Carousel for easy implementation

• Ensure images/content are responsive for different screen sizes

• Add navigation arrows or dots for user interaction

• Consider adding autoplay feature with customizable speed

• Optimize performance by lazy loading images
Answered by AI
Add your answer