Tech Mahindra SQL Database Administrator Interview Questions and Answers

Test your algorithmic thinking and problem solving skills

Q1. Communications,clearity of answers
Add your answer

Q1. Discussion about packages,joining date
Add your answer

Q1. Difference between view and stored procedure
Ans. 
Views are virtual tables that display data from one or more tables, while stored procedures are precompiled SQL statements that can accept parameters and perform actions.
• Views are read-only and cannot accept parameters, while stored procedures can be used to perform complex logic and can accept input parameters.

• Views are used for simplifying complex queries and providing a layer of abstraction, while stored procedures ...read more
Answered by AI
Add your answer
Q2. What is DBCC ? Explain
Ans. 
DBCC stands for Database Console Commands. It is a set of commands used to perform maintenance tasks on a SQL Server database.
• DBCC CHECKDB - used to check the logical and physical integrity of all objects in a database

• DBCC SHRINKDATABASE - used to shrink the size of a database

• DBCC SQLPERF - used to display performance statistics for SQL Server

• DBCC TRACEON - used to enable a specific trace flag for troubleshooting purpo
Answered by AI
Add your answer

It was simple round.

It fully based on the array concept

Q1. Salary discussion
Add your answer
Q2. About previous company and quit reason
Add your answer

Q1. What major issues have you faced in your professional experience?
Add your answer

Q1. What are your salary expectations for this position?
Add your answer

It was a normal assessment including coding questions and then English Test.

Q1. Basic questions about DB, OS and Networking
Add your answer

Aptitude test was conducted.

Q1. Technical questions were asked
Add your answer

Q1. What's the salary expectation
Add your answer