GS Lab Software Engineer Intern Interview Questions and Answers

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

• Each table should have a primary key and only contain data that is related to that key.

• Normalization helps to prevent data inconsistencies and anomalies.

• There are different levels of normalization, with each level building on t...read more
Answered by AI
Add your answer
Q2. What is oops concepts??
Ans. 
OOPs concepts are the fundamental principles of Object-Oriented Programming.
• Encapsulation - binding data and functions that manipulate them

• Inheritance - creating new classes from existing ones

• Polymorphism - ability of objects to take on multiple forms

• Abstraction - hiding implementation details and showing only functionality

• Examples: class, object, inheritance, encapsulation, polymorphism, abstraction
Answered by AI
Add your answer
Q3. What are joins in sql databases??
Ans. 
Joins are used to combine data from two or more tables based on a related column.
• Joins are used to retrieve data from multiple tables in a single query.

• They are performed using the JOIN keyword followed by the name of the table to be joined.

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN.

• Joins are based on a related column between the tables, known as the join condition.

• The result o...read more
Answered by AI
Add your answer

2 coding questions and few MCQs

Q1. Questions around resume and some basic coding questions.
Add your answer

Q1. 2 coding questions, 1 puzzle and then some chit chat with hiring manager.
Add your answer

Q1. Basic questions that HR ask.
Add your answer