Landmark Realty 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. JS - closures , hoisting, event loop ,
Add your answer
Q2. Mongodb - sharding , clutering
Add your answer

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

Q1. Some C++ 14/17 questions and OOPs concepts
Add your answer
Q2. DSA questions based for basic game logics.
Add your answer

Q1. Advanced OOPs and C++ questions
Add your answer
Q2. DSA coding questions based on Stacks and Linked list
Add your answer

Q1. Called me to Noida for a F2F HR round. I wasn’t given any Travel allowance. CTC negotiation was brutal. They were not willing to give me even a 5% hike on my previous salary.The HR and the Team said they’d...read more
Add your answer
Q2. A month passed by. Sometimes they’d say the technical team who took your interview wasn’t available so that the CTC discussion could be further done. And somedays they’d just delay by saying we’d get back ...read more
Add your answer
Q3. After a month of wasting my time. The HR finally called and said they rejected me based on the CTC. And are not even willing to negotiate because of my not so well performance in the technical rounds.
Add your answer