DC Design Interview Questions and Answers

Q1. Write SQL query to return the latest login date for each primary key?
Ans. 
SQL query to return latest login date for each primary key
• Use GROUP BY clause to group by primary key

• Use MAX() function to get the latest login date

• Join the tables if necessary
Answered by AI
Add your answer
Q2. How to find the number of times a number repeats in an array (with less time complexity)?
Ans. 
Use a hashmap to store the frequency of each number in the array.
• Create a hashmap to store the frequency of each number in the array.

• Iterate through the array and update the frequency in the hashmap.

• Retrieve the frequency of the desired number from the hashmap.
Answered by AI
Add your answer
Q3. Validate an array based on a set of rules, with less time complexity.
Ans. 
Use regular expressions to validate array elements efficiently.
• Use regular expressions to define the rules for validation.

• Iterate through the array and apply the regular expression to each element.

• Return true if all elements pass the validation rules, false otherwise.
Answered by AI
Add your answer

The aptitude test included questions from mathematics from chapters such as P/L , %age, etc. and reasoning type questions. There were some grammar related, general knowledge related questions. The third was from computer basics as for my job excel and computer knowledge was required.

Q1. Typing test via software.
Add your answer
Q2. About my college project.
Add your answer
Q3. How would I manage my study and job?
Add your answer

Q1. Prepare a presentation on how you reached the office from you home and what happened till interacting with the HOD.
Ans. 
I took a bus to the office, stopped for coffee on the way, and had a brief chat with a colleague before meeting the HOD.
• Took a bus from home to the office

• Stopped for coffee at a nearby cafe

• Had a brief chat with a colleague in the office

• Interacted with the HOD in a scheduled meeting
Answered by AI
Add your answer
Q2. About yourself.
Add your answer

I am writing automation and clicking on aptitude test.

I am writing automation and clicking on assignment test.

Q1. Hey guys? How is it going. I gotta work for it. This is an automation task.
Add your answer
Q2. Hey guys? How is it going. I gotta work for it. This is an automation task testing.
Add your answer

Q1. Hey guys? How is it going. I gotta work for it. This is an automation task.
Add your answer
Q2. Hey guys? How is it going. I gotta work for it. This is an automation task. Yes
Add your answer

This is an automation test. I got this task from my senior. I'm doing good.

I am writing automation and clicking on aptitude test.

I am writing automation and clicking on assignment test.

Q1. Hey guys? How is it going. I gotta work for it. This is an automation task.
Add your answer
Q2. Hey guys? How is it going. I gotta work for it. This is an automation task testing.
Add your answer

Q1. Hey guys? How is it going. I gotta work for it. This is an automation task.
Add your answer
Q2. Hey guys? How is it going. I gotta work for it. This is an automation task. Yes
Add your answer

This is an automation test. I got this task from my senior. I'm doing good.