Techversant Infotech Associate Software Engineer Interview Questions, Process, and Tips

Types of Join in SQL

• Inner Join: returns only the matching rows from both tables

• Left Join: returns all the rows from the left table and matching rows from the right table

• Right Join: returns all the rows from the right table and matching rows from the left table

• Full Outer Join: returns all the rows from both tables, with NULL values in place of non-matching rows

Arrays are fixed in size and hold elements of the same data type, while lists are dynamic and can hold elements of different data types.

• Arrays are declared with a fixed size, while lists can grow or shrink dynamically.

• Arrays can only hold elements of the same data type, while lists can hold elements of different data types.

• Arrays are accessed using an index, while lists are accessed using an iterator.

• Examples of arrays...read more

Program to count and print occurrence of numbers in an array of strings

• Use a loop to iterate through the array

• Use a dictionary to store the count of each number

• Print the count of each number

A web server is a software that delivers web pages to clients upon request.

• Web server is responsible for receiving and responding to HTTP requests from clients

• It stores and delivers web pages, images, videos, and other web content

• Examples of web servers include Apache, Nginx, and Microsoft IIS

Structures are value types while classes are reference types in C#. Classes support inheritance and polymorphism.

• Structures are value types while classes are reference types

• Structures cannot support inheritance and polymorphism

• Classes can have access modifiers while structures cannot

• Structures are stored on the stack while classes are stored on the heap

• Example of a structure: struct Point { int x, y; }

• Example of a clas