Add office photos
Filter interviews by
Furious Computer Solutions SQL Database Administrator Interview Questions and Answers
Be the first one to contribute and help others!
Interview questions from similar companies
Selected
I applied via Referral and was interviewed in Sep 2024. There was 1 interview round.
(2 Questions)
- Q1. What is dirty read.
- Ans.
Dirty read is when a transaction reads data that has been modified by another transaction but not yet committed.
Occurs when a transaction reads uncommitted data from another transaction
Can lead to inconsistent or incorrect results
Can be prevented by using proper isolation levels in database transactions
- Q2. What all processes occurres when a db restarts.
- Ans.
When a database restarts, various processes occur such as recovery, rollback, and reapplying transactions.
Recovery process ensures that the database is in a consistent state by rolling back uncommitted transactions and redoing committed transactions.
Rollback process undoes any changes made by transactions that were not committed before the restart.
Reapplying transactions involves re-executing transactions that were com...
I applied via Company Website and was interviewed in Apr 2024. There were 3 interview rounds.
Test your algorithmic thinking and problem solving skills
(1 Question)
- Q1. Communications,clearity of answers
(1 Question)
- Q1. Discussion about packages,joining date
Interview Preparation Tips
I applied via Campus Placement
It was simple round.
It fully based on the array concept
Interview Preparation Tips
Raj G
Selected
I applied via Approached by Company and was interviewed in Oct 2023. There was 1 interview round.
(2 Questions)
- Q1. Salary discussion
- Q2. About previous company and quit reason
(1 Question)
- Q1. What major issues have you faced in your professional experience?
(1 Question)
- Q1. What are your salary expectations for this position?
Selected
I applied via Campus Placement and was interviewed before Feb 2023. There were 2 interview rounds.
It was a normal assessment including coding questions and then English Test.
(1 Question)
- Q1. Basic questions about DB, OS and Networking
SQL Database Administrator Interview Questions & Answers
Tech Mahindra
Anonymous
posted on 26 May 2022
I applied via Referral and was interviewed in Apr 2022. There was 1 interview round.
(1 Question)
- Q1. Logshipping, mirroring, failover clustering and always on
Interview Preparation Tips
Selected
I applied via Job Fair and was interviewed before Aug 2022. There were 3 interview rounds.
Aptitude test was conducted.
(1 Question)
- Q1. Technical questions were asked
(1 Question)
- Q1. What's the salary expectation
(2 Questions)
- 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 ...
- 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
Skills evaluated in this interview
Selected
I applied via Company Website and was interviewed before Oct 2023. There were 4 interview rounds.
Basic, intermediates lavel
SQL queries, SQL database administrator
(2 Questions)
- Q1. Backup -Restore , migration, upgradation
- Q2. HA, mirroring, replication,user roles permission etc
(2 Questions)
- Q1. Interest,hobby etc
- Q2. Salary discussion
Interview Preparation Tips
Tell us how to improve this page.
Interview Questions for Popular Designations
- Oracle Database Administrator Interview Questions
- Database Developer Interview Questions
- SQL Server Database Administrator Interview Questions
- Senior Database Administrator Interview Questions
- MS SQL DBA Interview Questions
- Database Engineer Interview Questions
- Database Architect Interview Questions
- Mysql Database Administrator Interview Questions
- Show more
SQL Database Administrator Interview Questions from Similar Companies
TCS
Accenture
Wipro
Cognizant
- Home >
- Interviews >
- Furious Computer Solutions Interview Questions >
- Furious Computer Solutions SQL Database Administrator Interview Questions
