Deloitte SQL Server Database Administrator Interview Questions and Answers

Q1. Technological working experience question
Add your answer

Q1. Technology and architect
Add your answer

Q1. Expectations of the roll
Ans. 
The expectations of the role include leading software development projects, mentoring junior engineers, and collaborating with cross-functional teams.
• Lead software development projects from conception to delivery

• Mentor junior engineers and provide guidance on best practices

• Collaborate with cross-functional teams to ensure project success
Answered by AI
Add your answer

Multiple choice questions on language of your choice

Solve any 2 case studies out of 3.
2 classes design LLD.
1 SQL db design

Q1. Oop, DSA basic and medium level questions.
Add your answer

Coding test based on Array , Map ,set and linked list

Q1. Kotlin, core android and project related questions
Add your answer

Q1. Client round - kotlin , di , coding and core android questions
Add your answer

Q1. Salary discussions only
Add your answer

Q1. Questions related to background. Resume based.
Add your answer

Q1. Area of interest - Backend, frontend, databases, cloud etc
Add your answer

Q1. Areas of interest - Backend, frontend, databases, cloud, etc
Add your answer

Q1. Behavioral interview with the Parter/Principal
Add your answer

Q1. Life cycle around Static Constructor
Ans. 
Static constructor is called only once during the lifetime of a class.
• Static constructor is used to initialize static fields of a class.

• It is called automatically before the first instance of the class is created.

• It cannot be called directly and cannot have any access modifiers.

• It can be used to perform one-time initialization tasks such as setting up a database connection.

• If an exception is thrown during static constr
Answered by AI
Add your answer
Q2. SOLID principle deep dive
Add your answer

Q1. SSRS reports - Why temp tables are used and not regular tables?
Ans. 
Temp tables are used in SSRS reports for performance optimization and to reduce resource consumption.
• Temp tables are used to store intermediate results during report generation, reducing the need to repeatedly query the database.

• Regular tables can lead to locking and contention issues in multi-user environments, while temp tables are session-specific and do not cause conflicts.

• Temp tables can be indexed and optimized f...read more
Answered by AI
Add your answer
Q2. Table group and cache look-up
Add your answer

Q1. Infra architechture
Add your answer
Q2. Form patterns - D365FO
Add your answer

Q1. Why are you looking for job change?
Add your answer

Round duration - 90 Minutes
Round difficulty - Medium

Q1. 
Duplicate Integer in Array
Given an array ARR of size N, containing each number between 1 and N-1 at least once, identify the single integer that appears twice.
Input:
The first line contains an integer...read more
Ans. 
Identify the duplicate integer in an array containing numbers between 1 and N-1.
• Iterate through the array and keep track of the frequency of each element using a hashmap.

• Return the element with a frequency greater than 1 as the duplicate integer.

• Ensure the constraints are met and a duplicate number is guaranteed to be present.
Answered by AI
Add your answer

Round duration - 45 Minutes
Round difficulty - Medium

They wants to Check your Problem solving techniques with best case and how you approach a problem and the way you solve
they wants to solve in more than one way 
also they ask basic Questions Related to your frame Work you are working

Q1. 
Anagram Pairs Verification
In this task, you need to verify if two provided strings are anagrams of each other. Two strings are considered anagrams if you can rearrange the letters of one string to form t...read more
Ans. 
Verify if two strings are anagrams of each other by rearranging their letters.
• Create character frequency maps for both strings.

• Compare the frequency of characters in both maps to check if they are anagrams.

• Return 'True' if the frequencies match, else return 'False'.
Answered by AI
Add your answer

Round duration - 20 Minutes
Round difficulty - Easy

General About yourSelf and How was your previous round and CTC discussion

Q1. Can you discuss the CTC (Cost to Company) offered in this position?
Ans. 
The CTC offered for this position is competitive and includes salary, benefits, and bonuses.
• CTC includes salary, benefits, bonuses, and other perks

• Negotiation may be possible based on experience and skills

• CTC details are typically discussed during the final stages of the interview process
Answered by AI
Add your answer