Affinity Express Associate Web Developer Interview Questions and Answers

Q1. What is Indexing in Mysql
Ans. 
Indexing in MySQL is a technique to improve the performance of database queries by creating a data structure that allows for faster data retrieval.
• Indexes are created on one or more columns of a table.

• They help in speeding up the search, sorting, and joining of data.

• Indexes can be created using different algorithms like B-tree, hash, or bitmap.

• Using indexes appropriately can significantly enhance query performance.

• Exam...read more
Answered by AI
Add your answer
Q2. Opps concepts in php
Ans. 
Object-oriented programming concepts in PHP
• Encapsulation: bundling data and methods together in a class

• Inheritance: creating new classes based on existing ones

• Polymorphism: using a single interface to represent different types

• Abstraction: hiding unnecessary details and exposing only essential features

• Class: blueprint for creating objects

• Object: instance of a class

• Method: function defined inside a class

• Property: variabl
Answered by AI
Add your answer

It was based on frontend technologies

Q1. Basic frontend question
Add your answer

Q1. Managerial round
Add your answer

Q1. Prepare js array and string functions, and React js core concepts
Add your answer

Q1. Easy-Medium level Leetcode questions on linkedlists
Add your answer
Q2. Simple recursion question
Add your answer
Q3. An SQL query Basic question in OOPS and resume description..
Add your answer
Q4. Basic questions regarding SQL
Add your answer
Q5. Difference between thread and process
Ans. 
A process is an instance of a program while a thread is a subset of a process that can run concurrently with other threads.
• Processes have their own memory space while threads share the same memory space within a process.

• Processes are independent of each other while threads within the same process can communicate with each other.

• Processes are heavier in terms of resource consumption compared to threads.

• Example: A web br...read more
Answered by AI
Add your answer

Q1. Basic JavaScript and React.js questions
Add your answer
Q2. Questions on functions, hooks and DOM
Add your answer
Q3. Questions on SSR
Add your answer
Q4. Questions on strings and arrays
Add your answer

Api related questions

Q1. What is your long term goal
Add your answer

Q1. What do you know about digital marketing?
Ans. 
Digital marketing is the promotion of products or services through digital channels.
• It includes various tactics such as SEO, SEM, social media marketing, email marketing, content marketing, and mobile marketing.

• Digital marketing helps businesses to reach their target audience, increase brand awareness, and drive sales.

• For example, a company may use Facebook ads to target a specific demographic or use email marketing to...read more
Answered by AI
Add your answer
Q2. Why would you try this domain?
Ans. 
I would try this domain because it aligns with my skills and interests, and offers opportunities for growth and impact.
• I have a strong background in this domain and have successfully completed projects in the past.

• I am passionate about this domain and have a deep understanding of its challenges and opportunities.

• This domain offers significant potential for growth and innovation.

• Working in this domain would allow me to ...read more
Answered by AI
Add your answer

Q1. Speak to me for about 2 minutes on any topic
Ans. 
The benefits of meditation
• Meditation can reduce stress and anxiety

• It can improve focus and concentration

• Meditation can increase self-awareness and promote emotional health

• It may also lower blood pressure and improve sleep

• Examples of meditation techniques include mindfulness and transcendental meditation
Answered by AI
Add your answer