Vistaar Technologies Trainee Interview Questions and Answers

Train questions, quant, reasoning

Q1. What is binary search puzzle
Ans. 
Binary search is a search algorithm that finds the position of a target value within a sorted array.
• Divide the array in half and compare the target value with the middle element

• If the target value is smaller, search the left half of the array. If larger, search the right half

• Repeat the process until the target value is found or the subarray is empty
Answered by AI
Add your answer
Q2. What is hashMap
Ans. 
HashMap is a data structure in Java that stores key-value pairs and allows for fast retrieval of values based on keys.
• HashMap is part of the Java Collections framework.

• It uses hashing to store and retrieve elements quickly.

• Each key in a HashMap must be unique.

• Example: HashMap map = new HashMap<>(); map.put("apple", 5); int value = map.get("apple");
Answered by AI
Add your answer
Q3. Dbms queries views joins
Add your answer

Q1. Puzzle data structure
Add your answer
Q2. Pattern problem
Add your answer
Q3. OS threads, Software development lifecycle
Add your answer

Q1. Normal hr questions
Add your answer
Q2. Tell me about yourself
Add your answer
Q3. About family, home location, where do u stary
Add your answer

Aptitude, Logical, Data Structures, Coding

Q1. Tell me abt the projects that you have developed during academics?
Ans. 
I have developed multiple projects during my academics including a web-based student management system and a mobile app for tracking daily expenses.
• Web-based student management system: Developed using HTML, CSS, JavaScript, PHP, and MySQL. Allowed users to register, login, and manage their academic information.

• Mobile app for tracking daily expenses: Built using React Native. Users could input their daily expenses and v
Answered by AI
Add your answer
Q2. Difference between delete, truncate and drop in SQL?
Ans. 
Delete removes specific rows, truncate removes all rows, drop removes entire table structure.
• Delete is a DML command used to remove specific rows from a table.

• Truncate is a DDL command used to remove all rows from a table.

• Drop is a DDL command used to remove the entire table structure.

• Delete can be rolled back, truncate cannot be rolled back, drop cannot be rolled back.
Answered by AI
Add your answer

Questions were directly from indiabix without changing the values ans dsa mcq and 2 programs

Q1. Oops,query c++ basic and 2 puzzels
Add your answer

Java , dba , sql , network architecure etc

Q1. Tell me about yourself
Add your answer
Q2. Just told what's there in my resume with mentioning their benefits
Add your answer