e-Zest Senior SQL Server Database Administrator Interview Questions and Answers

Q1. What do mean by domain ?
Ans. 
A domain is a group of computers and devices on a network that share a common set of rules and procedures.
• Domains are used to manage and organize network resources.

• A domain is typically controlled by a domain controller.

• Users and computers within a domain can be managed centrally.

• Domains can have different levels of security and access control.

• Examples of domains include microsoft.com, google.com, and amazon.com.
Answered by AI
Add your answer
Q2. What is your role and responsibilities in your current company?
Add your answer
Q3. What is fault tolerance?
Ans. 
Fault tolerance is the ability of a system to continue functioning even in the event of a failure.
• It involves redundancy and backup systems to ensure continuity of operations.

• Examples include RAID storage systems, redundant power supplies, and failover clustering.

• Fault tolerance is important for critical systems where downtime can result in significant losses.

• It is often achieved through a combination of hardware and s...read more
Answered by AI
Add your answer
Q4. What is your task in hyper -v at current company?
Add your answer
Q5. What is the work of Sysvol folder ?
Ans. 
Sysvol folder is used to store Group Policy Objects and scripts for Active Directory domain controllers.
• Sysvol folder is automatically created on each domain controller when it is promoted to a domain controller.

• It contains Group Policy Objects (GPOs) and scripts that are replicated to all domain controllers in the domain.

• Sysvol folder is also used to store logon scripts, administrative templates, and security template...read more
Answered by AI
Add your answer
Q6. How will you creat a new domain in forest ?
Ans. 
To create a new domain in a forest, use Active Directory Domain Services (AD DS) installation wizard.
• Open Server Manager and select Add Roles and Features.

• Select Active Directory Domain Services and follow the installation wizard.

• After installation, open Active Directory Domains and Trusts and right-click on the root domain.

• Select New Domain and follow the wizard to create the new domain.

• Verify the new domain in Active
Answered by AI
Add your answer

Basic Apptitude. SQL & logic in

Very easy topic. You just need to have fluent English.

They took two GD as many people were selected

Q1. They asked basic and advanced SQL queries
Add your answer

Q1. The Architecture of SQL Server
Ans. 
The architecture of SQL Server involves components like storage engine, query processor, and buffer manager.
• SQL Server architecture consists of multiple components such as storage engine, query processor, and buffer manager.

• The storage engine manages data storage, retrieval, and modification.

• The query processor processes SQL queries and generates execution plans.

• The buffer manager is responsible for managing data cache...read more
Answered by AI
Add your answer
Q2. How to troubleshoot high CPU and Memory
Ans. 
To troubleshoot high CPU and Memory, monitor performance metrics, identify resource-intensive queries, optimize queries and indexes, check for memory leaks.
• Monitor performance metrics using tools like SQL Server Profiler, Performance Monitor, or DMVs.

• Identify resource-intensive queries using tools like SQL Server Management Studio or query execution plans.

• Optimize queries and indexes by rewriting queries, adding missin...read more
Answered by AI
Add your answer
Q3. Recent issues and resolution
Ans. 
Resolved recent issues related to database performance by optimizing queries and increasing server resources.
• Identified slow performing queries and optimized them by adding indexes or rewriting them

• Increased server resources such as CPU, memory, or storage to improve performance

• Implemented query caching or stored procedures to reduce load on the database server
Answered by AI
Add your answer
Q4. What is DAG, DNN and VNN
Ans. 
DAG stands for Directed Acyclic Graph, DNN stands for Deep Neural Network, and VNN stands for Virtual Neural Network.
• DAG is a graph with directed edges and no cycles, commonly used in data processing.

• DNN is a type of artificial neural network with multiple hidden layers, used in deep learning.

• VNN is a virtual neural network, a concept that may refer to a neural network implemented in a virtual environment.
Answered by AI
Add your answer

Q1. Salary discussion and shift acceptance
Add your answer

Learn basics of aptitude

Q1. Learn oops conceps and knowledge of coding in any language
Add your answer

Q1. What are your strengths and weaknesses?
Add your answer
Q2. Tell me about yourself.
Add your answer

Easy aptitude test. Nothing difficult.

Q1. Technical round involves your basic understanding of Database management systems. How it works ? What is the role of a DBA ?
Add your answer

Q1. Very normal HR round
Add your answer