Index 3 | Sahul

Experience 1

Tell me about yourself.
- Answer: I am a fourth-year Computer Science Engineering student at Chandigarh University. I have a strong foundation in programming languages such as Java, Python, and C#. I enjoy solving complex problems and have worked on various projects involving web and mobile app development. I am also an active participant in coding clubs and hackathons.
What is C#?
- Answer: C# is a modern, object-oriented programming language developed by Microsoft. It is used to build a variety of applications, especially on the .NET platform.
What is the OOP concept?
- Answer: Object-oriented programming (OOP) is a programming paradigm based on the concept of objects. The main principles are encapsulation, abstraction, inheritance, and polymorphism.
What is a delegate?
- Answer: A delegate is a type in C# that represents references to methods with a specific parameter list and return type. It is used to pass methods as arguments to other methods.
What is polymorphism and what are its types?
- Answer: Polymorphism is the ability of a single function or method to work in different ways based on the input. Its types are:
  - Compile-time (method overloading)
  - Run-time (method overriding)
What is the difference between polymorphism and inheritance?
- Answer: Polymorphism allows methods to do different things based on the object it is acting upon, while inheritance allows a class to inherit properties and methods from another class.
What is the out keyword in C#?
- Answer: The out keyword in C# is used to pass arguments to methods by reference. It allows a method to return multiple values.
What is the ref keyword in C#?
- Answer: The ref keyword in C# is used to pass an argument by reference, meaning any changes to the parameter in the method will be reflected in that variable when control returns to the calling method.
What is the difference between call by reference and call by value?
- Answer: In call by value, a copy of the variable is passed to the method, so changes do not affect the original variable. In call by reference, the actual variable is passed, so changes affect the original variable.
What is a namespace?
- Answer: A namespace is a container that holds classes, interfaces, enums, and other namespaces, helping to organize code and prevent naming conflicts.
What is data hiding?
- Answer: Data hiding is an OOP concept that restricts access to the internal state of an object, typically using access modifiers like private and protected.
What is abstraction?
- Answer: Abstraction is an OOP concept that hides the complex implementation details of a system and exposes only the necessary parts.
What is the difference between DBMS and RDBMS?
- Answer: DBMS (Database Management System) is software for storing and managing data. RDBMS (Relational Database Management System) is a type of DBMS that stores data in tables and supports relationships between tables.
What is the difference between DROP and TRUNCATE? Can we use ROLLBACK for DROP?
- Answer: DROP removes a table and its data from the database. TRUNCATE deletes all data in a table but keeps the table structure. ROLLBACK cannot be used for DROP, as it is a DDL command and is not reversible.
Can we use pointers in C#?
- Answer: Yes, C# supports pointers, but only in an unsafe context.
What is managed code and unmanaged code?
- Answer: Managed code is executed by the .NET runtime environment, which provides services like garbage collection. Unmanaged code is executed directly by the operating system, without such services.
What are joins and what are the types of joins?
- Answer: Joins are SQL operations used to combine rows from two or more tables based on a related column. Types include:
  - Inner Join
  - Left Join
  - Right Join
  - Full Join
What is a cross join?
- Answer: A cross join returns the Cartesian product of two tables, meaning it combines all rows from the first table with all rows from the second table.
What is the difference between a stored procedure (SP) and a function?
- Answer: A stored procedure can perform actions like modifying data and does not need to return a value. A function must return a value and can be used in SQL statements like a scalar value.
What is a primary key?
- Answer: A primary key is a unique identifier for a record in a table. It ensures that each record is unique and not null.
What is a foreign key?
- Answer: A foreign key is a column or group of columns in a table that provides a link between data in two tables. It ensures referential integrity by referencing the primary key of another table.

Experience 2

Introduce Yourself
What internships and projects I have done
More details about the internship
Project details the mini-project and final year project
Some basics concepts of ECE as I was from ECE branch
What are communication and types?
What are modulation and types?
Which programming languages you know and rate your knowledge out of 5 in that language
Then some basic OOP concepts inheritance, polymorphism, abstraction
What is a virtual function?
What is a dangling pointer?
What is data science (as the course was mentioned in my resume)
Which python libraries you know and you worked on
What is the difference between c++ and java?
The difference between call by value and call by reference to explain with syntax
Write a code to find factorial of a number

Some HR questions:

Ready to relocate
What are your hobbies?
Do you like to go out with your friends on weekends, etc

Sure! Here are the answers to each of these questions, structured and simplified:

Self-Introduction

Introduce Yourself

Answer: Hello, my name is [Your Name]. I am a fourth-year student of Electronics and Communication Engineering (ECE) at Chandigarh University. I have a strong interest in software development and data science, which I have pursued through various projects and internships.

Internships and Projects

What internships and projects have you done?

Answer: I have completed an internship at XYZ Company where I worked on developing a web application. Additionally, I have worked on a mini-project focused on home automation using IoT and a final year project on machine learning algorithms for predictive maintenance.

More details about the internship

Answer: During my internship at XYZ Company, I worked as a part of the development team. My responsibilities included coding, testing, and debugging features for a web application using JavaScript and React. I also collaborated with senior developers to optimize the application's performance.

Project details: the mini-project and final year project

Answer:
- Mini-Project: My mini-project involved creating a home automation system using Arduino and IoT. I designed and implemented a system that allowed users to control home appliances through a mobile app.
- Final Year Project: My final year project was on predictive maintenance using machine learning. I developed algorithms to predict equipment failures in industrial settings, which helped in reducing downtime and maintenance costs.

Basic Concepts in ECE

Some basic concepts of ECE as I was from ECE branch

Answer: In ECE, some basic concepts include signal processing, microprocessors and microcontrollers, analog and digital communication, circuit theory, and electromagnetic fields.

What are communication and types?

Answer: Communication is the process of transmitting information from one place to another. Types include:
- Analog Communication: Uses continuous signals.
- Digital Communication: Uses discrete signals.
- Wireless Communication: Transmits data through electromagnetic waves.
- Optical Communication: Uses light to transmit data through fiber optic cables.

What are modulation and types?

Answer: Modulation is the process of varying a carrier signal to transmit data. Types include:
- Amplitude Modulation (AM)
- Frequency Modulation (FM)
- Phase Modulation (PM)

Programming Skills

Which programming languages do you know and rate your knowledge out of 5 in that language

Answer:
- Java: 4/5
- Python: 4.5/5
- C++: 3.5/5
- JavaScript: 4/5

Basic OOP concepts: inheritance, polymorphism, abstraction

Answer:
- Inheritance: Allows a class to inherit properties and methods from another class.
- Polymorphism: Allows methods to do different things based on the object it is acting upon.
- Abstraction: Hides the complex implementation details and shows only the necessary features.

What is a virtual function?

Answer: A virtual function is a function in a base class that can be overridden by derived classes. It allows for dynamic binding and polymorphism.

What is a dangling pointer?

Answer: A dangling pointer is a pointer that references a memory location that has been deallocated or freed.

Data Science

What is data science (as the course was mentioned in my resume)?

Answer: Data science is a field that uses scientific methods, processes, algorithms, and systems to extract knowledge and insights from structured and unstructured data. It involves statistics, machine learning, and data analysis.

Which Python libraries do you know and have you worked on?

Answer: I have worked with several Python libraries including:
- Pandas for data manipulation
- NumPy for numerical computing
- Scikit-learn for machine learning
- Matplotlib and Seaborn for data visualization

Comparing Programming Languages

What is the difference between C++ and Java?

Answer:
- C++: Supports both procedural and object-oriented programming, uses pointers, and requires manual memory management.
- Java: Purely object-oriented, uses automatic garbage collection, and does not support pointers.

The difference between call by value and call by reference with syntax

Answer:

Call by Value: Passes a copy of the value to the function.

void func(int x) {
  x = 10;
}
int main() {
  int a = 5;
  func(a); // a remains 5
}

Call by Reference: Passes the actual variable, allowing modifications.

void func(int &x) {
  x = 10;
}
int main() {
  int a = 5;
  func(a); // a becomes 10
}

Coding

Write a code to find the factorial of a number

Answer:

def factorial(n):
    if n == 0:
        return 1
    else:
        return n * factorial(n - 1)
 
number = 5
print(f"The factorial of {number} is {factorial(number)}")

HR Questions

Ready to relocate

Answer: Yes, I am open to relocating and am excited about the opportunity to work in different locations.

What are your hobbies?

Answer: My hobbies include coding, reading tech blogs, and playing chess. I also enjoy participating in hackathons and coding competitions.

Do you like to go out with your friends on weekends, etc.?

Answer: Yes, I enjoy going out with friends on weekends. It helps me unwind and maintain a good work-life balance.

Experience 3

Programming Question:-

Write a program to count number of characters in a string.
Write a program to print fibonacci series.

SQL queries:-

Write a query to print the first characters of FIRST_NAME from student table.
It was related to first query to print last character.

Syllabus