Apptomate Digital Softwaretest Engineer Interview Questions and Answers

Q1. Whatever written in cv keep it in mind
Add your answer

Q1. One to one round with manager
Add your answer

Q1. Final salary discussion
Add your answer

Coding Test consists of 3 Problem Question (2 Logical questions and 1 SQL Query ) and Around 20 MCQS
Platform - CoderByte

30 Aptitude Question
3 Mail Writing Question

Q1. Explain 1st Problem Solved in Coding Test. Optimize it.
Add your answer
Q2. Explain 2nd Problem Solved in Coding Test. I failed 1 test case in 1st round which was told to solve again.
Add your answer
Q3. Explain 3rd Question based on SQL Query.
Add your answer
Q4. Write a code to Reverse Digits.
View 1 more answer
Q5. A problem question for solving a SQL Query.
Add your answer

Coding Test was on Coderbyte. Consisted 4 questions. 1 coding and 3 of web developement.

Q1. General HR questions.
Add your answer

Q1. General Techinal questions
Add your answer

Q1. Spark architecture.
Add your answer
Q2. Narrow and wide transformations
Add your answer

Q1. Strecture of sql statement
Ans. 
SQL statements are used to interact with databases by performing operations like querying, updating, and deleting data.
• SQL statements are made up of keywords like SELECT, INSERT, UPDATE, DELETE, etc.

• They are structured in a specific order, with clauses like WHERE, ORDER BY, GROUP BY, etc.

• Tables are referenced using their names, and conditions are specified to filter data.

• Joins can be used to combine data from multiple
Answered by AI
Add your answer

Q1. What programming language are you most proficient?
Ans. 
I am most proficient in Java.
• Extensive experience in developing applications using Java

• Strong understanding of object-oriented programming principles

• Familiarity with popular Java frameworks like Spring and Hibernate
Answered by AI
Add your answer
Q2. .NET, Angular and Sql Server
Add your answer

Q1. How would you design a system that needs to handle million of records
Ans. 
I would design a system using scalable architecture, efficient data storage, and optimized query processing.
• Utilize a distributed database system like Cassandra or Hadoop for storing large volumes of data

• Implement data partitioning and sharding to distribute the data across multiple servers

• Use indexing and caching mechanisms to optimize query performance

• Employ load balancing techniques to evenly distribute incoming req...read more
Answered by AI
Add your answer

Multiple choice questions and depends on therotical part

Q1. What is Software testing?
Ans. 
Software testing is the process of evaluating a software application or system to identify defects or errors.
• Software testing is essential to ensure the quality and reliability of software.

• It involves executing test cases and comparing the actual results with expected results.

• Testing can be done manually or using automated tools.

• Types of testing include functional, performance, security, and usability testing.

• Examples ...read more
Answered by AI
View 1 more answer

Q1. Salary discussion
Add your answer

Q1. Questions was based on SQL
Add your answer
Q2. SQL queries and joins and
Add your answer