STAVTAR SOLUTIONS Interview Questions, Process, and Tips

Pen and paper round basic mcq

Pen and paper round basic mcq

Q1. Questions form Resume
Add your answer
Q2. Data Structure and algorithm
Add your answer
Q3. SQL queries and DBMS theory
Add your answer

Q1. Again Question from Resume
Add your answer
Q2. Situation based questions
Add your answer
Q3. Manager is very good and polite
Add your answer

Q1. HR will finalize you salary and telling rules and regulations
Add your answer

Aptitude was 2 hours long and topics where pretty bit difficult like you're giving CA paper but there cut off was low so i guess everyone can clear it

Coding round was 2 hours long after clearing aptitude. It consist of OOPs SQL and all the questions and codes are in C++ so be prepared with it.

Q1. What is Polymorphism
Ans. 
Polymorphism is the ability of a function or method to behave differently based on the object it is acting upon.
• Polymorphism allows objects of different classes to be treated as objects of a common superclass.

• There are two types of polymorphism: compile-time (method overloading) and runtime (method overriding).

• Example: Animal class with methods like eat() can be inherited by Dog and Cat classes which can override the e...read more
Answered by AI
Add your answer
Q2. ACID Properties
Ans. 
ACID properties are a set of properties that guarantee database transactions are processed reliably.
• ACID stands for Atomicity, Consistency, Isolation, Durability

• Atomicity ensures that all operations in a transaction are completed successfully or none at all

• Consistency ensures that the database remains in a consistent state before and after the transaction

• Isolation ensures that transactions are executed independently of...read more
Answered by AI
Add your answer
Q3. What is data structure
Ans. 
Data structure is a way of organizing and storing data in a computer so that it can be accessed and used efficiently.
• Data structures define the way data is organized and stored in memory.

• Examples include arrays, linked lists, stacks, queues, trees, and graphs.

• Different data structures have different strengths and weaknesses for different types of operations.
Answered by AI
Add your answer
Q4. Which data structure is better between Stack and Queue. Difference between both
Ans. 
Stack is better for LIFO operations, Queue is better for FIFO operations.
• Stack is a Last In First Out (LIFO) data structure, while Queue is a First In First Out (FIFO) data structure.

• Stack is suitable for applications like function call stack, undo mechanisms, and backtracking.

• Queue is useful in scenarios like task scheduling, breadth-first search, and printer queues.
Answered by AI
Add your answer

Pen and paper test basic aptitude questions and technical pen and paper test based on oops

Q1. DSA, sorting algorithms, DBMS
Add your answer
Q2. OOPS pillars, SQL
Add your answer

Q1. Some technical based as HR was technical
Add your answer
Q2. Pointer, unsigned and signed int, projects
Add your answer

Basic aptitude questions on testing(manual and automation)

Q1. Basic questions on core java, SQL
Add your answer
Q2. What are the joins in SQL Difference between abstraction and interference
Ans. 
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
• Joins in SQL include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• INNER JOIN returns rows when there is at least one match in both tables.

• LEFT JOIN returns all rows from the left table and the matched rows from the right table.

• RIGHT JOIN returns all rows from the right table and the matched rows from the left table.

• ...read more
Answered by AI
Add your answer

This was the toughest part. Coding questions were on SQL and java