Ramco Systems Interview Questions, Process, and Tips

They give me some tough codings

They ask us do group presentation about future technology.

Q1. What is normalization
Ans. 
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
• Normalization involves breaking down data into smaller, more manageable tables

• It helps in reducing data redundancy by eliminating duplicate data

• Normalization ensures data integrity by enforcing relationships between tables

• There are different levels of normalization such as 1NF, 2NF, 3NF, and BCNF
Answered by AI
Add your answer
Q2. What is correlated subquery
Ans. 
A correlated subquery is a subquery that references a column from a table in the outer query.
• Correlated subqueries are executed for each row processed by the outer query

• They can be used to filter results based on values from the outer query

• Example: SELECT * FROM table1 WHERE column1 = (SELECT MAX(column2) FROM table2 WHERE table1.id = table2.id)
Answered by AI
Add your answer
Q3. What is diff between in and exists
Ans. 
IN is used to check if a value exists in a list of values, while EXISTS is used to check if a subquery returns any rows.
• IN is used with a list of values, while EXISTS is used with a subquery

• IN returns true if the value is found in the list, while EXISTS returns true if the subquery returns any rows

• IN is typically used with a WHERE clause, while EXISTS is used in a subquery
Answered by AI
Add your answer

Q1. Tell about your roles and responsibility
Add your answer

Q1. Related to technology
Add your answer
Q2. SQL , application development
Add your answer

The Aptitude test is moderate

The coding test is moderate

The group discussion is very friendly