Optech Engineering Interview Questions and Answers

Dictionary is a collection of key-value pairs in Python.

• Keys must be unique and immutable.

• Values can be of any data type.

• Access values using keys.

• Add or modify values using keys.

• Use dict() constructor or {} to create a dictionary.

• Example: {'name': 'John', 'age': 30}

• Example: dict(name='John', age=30)

OOPs concepts in Java are the fundamental principles of object-oriented programming.

• Encapsulation: wrapping data and code into a single unit

• Inheritance: creating new classes from existing ones

• Polymorphism: using a single interface to represent multiple types

• Abstraction: hiding implementation details from the user

• Examples: class, object, inheritance, polymorphism, encapsulation

Stack is a LIFO data structure while Queue is a FIFO data structure.

• Stack follows Last In First Out (LIFO) principle while Queue follows First In First Out (FIFO) principle.

• Stack has two main operations: push and pop while Queue has two main operations: enqueue and dequeue.

• Stack is used in recursive function calls, undo/redo operations, and backtracking while Queue is used in breadth-first search, printing tasks in ord...read more

SQL query to find second highest salary in database

• Use ORDER BY and LIMIT to get the second highest salary

• Assume ties are allowed and use DISTINCT

Method overloading is having multiple methods with the same name but different parameters. Method overriding is having a method in a subclass with the same name and parameters as a method in its superclass.

• Method overloading is done within the same class while method overriding is done in different classes (subclass and superclass).

• Method overloading is achieved by changing the number of parameters or the data type of ...read more

The parent class of all classes in Java is the Object class.

• All classes in Java implicitly extend the Object class.

• The Object class provides basic methods such as toString(), equals(), and hashCode().

• Any class can override these methods to provide custom implementations.

• Example: public class MyClass extends Object { ... }

• Example: Object obj = new MyClass();

SQL databases are relational and use structured query language, while NoSQL databases are non-relational and use various data models.

• SQL databases are based on a fixed schema, while NoSQL databases are schema-less.

• SQL databases use tables to store data, while NoSQL databases use various data models like key-value, document, columnar, or graph.

• SQL databases are better suited for complex queries and structured data, whil...read more

TCS stands for Tata Consultancy Services, a multinational IT services company based in India.

• TCS is one of the largest IT services companies in the world.

• It provides a wide range of services including consulting, software development, and business process outsourcing.

• TCS has clients in various industries such as banking, healthcare, and retail.

• The company has a strong focus on innovation and has several research and de...read more

I tackle challenges by breaking them down into smaller tasks and staying focused on the end goal.

• I analyze the challenge and identify the root cause

• I break down the challenge into smaller, manageable tasks

• I prioritize the tasks and create a plan of action

• I stay focused on the end goal and remain persistent

• I seek help or advice when needed

• Example: When faced with a tight deadline, I prioritize tasks and delegate respons...read more