Thakral One Solutions Interview Questions, Process, and Tips

In simform Interview Aptitude test is just a common test which contains all types of questions it includes reasoning, aptitude, c language pseudocode and verbal ability questions. Questions are easy to moderate not so difficult.

Simform coding test is having 5 coding problems. Which includes simple array and DSA related problems . 3 problems are easy to moderate . 1 or 2 problems they give little bit hard . They ask a big SQL query also as a coding problem in that 5 problems . You have to solve atleast 3 or more problems to comfortably pass coding round .

Q1. In Interview round they will ask Basic questions related to your preferred job domain. In my case I have applied for React js developer they asked me javascript questions and commonly database questions. T...read more
Add your answer
Q2. 1. What is difference between abstract class and interface ?
Ans. 
Abstract class can have implementation while interface cannot. A class can implement multiple interfaces but only extend one abstract class.
• Abstract class can have constructors while interface cannot.

• Abstract class can have non-abstract methods while interface can only have abstract methods.

• A class can implement multiple interfaces but only extend one abstract class.

• Abstract class can have instance variables while inte...read more
Answered by AI
Add your answer
Q3. 2. What is Arrow Function in Javascripts?
Ans. 
Arrow functions are a concise way to write functions in JavaScript.
• Arrow functions have a shorter syntax compared to regular functions.

• They do not have their own 'this' value, instead, they inherit 'this' from the surrounding context.

• Arrow functions are always anonymous and cannot be used as constructors.

• They are commonly used in React components for event handlers and callback functions.
Answered by AI
View 2 more answers
Q4. 3. What is Difference between primary key and unique key ?
Ans. 
Primary key uniquely identifies a record in a table, while unique key ensures that all values in a column are distinct.
• Primary key is used to enforce entity integrity, while unique key enforces domain integrity.

• A table can have only one primary key, but multiple unique keys.

• Primary key can't have null values, while unique key can have null values.

• Primary key is automatically indexed, while unique key may or may not be
Answered by AI
View 1 more answer
Q5. 4. how you join three different tables in SQL ?
Ans. 
To join three different tables in SQL, you can use the JOIN keyword along with the appropriate join conditions.
• Use the JOIN keyword to combine tables based on a common column

• Specify the join conditions using the ON keyword

• You can join more than two tables by chaining multiple JOIN statements

• Different types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
Answered by AI
View 1 more answer
Q6. 5. Why we require interface and what is interface in java ?
Ans. 
Interfaces in Java provide a way to achieve abstraction and multiple inheritance.
• Interfaces define a set of methods that a class must implement.

• They allow for loose coupling between classes.

• Interfaces can be used to achieve polymorphism.

• Java does not support multiple inheritance, but interfaces provide a way to achieve it.

• Interfaces are used extensively in Java frameworks like Spring and Hibernate.
Answered by AI
Add your answer
Q7. 6. What is Encapsulation in java with example ?
Ans. 
Encapsulation is a mechanism of wrapping data and code acting on the data together as a single unit.
• Encapsulation is used to hide the implementation details of an object from the outside world.

• It helps in achieving data abstraction and data hiding.

• In Java, encapsulation is achieved by declaring the variables of a class as private and providing public getter and setter methods to access and modify the data.

• Example: A ba...read more
Answered by AI
Add your answer
Q8. 7. Is exception handling is required in a big project or we don't have to handle exception?
Ans. 
Yes, exception handling is required in a big project.
• Exception handling helps in identifying and resolving errors during runtime.

• It improves the stability and reliability of the application.

• Exceptions can occur due to various reasons like network issues, server errors, or user input errors.

• Handling exceptions gracefully prevents the application from crashing and provides a better user experience.

• It allows for proper er...read more
Answered by AI
View 1 more answer
Q9. 8. do you have any master 's plan or further studies in abroad?
Ans. 
Yes, I have plans to pursue a master's degree in abroad.
• I have always been passionate about learning and expanding my knowledge in the field of frontend development.

• Pursuing a master's degree in a foreign country will provide me with a global perspective and exposure to diverse cultures.

• I believe that studying abroad will enhance my skills and make me a more well-rounded developer.

• I have researched various universities...read more
Answered by AI
View 1 more answer
Q10. 9. What is difference between overloading and overriding?
Ans. 
Overloading is having multiple methods with the same name but different parameters. Overriding is implementing a method in a subclass that already exists in the parent class.
• Overloading is compile-time polymorphism while overriding is runtime polymorphism.

• 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...read more
Answered by AI
Add your answer
Q11. 10. Which are the access specifiers in java ?
Ans. 
Access specifiers in Java are keywords that determine the visibility of a class, method, or variable.
• There are four access specifiers in Java: public, private, protected, and default.

• Public: accessible from anywhere in the program.

• Private: accessible only within the same class.

• Protected: accessible within the same class, subclasses, and same package.

• Default: accessible within the same package only.
Answered by AI
Add your answer

- 30 MCQ questions mostly related to HTML, JS & C#
- 2 easy-moderate coding questions

- Aptitude test on CoCubes (12 mins)
- English Test (speaking + writing + reading + listening) on Pearson platform

Q1. Print the following pattern: (was asked to complete test execution within 10 mins) ****4 ***444 **44444 *4444444 444444444
Add your answer
Q2. Find the length of longest substring composed of same digit, within a string of digits: (was asked to complete within 10 mins) E.g. 01241XXXXX901111 Output: 4 Explanation: "1111" is the longest substring
Ans. 
Find the length of longest substring composed of same digit within a string of digits.
• Iterate through the string and keep track of the current digit and its count

• Update the maximum count whenever a new digit is encountered

• Return the maximum count
Answered by AI
View 3 more answers
Q3. An SQL SPROC that is supposed to return tabular data is running slowly, what are the different ways you could debug it?
Ans. 1. Check for unnecessary columns in SELECT statement 2. Check if there's any cursor present in the SPROC 3. Check if columns have been properly indexed (specifically the columns being used in ORDER BY) 4. Check if data is being paged 5. etc.
Answered Anonymously
View 1 more answer
Q4. An API is running slow. Upon investigation it was found that SPROC running behind it is perfectly optimized. How can you debug this behavior of API? (You can neglect the resolve time & connect time of the ...read more
Ans. 
To debug the slow behavior of the API, analyze network latency, check for database issues, monitor server performance, and review code for potential bottlenecks.
• Analyze network latency to identify any issues with data transmission.

• Check for database issues such as slow queries or insufficient indexing.

• Monitor server performance to ensure it has enough resources and is not overloaded.

• Review the code for potential bottle...read more
Answered by AI
View 2 more answers

Q1. Check if two strings are anagrams of each other. Follow up question: solve it in O(N) time. (Time limit to solve question: 10 mins)
View 1 more answer
Q2. Given Tables: 1. Authors (AuthorId PK, Name) 2. Books (BookId PK, AuthorId FK, Name) 3. Orders (OrderId PK, BookID FK, AuthorId FK, StoreName) Write SQL query to print following information for each autho...read more
Add your answer
Q3. Questions about an open source distributive caching project that I implemented. Wanted to know what flaws do I see in the project and how do I plan to resolve them. Few follow up questions regarding cachin...read more
Add your answer

Q1. Given an array of integers (both positive and negative) find the maximum and second maximum number without using sort and using only single loop.
Ans. 
Find maximum and second maximum number in an array without using sort and single loop.
• Initialize max and secondMax variables to the smallest possible integer value

• Iterate through the array and update max and secondMax accordingly

• Return max and secondMax as the result
Answered by AI
View 1 more answer
Q2. Given Table: Weather (CityName, Date, Temperature) Write an SQL query which prints the following: "CityName, Today's Temperature, Yesterday's Temprature" (if yesterday's temperature doesn't exist, then p...read more
Add your answer
Q3. Given Table: ExamResults (StudentName, SubjectName, Marks) Write an SQL query to print the following: 1. "Student Name, Percentage" (Marks are out of 100) 2. List of all students having percentage great...read more
Add your answer