Accord Software & Systems Software Engineer Trainee Interview Questions and Answers

DSA, SQL, Problem Solving, Technical, Data Structures and Algorithms

Q1. Write an SQL Query for retrieving something
Ans. 
SQL query to retrieve data from a database
• Use SELECT statement to specify the columns to retrieve

• Use FROM clause to specify the table to retrieve data from

• Use WHERE clause to filter the results based on conditions
Answered by AI
Add your answer
Q2. Write a program to achieve something
Ans. 
Program to sort an array of integers in ascending order
• Use a sorting algorithm like bubble sort, selection sort, or insertion sort

• Iterate through the array and compare adjacent elements to swap if necessary

• Repeat the process until the array is sorted
Answered by AI
Add your answer

Q1. DSA Array, String and Hashmap questions
Add your answer
Q2. Functional programming java questions
Add your answer

Q1. Spring and spring boot related
Add your answer
Q2. HLD scenario level questions
Add your answer
Q3. SQL queries nested and joins
Add your answer
Q4. DB related questions and experience level questions and previous project situations related questions
Add your answer
Q5. Security level questions like XSS vulnerability and SQL injection
Add your answer

Q1. Write a Simple GET, POST Flask Application?
Add your answer
Q2. Assign Values to a Cookie - Flask Application
Add your answer

- Convert a given input of keys-values to value-keys using Python

Q1. Introducing your self and project
Add your answer
Q2. Severity and priority
Add your answer
Q3. Smoke and sanity testing
Add your answer
Q4. Scenario base question if find bug before release
Add your answer

Machine coding round

Q1. TCP/IP related questions, what happens when you search a webpage?
Add your answer
Q2. Past projects discussions
Add your answer

Q1. Behavioural questions on how would you tackle a particular scenario
Add your answer

Q1. My expertise are in golang. And all the questions were straight forward around golang.
Add your answer
Q2. What is concurrency. How to check performance of applications. How to handle concurrency. How many no of goroutines can be created and so on.
Ans. 
Concurrency is the ability of a system to run multiple tasks simultaneously. Performance of applications can be checked using profiling tools. Concurrency can be handled using synchronization techniques like mutexes and channels.
• Concurrency allows multiple tasks to run concurrently, improving performance and responsiveness.

• Performance of applications can be checked using profiling tools like Go's built-in 'pprof' packa...read more
Answered by AI
Add your answer

Q1. How to make sure there are no vulnerabilities. What engineering principles you follow.
Ans. 
To ensure no vulnerabilities, follow secure coding practices, conduct regular security audits, use encryption, and stay updated on security threats.
• Follow secure coding practices such as input validation, output encoding, and parameterized queries.

• Conduct regular security audits to identify and address vulnerabilities in the code.

• Use encryption to protect sensitive data in transit and at rest.

• Stay updated on security t...read more
Answered by AI
Add your answer

Basic OOP questions for python programming language

Q1. What's abstraction
Ans. 
Abstraction is the concept of hiding complex implementation details and showing only the necessary information to the user.
• Abstraction allows users to focus on what an object does instead of how it does it

• It helps in reducing complexity and improving efficiency in software development

• Example: In object-oriented programming, abstract classes and interfaces are used to achieve abstraction
Answered by AI
Add your answer
Q2. What's the difference between SQL and NoSQL database
Ans. 
SQL databases are relational databases with structured data, while NoSQL databases are non-relational databases with flexible, unstructured data.
• SQL databases use structured query language for defining and manipulating data, while NoSQL databases use different query languages or APIs.

• SQL databases are table-based, with a predefined schema, while NoSQL databases are document, key-value, wide-column, or graph-based.

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

Q1. Reverse a linked list
Ans. 
Reverse a linked list by changing the direction of pointers
• Start with three pointers: current, prev, and next

• Iterate through the linked list, updating pointers to reverse the direction

• Update the head of the linked list to the last node after reversing
Answered by AI
Add your answer
Q2. Implement binary search algorithm
Ans. 
Binary search algorithm efficiently finds the target value in a sorted array.
• Start by defining the low and high indices of the array.

• Calculate the mid index and compare the target value with the value at mid.

• If target is less than mid value, update high to mid-1; if greater, update low to mid+1.

• Repeat until target is found or low is greater than high.
Answered by AI
Add your answer

Q1. Brief Introduction and basic questions
Add your answer
Q2. Future plans and how am i going to achieve them
Add your answer

Q1. Projects worked on
Add your answer
Q2. Coding leetcode easy/medium questions
Add your answer

Q1. Tell me about yourself
Add your answer