Inlogic Technologies Junior .NET Developer Interview Questions and Answers

Twenty technical multiple-choice questions: ten from general object-oriented programming, five from SQL, and five directly related to C#.

Q1. Can you provide a self-introduction?
Ans. 
I am a passionate Junior .NET Developer with experience in C#, ASP.NET, and SQL Server.
• Experienced in C#, ASP.NET, and SQL Server

• Passionate about software development

• Quick learner and team player
Answered by AI
Add your answer
Q2. What are the key concepts of Object-Oriented Programming (OOP)?
Ans. 
Key concepts of OOP include encapsulation, inheritance, polymorphism, and abstraction.
• Encapsulation: Bundling data and methods that operate on the data into a single unit (class). Example: Class with private fields and public methods.

• Inheritance: Creating new classes based on existing classes, inheriting their attributes and behaviors. Example: Subclass extending a superclass.

• Polymorphism: Objects of different classes ...read more
Answered by AI
Add your answer
Q3. What are the available access modifiers in programming?
Ans. 
Access modifiers control the visibility and accessibility of classes, methods, and variables in programming.
• Public - accessible from anywhere

• Private - accessible only within the same class

• Protected - accessible within the same class and its subclasses

• Internal - accessible within the same assembly

• Protected Internal - accessible within the same assembly or subclasses
Answered by AI
Add your answer
Q4. What is your understanding of normalization in SQL?
Ans. 
Normalization in SQL is the process of organizing data in a database to reduce redundancy and improve data integrity.
• Normalization is a technique used to eliminate redundant data and ensure data integrity.

• It involves breaking down a table into smaller tables and defining relationships between them.

• There are different normal forms such as 1NF, 2NF, 3NF, and BCNF.

• For example, in a database of students and courses, instea...read more
Answered by AI
Add your answer
Q5. Difference between substr() and charindex()?
Ans. 
substr() extracts a substring from a string based on start and length, while charindex() finds the position of a character or substring within a string.
• substr() is used in SQL Server to extract a portion of a string based on the starting position and length.

• charindex() is used in SQL Server to find the position of a specific character or substring within a string.

• Example: SELECT SUBSTRING('Hello World', 1, 5) will retu...read more
Answered by AI
Add your answer
Q6. What is the difference between procedures and functions?
Ans. 
Procedures do not return a value, while functions return a value.
• Procedures are used to perform an action, while functions are used to calculate and return a value.

• Functions have a return type specified, while procedures do not.

• Example: Procedure to display a message on the screen vs Function to calculate the sum of two numbers.
Answered by AI
Add your answer
Q7. What is the SQL query to retrieve the maximum salary from a database?
Ans. 
SQL query to retrieve the maximum salary from a database
• Use the SELECT statement with the MAX function to retrieve the maximum salary

• Specify the column name for the salary field in the table

• Example: SELECT MAX(salary) FROM employees
Answered by AI
Add your answer

Q1. Completely resume based questions. They will raise questions from web technology only if you mention it in your resume or else they won't get deeper in technical questions.
Add your answer