The Propertist Interview Questions and Answers

Q1. What is the difference between Union and Union all ?
Ans. 
Union combines the results of two or more SELECT statements, while Union all includes all rows, including duplicates.
• Union removes duplicate rows from the result set, while Union all includes all rows.

• Union sorts the result set, while Union all does not.

• Union is slower than Union all because it performs a distinct operation.

• Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;

• Example: SELECT column1 FRO
Answered by AI
Add your answer
Q2. Which query is more faster , joins or union?
Ans. 
Joins are generally faster than unions.
• Joins are typically faster than unions because they combine data from multiple tables based on a common column, while unions combine data from multiple queries into a single result set.

• Joins can utilize indexes on the columns being joined, which can improve performance.

• Unions involve combining the results of multiple queries, which can be slower as it requires merging and sorting ...read more
Answered by AI
Add your answer

Q1. All related to domain javascript/react,
Add your answer
Q2. Fallback in lazy loading,optimization techniques/for API call
Ans. 
Fallback in lazy loading is important for optimizing API calls to ensure a smooth user experience.
• Implementing a loading spinner or placeholder while content is being loaded asynchronously

• Using a default value or cached data if the API call fails

• Implementing error handling to gracefully handle any issues with the API call
Answered by AI
Add your answer

Train,percentage,work

Array , string , basic

Q1. Basic dsa question and oops
Add your answer

Q1. About company and traditaion question
Add your answer

Coding test was of 1hr 20mins the test was totally on reactjs coding questions which consists of 22 questions , 10 mcqs 10 output based and 2 coding questions

Q1. React scenario based questions
Add your answer

Q1. Problem Solving on any product
Add your answer
Q2. Breakdown of any product
Ans. 
A breakdown of a product involves analyzing its components, features, functionality, and value proposition.
• Identify the key components of the product

• Analyze the features and functionalities of each component

• Evaluate the value proposition of the product in relation to customer needs and market trends
Answered by AI
Add your answer

20 question You have to Score 12

Q1. Basic question games and M testing
Add your answer

Q1. Manual Testing question And Game related Questions
Add your answer
Q2. Regression testing
Add your answer
Q3. Smoke testing sanity
Add your answer

Q1. PM round basic speaking
Add your answer

Q1. Explain about react guard
Ans. 
React guard is a higher-order component used to restrict access to certain routes in a React application.
• React guard is used for implementing authentication and authorization in React applications.

• It can be used to prevent unauthorized users from accessing certain routes.

• React guard can redirect users to a login page if they are not authenticated.

• It can also be used to restrict access based on user roles or permissions
Answered by AI
Add your answer
Q2. Use of the axios interceptor
Ans. 
Axios interceptors are used to globally handle HTTP requests and responses in an application.
• Interceptors can be used to add headers, handle errors, or modify requests before they are sent.

• Example: Adding a token to all outgoing requests for authentication.

• Example: Logging all incoming responses for debugging purposes.
Answered by AI
Add your answer

Q1. JS - closures , hoisting, event loop ,
Add your answer
Q2. Mongodb - sharding , clutering
Add your answer

Javascript programs - check sum , sql vs mongodb , system desgin