Add office photos
Filter interviews by
Valliyappan & Co., Chartered Accountant SQL Database Administrator Interview Questions and Answers
Valliyappan & Co., Chartered Accountant SQL Database Administrator Interview Experiences
1 interview found
(5 Questions)
- Q1. Tell about my study
- Ans.
Pursuing bcom final year 1year diploma couse DFA
- Q2. Tell about my hobbies
- Ans.
My hobby is I like most doing exercise and meditation Reading books and newspaper
- Q3. My qualifications
- Q4. My nature in people
- Q5. Good way of talking
Top trending discussions
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
Valliyappan & Co., Chartered Accountant Interview FAQs
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 >
- Valliyappan & Co., Chartered Accountant Interview Questions >
- Valliyappan & Co., Chartered Accountant SQL Database Administrator Interview Questions
