SDG Software Ddsm Interview Questions and Answers

1 hour online test ..

Q1. Programming related questions.
Add your answer

Q1. DSA round (easy to medium)
Add your answer

Q1. Technical+ hr round
Add your answer

Q1. Technical questions.
Add your answer

Q1. How make a queue using a stack
Ans. 
To implement a queue using a stack, use two stacks and simulate the queue operations.
• Use two stacks, one for enqueue operation and one for dequeue operation.

• For enqueue operation, simply push elements onto the stack used for enqueueing.

• For dequeue operation, if the dequeue stack is empty, pop all elements from enqueue stack and push onto dequeue stack.

• Then pop from the dequeue stack to simulate dequeue operation.
Answered by AI
Add your answer
Q2. Create a linked list
Ans. 
A linked list is a data structure consisting of nodes where each node points to the next node in the sequence.
• Create a Node class with data and next pointer

• Initialize a head pointer to null

• Add nodes by updating next pointers

• Traverse the list by following next pointers
Answered by AI
Add your answer

Q1. Highlight the odd cells in excel
Ans. 
Use conditional formatting to highlight odd cells in Excel
• Select the range of cells you want to highlight

• Go to the 'Home' tab and click on 'Conditional Formatting'

• Choose 'New Rule' and select 'Use a formula to determine which cells to format'

• Enter the formula '=MOD(A1,2)=1' (assuming A1 is the top-left cell of your selected range)

• Choose the formatting style you want for the odd cells
Answered by AI
Add your answer
Q2. What are Joins in SQL, explain different joins and their outputs
Ans. 
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• INNER JOIN returns rows when there is at least one 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

• FU...read more
Answered by AI
Add your answer
Q3. Query to give running sum of salary
Ans. 
Use window function to calculate running sum of salary in SQL
• Use window function like SUM() with OVER() clause

• Partition the data by employee ID if needed

• Order the data by date or any other relevant column
Answered by AI
Add your answer

It was ok. I was not able to solve all the questions.

Q1. Remove the last element from a linkedlist
Add your answer
Q2. Some basic questions on oops dbms and os
Add your answer

Q1. What is normalization
Ans. 
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
• Normalization helps in minimizing data redundancy by dividing the database into multiple tables.

• It ensures data integrity by avoiding update anomalies.

• Normalization is achieved through a series of rules called normal forms, such as 1NF, 2NF, 3NF, etc.

• Example: In a database, instead of storing customer details i...read more
Answered by AI
Add your answer
Q2. What is reflection
Ans. 
Reflection is the ability of a program to examine and modify its own structure and behavior at runtime.
• Allows accessing metadata of types and members at runtime

• Enables dynamic instantiation of objects

• Facilitates invoking methods dynamically
Answered by AI
Add your answer

The interviewer asked about javascript basics and DSA questions and some typescript questions

Q1. Tell me about
Add your answer
Q2. Your self they are asking
Add your answer
Q3. What is your weakness
Add your answer
Q4. Any questions ask for me
Add your answer
Q5. All the best future
Add your answer

Coding for international

Q1. Self Introduction
Add your answer
Q2. Salary Expectation
Add your answer

Q1. 14 questions in excel formulas
Add your answer