DBS Tech Software Developer Interview Questions and Answers

Nested graph question, matrix question on hackerrank

Q1. Related to SQL mostly i.e., joins
Add your answer
Q2. Give two tables perform different type of joins
Ans. 
Two tables performing different types of joins
• Inner join: Returns rows when there is a 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

• Full outer join: Returns all rows when there is a match in either table
Answered by AI
Add your answer
Q3. Puzzle related to candles
Add your answer

Q1. So many questions were there to check ability to response without hesitation
Add your answer
Q2. Contribution to the company along with their values
Add your answer

1 Hour Basic Aptitude

2 Coding questions on Stacks and Array

Q1. If else question
Add your answer
Q2. Project based security questions , then oops and os concepts
Add your answer

Round duration - 90 minutes
Round difficulty - Easy

Q1. 
Occurrence of Each Word: Problem Statement
You are given a string S consisting of several words. Your task is to count the number of times each word appears in string S. A word is defined as a sequence of...read more
Ans. 
Count the occurrence of each word in a given string.
• Split the string into words using spaces as delimiters.

• Use a hashmap to store the count of each word.

• Iterate through the words and update the count in the hashmap.

• Output each unique word with its occurrence count.
Answered by AI
View 1 more answer

Round duration - 30 minutes
Round difficulty - Easy

Q1. 
Anagram Pairs Verification Problem
Your task is to determine if two given strings are anagrams of each other. Two strings are considered anagrams if you can rearrange the letters of one string to form the...read more
Ans. 
Check if two strings are anagrams of each other by comparing their sorted characters.
• Sort the characters of both strings and compare them.

• Use a dictionary to count the frequency of characters in each string and compare the dictionaries.

• Ensure both strings have the same length before proceeding with comparison.

• Handle edge cases like empty strings or strings with different lengths.
Answered by AI
Add your answer

Round duration - 45 minutes
Round difficulty - Medium

Q1. 
Palindromic Substrings Problem Statement
Find the total number of palindromic substrings in a given string STR.
Example:
Input:
"abbc"
Output:
5
Explanation:
The palindromic substrings are: ["a", "...read more
Ans. 
Count the total number of palindromic substrings in a given string.
• Iterate through each character in the string and expand around it to find palindromic substrings.

• Use dynamic programming to store previously calculated palindromic substrings.

• Consider both odd and even length palindromes while counting.

• Example: For input 'abbc', palindromic substrings are ['a', 'b', 'b', 'c', 'bb']. Total count is 5.
Answered by AI
Add your answer
Q2. How can you find the 4th highest salary from a table in a database?
Ans. 
To find the 4th highest salary from a table in a database, you can use a SQL query with the ORDER BY and LIMIT clauses.
• Write a SQL query to select distinct salaries from the table in descending order.

• Use the LIMIT clause to retrieve the 4th row from the sorted list.

• The query would look like: SELECT DISTINCT salary FROM table_name ORDER BY salary DESC LIMIT 3, 1
Answered by AI
Add your answer