โ
Top Python Interview Questions ๐๐ก
1๏ธโฃ What is a string in Python?
Answer: A string is a sequence of characters enclosed in quotes (single, double, or triple).
Example: "Hello", 'World', '''Multi-line'''
2๏ธโฃ How do you reverse a string in Python?
Answer:
3๏ธโฃ Whatโs the difference between is and ==?
Answer:
โข == checks if values are equal
โข is checks if they are the same object in memory
4๏ธโฃ How do for and while loops differ?
Answer:
โข for loop is used for iterating over a sequence (list, string, etc.)
โข while loop runs as long as a condition is True
5๏ธโฃ What is the use of break, continue, and pass?
Answer:
โข break: exits the loop
โข continue: skips current iteration
โข pass: does nothing (placeholder)
6๏ธโฃ How to check if a substring exists in a string?
Answer:
7๏ธโฃ How do you use if-else conditions?
Answer:
8๏ธโฃ What are f-strings in Python?
Answer: Introduced in Python 3.6 for cleaner string formatting:
9๏ธโฃ How do you count characters or words in a string?
Answer:
๐ What is a nested loop?
Answer: A loop inside another loop:
๐ฌ Tap โค๏ธ for more!
1๏ธโฃ What is a string in Python?
Answer: A string is a sequence of characters enclosed in quotes (single, double, or triple).
Example: "Hello", 'World', '''Multi-line'''
2๏ธโฃ How do you reverse a string in Python?
Answer:
text = "hello"
reversed_text = text[::-1]
3๏ธโฃ Whatโs the difference between is and ==?
Answer:
โข == checks if values are equal
โข is checks if they are the same object in memory
4๏ธโฃ How do for and while loops differ?
Answer:
โข for loop is used for iterating over a sequence (list, string, etc.)
โข while loop runs as long as a condition is True
5๏ธโฃ What is the use of break, continue, and pass?
Answer:
โข break: exits the loop
โข continue: skips current iteration
โข pass: does nothing (placeholder)
6๏ธโฃ How to check if a substring exists in a string?
Answer:
"data" in "data science" # Returns True
7๏ธโฃ How do you use if-else conditions?
Answer:
x = 10
if x > 0:
print("Positive")
else:
print("Non-positive")
8๏ธโฃ What are f-strings in Python?
Answer: Introduced in Python 3.6 for cleaner string formatting:
name = "Riya"
print(f"Hello, {name}")
9๏ธโฃ How do you count characters or words in a string?
Answer:
text.count('a') # Count 'a'
len(text.split()) # Count words
๐ What is a nested loop?
Answer: A loop inside another loop:
for i in range(2):
for j in range(3):
print(i, j)
๐ฌ Tap โค๏ธ for more!
โค4
โ
OOP Interview Questions with Answers Part-2 ๐ก๐ป
11. What is Method Overriding?
It allows a subclass to provide a specific implementation of a method already defined in its superclass.
Example (Java):
12. What is a Constructor?
A constructor is a special method used to initialize objects. It has the same name as the class and no return type.
Runs automatically when an object is created.
13. Types of Constructors:
โข Default Constructor: Takes no parameters.
โข Parameterized Constructor: Takes arguments to set properties.
โข Copy Constructor (C++): Copies data from another object.
14. What is a Destructor?
Used in C++ to clean up memory/resources when an object is destroyed.
In Java,
15. Difference: Abstract Class vs Interface
| Feature | Abstract Class | Interface |
|---------------|----------------------|------------------------|
| Methods | Can have implemented | Only declarations (till Java 8) |
| Inheritance | One abstract class | Multiple interfaces |
| Use case | Partial abstraction | Full abstraction |
16. Can a Class Inherit Multiple Interfaces?
Yes. Java allows a class to implement multiple interfaces, enabling multiple inheritance of type, without ambiguity.
17. What is the super keyword?
Used to refer to the parent class:
โข Access parentโs constructor:
โข Call parent method:
18. What is the this keyword?
Refers to the current class instance. Useful when local and instance variables have the same name.
19. Difference: == vs .equals() in Java
โข
โข
Use
20. What are Static Members?
Static members belong to the class, not individual objects.
โข static variable: shared across all instances
โข static method: can be called without an object
๐ฌ Double Tap โฅ๏ธ for Part-3
11. What is Method Overriding?
It allows a subclass to provide a specific implementation of a method already defined in its superclass.
Example (Java):
class Animal {
void sound() { System.out.println("Animal sound"); }
}
class Dog extends Animal {
void sound() { System.out.println("Bark"); }
}
12. What is a Constructor?
A constructor is a special method used to initialize objects. It has the same name as the class and no return type.
Runs automatically when an object is created.
13. Types of Constructors:
โข Default Constructor: Takes no parameters.
โข Parameterized Constructor: Takes arguments to set properties.
โข Copy Constructor (C++): Copies data from another object.
14. What is a Destructor?
Used in C++ to clean up memory/resources when an object is destroyed.
In Java,
finalize() was used (deprecated now). Java uses garbage collection instead.15. Difference: Abstract Class vs Interface
| Feature | Abstract Class | Interface |
|---------------|----------------------|------------------------|
| Methods | Can have implemented | Only declarations (till Java 8) |
| Inheritance | One abstract class | Multiple interfaces |
| Use case | Partial abstraction | Full abstraction |
16. Can a Class Inherit Multiple Interfaces?
Yes. Java allows a class to implement multiple interfaces, enabling multiple inheritance of type, without ambiguity.
17. What is the super keyword?
Used to refer to the parent class:
โข Access parentโs constructor:
super()โข Call parent method:
super.methodName()18. What is the this keyword?
Refers to the current class instance. Useful when local and instance variables have the same name.
this.name = name;
19. Difference: == vs .equals() in Java
โข
== compares object references (memory address).โข
.equals() compares the content/values.Use
.equals() to compare strings or objects meaningfully.20. What are Static Members?
Static members belong to the class, not individual objects.
โข static variable: shared across all instances
โข static method: can be called without an object
๐ฌ Double Tap โฅ๏ธ for Part-3
โค8
โ
OOP Interview Questions with Answers Part-3 ๐ก๐ป
21. What is a final class or method?
โข A final class can't be extended.
โข A final method can't be overridden.
Useful for security, immutability (e.g., String class in Java is final).
22. What is object cloning?
โข Creating an exact copy of an object.
โข In Java: use .clone() method from Cloneable interface.
โข Shallow vs Deep cloning:
โ Shallow copies references.
โ Deep copies full object graph.
23. What is a singleton class?
โข A class that allows only one instance.
โข Ensures shared resource (like a config manager or DB connection).
โข Common in design patterns.
24. What are access specifiers?
Control visibility of class members:
โข public โ accessible everywhere
โข private โ only inside the class
โข protected โ inside class subclasses
โข (default) โ same package
25. What is cohesion in OOP?
โข Degree to which class elements belong together.
โข High cohesion = focused responsibility โ better design.
26. What is coupling?
โข Dependency between classes.
โข Low coupling = better modularity, easier maintenance.
27. Difference between tight and loose coupling?
โข Tight coupling: classes are strongly dependent โ harder to modify/test.
โข Loose coupling: minimal dependency โ promotes reusability, flexibility.
28. What is composition vs aggregation?
โข Composition: "part-of" strong relationship โ child can't exist without parent.
Example: Engine in a Car
โข Aggregation: weak association โ child can exist independently.
Example: Student in a University
29. Difference between association, aggregation, and composition?
โข Association: General relationship
โข Aggregation: Whole-part, but loose
โข Composition: Whole-part, tightly bound
30. What is the open/closed principle?
โข From SOLID:
โSoftware entities should be open for extension, but closed for modification.โ
โข Means add new code via inheritance, not by changing existing logic.
๐ฌ Double Tap โฅ๏ธ for Part-3
21. What is a final class or method?
โข A final class can't be extended.
โข A final method can't be overridden.
Useful for security, immutability (e.g., String class in Java is final).
22. What is object cloning?
โข Creating an exact copy of an object.
โข In Java: use .clone() method from Cloneable interface.
โข Shallow vs Deep cloning:
โ Shallow copies references.
โ Deep copies full object graph.
23. What is a singleton class?
โข A class that allows only one instance.
โข Ensures shared resource (like a config manager or DB connection).
โข Common in design patterns.
public class Singleton {
private static Singleton instance = new Singleton();
private Singleton() {}
public static Singleton getInstance() {
return instance;
}
}
24. What are access specifiers?
Control visibility of class members:
โข public โ accessible everywhere
โข private โ only inside the class
โข protected โ inside class subclasses
โข (default) โ same package
25. What is cohesion in OOP?
โข Degree to which class elements belong together.
โข High cohesion = focused responsibility โ better design.
26. What is coupling?
โข Dependency between classes.
โข Low coupling = better modularity, easier maintenance.
27. Difference between tight and loose coupling?
โข Tight coupling: classes are strongly dependent โ harder to modify/test.
โข Loose coupling: minimal dependency โ promotes reusability, flexibility.
28. What is composition vs aggregation?
โข Composition: "part-of" strong relationship โ child can't exist without parent.
Example: Engine in a Car
โข Aggregation: weak association โ child can exist independently.
Example: Student in a University
29. Difference between association, aggregation, and composition?
โข Association: General relationship
โข Aggregation: Whole-part, but loose
โข Composition: Whole-part, tightly bound
30. What is the open/closed principle?
โข From SOLID:
โSoftware entities should be open for extension, but closed for modification.โ
โข Means add new code via inheritance, not by changing existing logic.
๐ฌ Double Tap โฅ๏ธ for Part-3
โค4
๐๐ฅ๐๐ ๐ข๐ป๐น๐ถ๐ป๐ฒ ๐ ๐ฎ๐๐๐ฒ๐ฟ๐ฐ๐น๐ฎ๐๐ ๐ข๐ป ๐๐ฎ๐๐ฒ๐๐ ๐ง๐ฒ๐ฐ๐ต๐ป๐ผ๐น๐ผ๐ด๐ถ๐ฒ๐๐
- Data Science
- AI/ML
- Data Analytics
- UI/UX
- Full-stack Development
Get Job-Ready Guidance in Your Tech Journey
๐ฅ๐ฒ๐ด๐ถ๐๐๐ฒ๐ฟ ๐๐ผ๐ฟ ๐๐ฅ๐๐๐:-
https://pdlink.in/4sw5Ev8
Date :- 11th January 2026
- Data Science
- AI/ML
- Data Analytics
- UI/UX
- Full-stack Development
Get Job-Ready Guidance in Your Tech Journey
๐ฅ๐ฒ๐ด๐ถ๐๐๐ฒ๐ฟ ๐๐ผ๐ฟ ๐๐ฅ๐๐๐:-
https://pdlink.in/4sw5Ev8
Date :- 11th January 2026
โ
OOP Interview Questions with Answers Part-4 ๐ง ๐ป
31. What is SOLID in OOP?
SOLID is a set of 5 design principles for writing maintainable, scalable OOP code. It stands for:
S โ Single Responsibility
O โ Open/Closed
L โ Liskov Substitution
I โ Interface Segregation
D โ Dependency Inversion
32. Explain each SOLID principle briefly:
โข Single Responsibility โ A class should do one thing only.
โข Open/Closed โ Classes should be open for extension, but closed for modification.
โข Liskov Substitution โ Subclasses should replace their parent classes without breaking functionality.
โข Interface Segregation โ Prefer small, specific interfaces over large ones.
โข Dependency Inversion โ Depend on abstractions, not concrete classes.
33. What is Liskov Substitution Principle?
If a class S is a subclass of class T, objects of type T should be replaceable with objects of type S without affecting the program.
Example: A Bird base class with a
34. What is Dependency Inversion Principle?
High-level modules should not depend on low-level modules. Both should depend on abstractions.
Example: A service class should depend on an interface, not a specific implementation.
35. What is object slicing?
Occurs when an object of a derived class is assigned to a base class variable โ the extra properties of the derived class are "sliced off."
Example: C++ object slicing when passing by value.
36. What are getters and setters?
Special methods used to get and set values of private variables in a class.
They support encapsulation and validation.
37. What is a virtual function?
A function declared in the base class and overridden in the derived class, using the
38. What is early binding vs late binding?
โข Early Binding (Static): Method call is resolved at compile time (e.g., method overloading).
โข Late Binding (Dynamic): Method call is resolved at run-time (e.g., method overriding).
39. What is dynamic dispatch?
Itโs the process where the method to be invoked is determined at runtime based on the objectโs actual type โ used in method overriding (late binding).
40. What is a pure virtual function?
A virtual function with no implementation in the base class โ makes the class abstract.
Syntax (C++):
๐ฌ Double Tap โฅ๏ธ for Part-5
31. What is SOLID in OOP?
SOLID is a set of 5 design principles for writing maintainable, scalable OOP code. It stands for:
S โ Single Responsibility
O โ Open/Closed
L โ Liskov Substitution
I โ Interface Segregation
D โ Dependency Inversion
32. Explain each SOLID principle briefly:
โข Single Responsibility โ A class should do one thing only.
โข Open/Closed โ Classes should be open for extension, but closed for modification.
โข Liskov Substitution โ Subclasses should replace their parent classes without breaking functionality.
โข Interface Segregation โ Prefer small, specific interfaces over large ones.
โข Dependency Inversion โ Depend on abstractions, not concrete classes.
33. What is Liskov Substitution Principle?
If a class S is a subclass of class T, objects of type T should be replaceable with objects of type S without affecting the program.
Example: A Bird base class with a
fly() method may break if Penguin inherits it (Penguins can't fly). So, design must respect capabilities.34. What is Dependency Inversion Principle?
High-level modules should not depend on low-level modules. Both should depend on abstractions.
Example: A service class should depend on an interface, not a specific implementation.
35. What is object slicing?
Occurs when an object of a derived class is assigned to a base class variable โ the extra properties of the derived class are "sliced off."
Example: C++ object slicing when passing by value.
36. What are getters and setters?
Special methods used to get and set values of private variables in a class.
They support encapsulation and validation.
def get_name(self): return self._name
def set_name(self, name): self._name = name
37. What is a virtual function?
A function declared in the base class and overridden in the derived class, using the
virtual keyword (in C++). Enables run-time polymorphism.38. What is early binding vs late binding?
โข Early Binding (Static): Method call is resolved at compile time (e.g., method overloading).
โข Late Binding (Dynamic): Method call is resolved at run-time (e.g., method overriding).
39. What is dynamic dispatch?
Itโs the process where the method to be invoked is determined at runtime based on the objectโs actual type โ used in method overriding (late binding).
40. What is a pure virtual function?
A virtual function with no implementation in the base class โ makes the class abstract.
Syntax (C++):
virtual void draw() = 0;
๐ฌ Double Tap โฅ๏ธ for Part-5
โค5
๐๐ถ๐ด๐ต ๐๐ฒ๐บ๐ฎ๐ป๐ฑ๐ถ๐ป๐ด ๐๐ฒ๐ฟ๐๐ถ๐ณ๐ถ๐ฐ๐ฎ๐๐ถ๐ผ๐ป ๐๐ผ๐๐ฟ๐๐ฒ๐ ๐ช๐ถ๐๐ต ๐ฃ๐น๐ฎ๐ฐ๐ฒ๐บ๐ฒ๐ป๐ ๐๐๐๐ถ๐๐๐ฎ๐ป๐ฐ๐ฒ๐
Learn from IIT faculty and industry experts.
IIT Roorkee DS & AI Program :- https://pdlink.in/4qHVFkI
IIT Patna AI & ML :- https://pdlink.in/4pBNxkV
IIM Mumbai DM & Analytics :- https://pdlink.in/4jvuHdE
IIM Rohtak Product Management:- https://pdlink.in/4aMtk8i
IIT Roorkee Agentic Systems:- https://pdlink.in/4aTKgdc
Upskill in todayโs most in-demand tech domains and boost your career ๐
Learn from IIT faculty and industry experts.
IIT Roorkee DS & AI Program :- https://pdlink.in/4qHVFkI
IIT Patna AI & ML :- https://pdlink.in/4pBNxkV
IIM Mumbai DM & Analytics :- https://pdlink.in/4jvuHdE
IIM Rohtak Product Management:- https://pdlink.in/4aMtk8i
IIT Roorkee Agentic Systems:- https://pdlink.in/4aTKgdc
Upskill in todayโs most in-demand tech domains and boost your career ๐
โ
OOP Interview Questions with Answers Part-5 ๐ง ๐ป
41. What is multiple inheritance?
It means a class can inherit from more than one parent class.
โ Supported in C++
โ Not directly supported in Java (handled via interfaces)
42. What are mixins?
Mixins are a way to add reusable behavior to classes without using inheritance.
โ Used in Python and JavaScript
โ Promotes code reuse
43. What is the diamond problem in inheritance?
Occurs when two parent classes inherit from a common grandparent, and a child class inherits both.
โ Creates ambiguity about which method to inherit.
44. How is the diamond problem solved in C++ or Java?
โข C++: Uses virtual inheritance
โข Java: Avoids it entirely using interfaces (no multiple class inheritance)
45. What are abstract data types in OOP?
ADTs define what operations can be done, not how.
Examples: Stack, Queue, List
โ Implementation is hidden
โ Promotes abstraction
46. What is a design pattern in OOP?
Reusable solution to a common software design problem.
โ Templates for writing clean, maintainable code
47. What are some common OOP design patterns?
โข Singleton โ one instance
โข Factory โ object creation logic
โข Observer โ event-based updates
โข Strategy โ interchangeable behavior
โข Adapter โ interface compatibility
48. Interface vs Abstract Class (Real-world use)
โข Interface โ Contract; use when you want to define capability (e.g., Drivable)
โข Abstract Class โ Shared structure + behavior; base class for similar types (e.g., Vehicle)
49. What is garbage collection?
Automatic memory management โ reclaims memory from unused objects.
โ Java has a built-in GC
โ Prevents memory leaks
50. Real-world use of OOP?
โข Games โ Objects for players, enemies
โข Banking โ Classes for accounts, transactions
โข UI โ Buttons, forms as objects
โข E-commerce โ Products, carts, users as objects
๐ฌ Double Tap โค๏ธ For More!
41. What is multiple inheritance?
It means a class can inherit from more than one parent class.
โ Supported in C++
โ Not directly supported in Java (handled via interfaces)
42. What are mixins?
Mixins are a way to add reusable behavior to classes without using inheritance.
โ Used in Python and JavaScript
โ Promotes code reuse
43. What is the diamond problem in inheritance?
Occurs when two parent classes inherit from a common grandparent, and a child class inherits both.
โ Creates ambiguity about which method to inherit.
44. How is the diamond problem solved in C++ or Java?
โข C++: Uses virtual inheritance
โข Java: Avoids it entirely using interfaces (no multiple class inheritance)
45. What are abstract data types in OOP?
ADTs define what operations can be done, not how.
Examples: Stack, Queue, List
โ Implementation is hidden
โ Promotes abstraction
46. What is a design pattern in OOP?
Reusable solution to a common software design problem.
โ Templates for writing clean, maintainable code
47. What are some common OOP design patterns?
โข Singleton โ one instance
โข Factory โ object creation logic
โข Observer โ event-based updates
โข Strategy โ interchangeable behavior
โข Adapter โ interface compatibility
48. Interface vs Abstract Class (Real-world use)
โข Interface โ Contract; use when you want to define capability (e.g., Drivable)
โข Abstract Class โ Shared structure + behavior; base class for similar types (e.g., Vehicle)
49. What is garbage collection?
Automatic memory management โ reclaims memory from unused objects.
โ Java has a built-in GC
โ Prevents memory leaks
50. Real-world use of OOP?
โข Games โ Objects for players, enemies
โข Banking โ Classes for accounts, transactions
โข UI โ Buttons, forms as objects
โข E-commerce โ Products, carts, users as objects
๐ฌ Double Tap โค๏ธ For More!
โค4
๐ ๐๐ฎ๐๐ฎ ๐๐ป๐ฎ๐น๐๐๐ถ๐ฐ๐ ๐๐ฅ๐๐ ๐๐ฒ๐ฟ๐๐ถ๐ณ๐ถ๐ฐ๐ฎ๐๐ถ๐ผ๐ป ๐๐ผ๐๐ฟ๐๐ฒ๐
๐Upgrade your skills with industry-relevant Data Analytics training at ZERO cost
โ Beginner-friendly
โ Certificate on completion
โ High-demand skill in 2026
๐๐ข๐ง๐ค ๐:-
https://pdlink.in/497MMLw
๐ 100% FREE โ Limited seats available!
๐Upgrade your skills with industry-relevant Data Analytics training at ZERO cost
โ Beginner-friendly
โ Certificate on completion
โ High-demand skill in 2026
๐๐ข๐ง๐ค ๐:-
https://pdlink.in/497MMLw
๐ 100% FREE โ Limited seats available!
๐ SQL Interview Queries โ Intermediate Level
โโโโโโโโโโโโโโ
โ Query 01: Find employees earning more than the average salary
SELECT *
FROM employees
WHERE salary > (SELECT AVG(salary) FROM employees);
โ Query 02: Find department-wise employee count
SELECT department, COUNT(*) AS emp_count
FROM employees
GROUP BY department;
โ Query 03: Find departments with average salary greater than 60,000
SELECT department
FROM employees
GROUP BY department
HAVING AVG(salary) > 60000;
โ Query 04: Fetch employees who do not belong to any department
SELECT e.*
FROM employees e
LEFT JOIN departments d
ON e.department_id = d.department_id
WHERE d.department_id IS NULL;
โ Query 05: Find second highest salary
SELECT MAX(salary)
FROM employees
WHERE salary < (SELECT MAX(salary) FROM employees);
โ Query 06: Get highest salary in each department
SELECT department, MAX(salary)
FROM employees
GROUP BY department;
โ Query 07: Fetch employees hired in the last 6 months
SELECT *
FROM employees
WHERE hire_date >= DATE_SUB(CURDATE(), INTERVAL 6 MONTH);
โ Query 08: Find duplicate email IDs
SELECT email, COUNT(*)
FROM employees
GROUP BY email
HAVING COUNT(*) > 1;
โ Query 09: Rank employees by salary within each department
SELECT *,
RANK() OVER (PARTITION BY department ORDER BY salary DESC) AS rank
FROM employees;
โ Query 10: Fetch top 2 highest paid employees from each department
SELECT *
FROM (
SELECT *,
DENSE_RANK() OVER (PARTITION BY department ORDER BY salary DESC) AS rnk
FROM employees
) t
WHERE rnk <= 2;
๐ฅ Show some love with a reaction โค๏ธ
โโโโโโโโโโโโโโ
โ Query 01: Find employees earning more than the average salary
SELECT *
FROM employees
WHERE salary > (SELECT AVG(salary) FROM employees);
โ Query 02: Find department-wise employee count
SELECT department, COUNT(*) AS emp_count
FROM employees
GROUP BY department;
โ Query 03: Find departments with average salary greater than 60,000
SELECT department
FROM employees
GROUP BY department
HAVING AVG(salary) > 60000;
โ Query 04: Fetch employees who do not belong to any department
SELECT e.*
FROM employees e
LEFT JOIN departments d
ON e.department_id = d.department_id
WHERE d.department_id IS NULL;
โ Query 05: Find second highest salary
SELECT MAX(salary)
FROM employees
WHERE salary < (SELECT MAX(salary) FROM employees);
โ Query 06: Get highest salary in each department
SELECT department, MAX(salary)
FROM employees
GROUP BY department;
โ Query 07: Fetch employees hired in the last 6 months
SELECT *
FROM employees
WHERE hire_date >= DATE_SUB(CURDATE(), INTERVAL 6 MONTH);
โ Query 08: Find duplicate email IDs
SELECT email, COUNT(*)
FROM employees
GROUP BY email
HAVING COUNT(*) > 1;
โ Query 09: Rank employees by salary within each department
SELECT *,
RANK() OVER (PARTITION BY department ORDER BY salary DESC) AS rank
FROM employees;
โ Query 10: Fetch top 2 highest paid employees from each department
SELECT *
FROM (
SELECT *,
DENSE_RANK() OVER (PARTITION BY department ORDER BY salary DESC) AS rnk
FROM employees
) t
WHERE rnk <= 2;
๐ฅ Show some love with a reaction โค๏ธ
โค7
๐ฃ๐น๐ฎ๐ฐ๐ฒ๐บ๐ฒ๐ป๐ ๐๐๐๐ถ๐๐๐ฎ๐ป๐ฐ๐ฒ ๐ฃ๐ฟ๐ผ๐ด๐ฟ๐ฎ๐บ ๐ถ๐ป ๐๐ฎ๐๐ฎ ๐ฆ๐ฐ๐ถ๐ฒ๐ป๐ฐ๐ฒ ๐ฎ๐ป๐ฑ ๐๐ฟ๐๐ถ๐ณ๐ถ๐ฐ๐ถ๐ฎ๐น ๐๐ป๐๐ฒ๐น๐น๐ถ๐ด๐ฒ๐ป๐ฐ๐ฒ ๐ฏ๐ ๐๐๐ง ๐ฅ๐ผ๐ผ๐ฟ๐ธ๐ฒ๐ฒ๐
Deadline: 18th January 2026
Eligibility: Open to everyone
Duration: 6 Months
Program Mode: Online
Taught By: IIT Roorkee Professors
Companies majorly hire candidates having Data Science and Artificial Intelligence knowledge these days.
๐ฅ๐ฒ๐ด๐ถ๐๐๐ฟ๐ฎ๐๐ถ๐ผ๐ป ๐๐ถ๐ป๐ธ๐:
https://pdlink.in/4qHVFkI
Only Limited Seats Available!
Deadline: 18th January 2026
Eligibility: Open to everyone
Duration: 6 Months
Program Mode: Online
Taught By: IIT Roorkee Professors
Companies majorly hire candidates having Data Science and Artificial Intelligence knowledge these days.
๐ฅ๐ฒ๐ด๐ถ๐๐๐ฟ๐ฎ๐๐ถ๐ผ๐ป ๐๐ถ๐ป๐ธ๐:
https://pdlink.in/4qHVFkI
Only Limited Seats Available!
โค1
๐ Excel Interview Question
โ What is the difference between VLOOKUP and XLOOKUP?
๐ง Key Differences Explained Simply:
๐น Lookup Direction
โข VLOOKUP โ Can only search left to right
โข XLOOKUP โ Can search both left โ right and right โ left
๐น Column Dependency
โข VLOOKUP โ Depends on column number (breaks if columns move)
โข XLOOKUP โ No column number required (more reliable)
๐น Error Handling
โข VLOOKUP โ Returns #N/A if value not found
โข XLOOKUP โ Built-in option to handle missing values gracefully
๐น Flexibility & Performance
โข VLOOKUP โ Limited and outdated
โข XLOOKUP โ Modern, flexible, and recommended by Microsoft
๐ Final Verdict:
If Excel version allows, always prefer XLOOKUP for cleaner, safer, and future-proof formulas.
๐ฅ React โค๏ธ for more interview questions
โ What is the difference between VLOOKUP and XLOOKUP?
๐ง Key Differences Explained Simply:
๐น Lookup Direction
โข VLOOKUP โ Can only search left to right
โข XLOOKUP โ Can search both left โ right and right โ left
๐น Column Dependency
โข VLOOKUP โ Depends on column number (breaks if columns move)
โข XLOOKUP โ No column number required (more reliable)
๐น Error Handling
โข VLOOKUP โ Returns #N/A if value not found
โข XLOOKUP โ Built-in option to handle missing values gracefully
๐น Flexibility & Performance
โข VLOOKUP โ Limited and outdated
โข XLOOKUP โ Modern, flexible, and recommended by Microsoft
๐ Final Verdict:
If Excel version allows, always prefer XLOOKUP for cleaner, safer, and future-proof formulas.
๐ฅ React โค๏ธ for more interview questions
โค1
๐๐๐ฒ ๐๐๐ญ๐๐ซ ๐๐ฅ๐๐๐๐ฆ๐๐ง๐ญ - ๐๐๐ญ ๐๐ฅ๐๐๐๐ ๐๐ง ๐๐จ๐ฉ ๐๐๐'๐ฌ ๐
Learn Coding From Scratch - Lectures Taught By IIT Alumni
60+ Hiring Drives Every Month
๐๐ข๐ ๐ก๐ฅ๐ข๐ ๐ก๐ญ๐ฌ:-
๐ Trusted by 7500+ Students
๐ค 500+ Hiring Partners
๐ผ Avg. Rs. 7.4 LPA
๐ 41 LPA Highest Package
Eligibility: BTech / BCA / BSc / MCA / MSc
๐๐๐ ๐ข๐ฌ๐ญ๐๐ซ ๐๐จ๐ฐ๐ :-
https://pdlink.in/4hO7rWY
Hurry, limited seats available!
Learn Coding From Scratch - Lectures Taught By IIT Alumni
60+ Hiring Drives Every Month
๐๐ข๐ ๐ก๐ฅ๐ข๐ ๐ก๐ญ๐ฌ:-
๐ Trusted by 7500+ Students
๐ค 500+ Hiring Partners
๐ผ Avg. Rs. 7.4 LPA
๐ 41 LPA Highest Package
Eligibility: BTech / BCA / BSc / MCA / MSc
๐๐๐ ๐ข๐ฌ๐ญ๐๐ซ ๐๐จ๐ฐ๐ :-
https://pdlink.in/4hO7rWY
Hurry, limited seats available!