Osfin.ai Data Analyst Intern Interview Questions and Answers

Time series and regression

Queries and commands

It was a training+ internship

Q1. NUmber of groups and group wise projects
Add your answer

Aptitude test was the basics asked in every exam

Q1. What is difference between 4stroke and 2 stroke engine?
Ans. 
4-stroke engines have 4 strokes per cycle, while 2-stroke engines have 2 strokes per cycle.
• 4-stroke engines are more fuel-efficient and produce less pollution than 2-stroke engines.

• 2-stroke engines are simpler and lighter than 4-stroke engines.

• 4-stroke engines have separate intake, compression, power, and exhaust strokes, while 2-stroke engines combine intake and compression, and power and exhaust strokes.

• Examples of 4...read more
Answered by AI
Add your answer
Q2. What is a bevel gear? Give an example
Ans. 
A bevel gear is a type of gear used to transmit power between shafts at an angle.
• Bevel gears have conical shapes and are used to change the direction of rotation.

• They are commonly used in automobiles, airplanes, and power plants.

• An example of a bevel gear is the ring and pinion gear in a car's differential.

• Another example is the bevel gear used in a hand drill to transmit power from the motor to the chuck.
Answered by AI
Add your answer

Q1. Question from pseudo code, ds and grammar are asked
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. Exception handling in java
Ans. 
Exception handling in Java allows for the handling of errors and exceptions that may occur during program execution.
• Java provides try-catch blocks to handle exceptions.

• The try block contains the code that may throw an exception.

• The catch block catches and handles the thrown exception.

• Multiple catch blocks can be used to handle different types of exceptions.

• The finally block is optional and is executed regardless of whe...read more
Answered by AI
View 1 more answer
Q3. Memory management in java
Ans. 
Memory management in Java involves automatic garbage collection and manual memory allocation.
• Java uses automatic garbage collection to free up memory

• Developers can manually allocate memory using the 'new' keyword

• Java also has a 'finalize' method to clean up resources before garbage collection

• Memory leaks can occur if objects are not properly released
Answered by AI
Add your answer
Q4. What is Hash map in java
Ans. 
Hash map is a data structure that stores key-value pairs and allows fast retrieval of values based on keys.
• Hash map uses hashing to store and retrieve values based on keys

• It allows null values and null keys

• It is not synchronized and not thread-safe

• Example: HashMap map = new HashMap<>();

• map.put("apple", 1); int value = map.get("apple");
Answered by AI
Add your answer
Q5. Primary key and candidate key difference
Ans. 
Primary key uniquely identifies a record while candidate key can also uniquely identify a record but may not be chosen as primary key.
• Primary key is a column or set of columns that uniquely identifies each record in a table

• Candidate key is a column or set of columns that can also uniquely identify each record in a table

• A table can have multiple candidate keys but only one primary key

• Primary key cannot have null values ...read more
Answered by AI
Add your answer
Q6. Super key and foreign key difference
Ans. 
Super key is a set of attributes that uniquely identifies a record, while foreign key is a reference to a primary key in another table.
• Super key is a combination of one or more attributes that uniquely identifies a record in a table.

• Foreign key is a field in a table that refers to the primary key of another table.

• Super key can have additional attributes that are not necessary for uniqueness.

• Foreign key establishes a re...read more
Answered by AI
View 1 more answer
Q7. List all languages in Sql and explain
Ans. 
List of SQL languages and their brief explanation
• SQL (Structured Query Language) is a standard language for managing relational databases

• T-SQL (Transact-SQL) is a proprietary extension of SQL used by Microsoft SQL Server

• PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's proprietary extension of SQL

• MySQL is an open-source relational database management system that uses SQL

• PostgreSQL is an ope...read more
Answered by AI
Add your answer
Q8. And some questions related to project
Add your answer

Python sql powerbi excel

Q1. They asked me two das questions one is medium and second one is hard..
Add your answer
Q2. They asked me about Sliding window techniqur and gave a problem to solve
Add your answer
Q3. They ask u about ur projects
Add your answer