Ram Engineers & Contractors 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

Coding related to java collections

Q1. Familiar with Design patterns ?explain few
Ans. 
Design patterns are reusable solutions to common problems in software design.
• Design patterns help in creating maintainable and scalable code.

• Examples of design patterns include Singleton, Factory, Observer, and Strategy.

• Singleton pattern ensures a class has only one instance and provides a global point of access to it.

• Factory pattern creates objects without specifying the exact class of object that will be created.

• Obse...read more
Answered by AI
Add your answer
Q2. What is Mutilthreading,explain with examples
Ans. 
Multithreading is the ability of a CPU to execute multiple threads concurrently, allowing for improved performance and responsiveness.
• Multithreading allows multiple tasks to be executed simultaneously on a single CPU.

• Each thread has its own stack and program counter, but shares the same memory space.

• Examples include running multiple processes in a web server, handling user input while performing background tasks, and p
Answered by AI
Add your answer

Q1. Probability question
Add your answer
Q2. Baseball game, ticket pricing
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. What is gameing and how many phase?
Ans. 
Gaming is the act of playing electronic games, which typically involves interactive gameplay and challenges.
• Gaming involves playing electronic games on various platforms such as consoles, computers, and mobile devices.

• There are different phases in gaming such as planning, execution, and evaluation.

• Examples of gaming phases include strategizing before a battle in a strategy game, navigating through obstacles in an actio...read more
Answered by AI
View 1 more amswer
Q2. About self intro
Ans. FIRST OF ALL THANKING YOU FOR GIVING THIS OPPORTUNITY FOR ME MY SELF KUMBA SAMUEL AND I HAVE COMPLETED MY SCC AT BHAVISHYA THE SCHOOL AND 10+2 WAS COMPLETELY VIZAG DEFENCE ACADEMY AND COMEING MY HIGHER EDUCATION I AM PERSUING B TECH MY STRENGTH ME ONLY & MY HOBES ARE PLAYING GAMEING AND DOING FITNESS Thanking you sir/madam
Answered Anonymously
Add your answer
Q3. Gaming is playing an electronic video game which is often on a dedicated gaming console,pc or smartphone.
Add your answer
Q4. FIRST OF ALL THANKING YOU FOR GIVING THIS TIME FOR ME MY SELF KUMBA SAMUEL AND I HAVE COMPLETEMY SCC AT BHAVISHYA THE SCHOOL AND 10+2 HAVE COMPLETED AT VIZAG DEFENCE ACADEMY & AND COMEING MY HIGHER EDUCATI...read more
Add your answer
Q5. We have to LEARN FAST....
Add your answer