10+ Savita Oil Technologies Interview Questions and Answers

Overloading is having multiple methods with the same name but different parameters. Overriding is having a method in a subclass with the same name and parameters as a method in the superclass.

• Overloading is used to provide different ways of calling the same method with different parameters.

• Overriding is used to provide a specific implementation of a method in a subclass that is already defined in the superclass.

• Overloading is resolved at compile-time based on the number and t...read more

The 100 floors puzzle involves finding the highest floor from which an egg can be dropped without breaking.

• Start from the 14th floor and drop the egg. If it breaks, start from the 1st floor and move up one by one. If it doesn't break, move up by 13 floors and repeat the process.

• The optimal solution involves dropping the egg from a certain floor and then adjusting the interval based on whether it breaks or not.

• The worst-case scenario for this puzzle is dropping the egg from ev...read more

Implement Radix sort algorithm without using STL in C++ for array of strings

• Create a helper function to find the maximum length string in the array

• Iterate through each digit place starting from the least significant digit

• Use counting sort to sort the array based on the current digit place

Method overloading is having multiple methods in the same class 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 the superclass.

• Method overloading allows a class to have multiple methods with the same name but different parameters.

• Method overriding occurs when a subclass provides a specific implementation of a method that is already provided by its superclass.

• Example of method over...read more

ERD diagram for a school database

• Entities: Student, Teacher, Course, Classroom

• Relationships: Student enrolls in Course, Teacher teaches Course, Course assigned to Classroom

• Attributes: Student ID, Teacher ID, Course ID, Classroom ID

Index is a database object that improves the speed of data retrieval operations.

• Indexes are created on one or more columns of a table.

• They can be clustered or non-clustered.

• Clustered indexes determine the physical order of data in a table.

• Non-clustered indexes have a separate structure that includes the indexed columns and a pointer to the actual data.

• Indexes can be created using CREATE INDEX statement.

• Indexes can also be dropped using DROP INDEX statement.

DBMS theory covers concepts like data modeling, query languages, transaction management, and database design.

• DBMS stands for Database Management System

• It includes data modeling, which involves designing the structure of the database

• Query languages like SQL are used to retrieve and manipulate data

• Transaction management ensures data integrity and consistency

• Database design involves creating schemas and relationships between tables

MySQL version 8.0.23, Postgres version 13.2. MySQL runs on port 3306 and Postgres runs on port 5432.

• MySQL version: 8.0.23

• Postgres version: 13.2

• MySQL port: 3306

• Postgres port: 5432

Ping command is used to test the reachability of a host on an IP network. Telnet is used to establish a connection to a remote computer.

• Ping command sends ICMP echo request packets to the target host and waits for a response.

• Telnet command establishes a TCP connection to a specified port on a remote host.

• Ping is commonly used to troubleshoot network connectivity issues.

• Telnet can be used to test if a specific port is open on a remote server.

• Both commands are available on most...read more

I primarily use SQL Server 2019 for database management.

• I am proficient in writing queries, stored procedures, and triggers in T-SQL.

• I have experience with SQL Server Management Studio for database administration.

• I am familiar with the latest features and enhancements in SQL Server 2019.

MySQL version 5.7.21 running on port 3306

• MySQL version 5.7.21 is currently in use

• The MySQL server is running on port 3306

Various protocols and their corresponding port numbers used in networking.

• HTTP - Port 80

• HTTPS - Port 443

• FTP - Port 21

• SMTP - Port 25

• SSH - Port 22

Port numbers are used to identify specific services or protocols running on a network device.

• HTTP - Port 80

• HTTPS - Port 443

• FTP - Port 21

• SSH - Port 22

• SMTP - Port 25

• DNS - Port 53

The OSI model is a conceptual framework that standardizes the functions of a telecommunication or computing system into seven layers.

• The OSI model stands for Open Systems Interconnection model.

• It helps in understanding how data is transferred from one computer to another over a network.

• The seven layers are: Physical, Data Link, Network, Transport, Session, Presentation, and Application.

• Each layer has specific functions and interacts with adjacent layers for data communication...read more

API attributes are properties or characteristics of an API that define its behavior and functionality.

• API attributes can include things like authentication methods, request/response formats, rate limits, and error handling.

• Examples of API attributes include JSON or XML as request/response formats, OAuth2 as an authentication method, and a maximum of 1000 requests per hour as a rate limit.