AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
i
Infosys
Compare
Filter interviews by
Infosys SQL Server Database Administrator Interview Questions, Process, and Tips
Top Infosys SQL Server Database Administrator Interview Questions and Answers
- Q1. What is the resource database and system database in sql server
- Q2. How many types backup is available in sql server.
- Q3. what is recovery model in sql server.
Infosys SQL Server Database Administrator Interview Experiences
4 interviews found
Selected
I applied via Company Website and was interviewed in Mar 2024. There were 2 interview rounds.
Sql,databasemanagement System
(6 Questions)
- Q1. Self interoduction
- Q2. What is your strength
- Ans.
My strength lies in my ability to troubleshoot and optimize SQL Server databases efficiently.
Strong knowledge of SQL Server architecture and best practices
Experience in performance tuning and query optimization
Ability to troubleshoot and resolve database issues quickly and effectively
- Q3. What is your weekness
- Ans.
My weakness is sometimes I can be overly critical of my own work.
I tend to be a perfectionist and can spend too much time on a task
I am working on improving my ability to delegate tasks to others
I have been taking steps to practice self-compassion and not be too hard on myself
- Q4. Why should you hire
- Ans.
I have the necessary skills, experience, and passion to excel in this role.
I have extensive experience in managing SQL Server databases, including performance tuning, backup and recovery, and security.
I am proficient in writing complex SQL queries and stored procedures to optimize database performance.
I have a strong understanding of database design principles and normalization techniques.
I am proactive in staying up-t...
- Q5. Why do you want to job
- Ans.
I am passionate about managing and optimizing databases to ensure smooth operations and data integrity.
I have a strong background in database administration and enjoy working with SQL Server.
I am motivated by the challenge of ensuring data security and performance.
I believe my skills and experience make me a strong fit for this role.
- Q6. What is your goal in life
- Ans.
My goal in life is to continuously learn, grow, and make a positive impact on others.
Constantly seek new opportunities for personal and professional development
Strive to make a difference in the lives of those around me
Set and achieve meaningful goals to fulfill my potential
Interview Preparation Tips
I applied via Recruitment Consultant and was interviewed in Oct 2021. There was 1 interview round.
Interview Questionnaire
2 Questions
- Q1. Company have a good skills in sql server DBA
- Q2. I have certificate of sql server DBA and i'll do it.
Interview Preparation Tips
I applied via Company Website and was interviewed in Apr 2022. There were 2 interview rounds.
Interview Preparation Tips
I was interviewed before Sep 2016.
Interview Questionnaire
8 Questions
- Q1. Tell me something about your self.
- Ans.
I am a dedicated and experienced SQL Server DBA with a strong background in database management and optimization.
Over 5 years of experience in SQL Server database administration
Proficient in performance tuning, backup and recovery, and security management
Skilled in troubleshooting and resolving database issues
Certified in SQL Server administration (e.g. MCSA: SQL Server)
- Q2. Have you any experience.
- Ans.
Yes, I have experience working as a SQL Server DBA for 5 years.
Managed and maintained SQL Server databases
Performed database backups and restores
Optimized database performance
Implemented security measures
Troubleshooted and resolved database issues
- Q3. What is your expectation
- Ans.
My expectation is to contribute my expertise in SQL Server administration to optimize database performance and ensure data integrity.
Optimizing database performance through index tuning and query optimization
Implementing security measures to protect sensitive data
Monitoring database health and performance using tools like SQL Server Profiler
Troubleshooting and resolving database issues in a timely manner
- Q4. What do you know about database.
- Ans.
A database is a structured collection of data that is organized and stored for easy access, retrieval, and management.
A database is used to store and manage large amounts of data.
It provides a way to organize and structure data for efficient storage and retrieval.
Databases use tables to store data in rows and columns.
SQL (Structured Query Language) is commonly used to interact with databases.
Databases can be relational...
- Q5. What is sql server.
- Ans.
SQL Server is a relational database management system developed by Microsoft.
Developed by Microsoft
Used for storing and retrieving data
Supports SQL language for querying and managing databases
- Q6. What is the resource database and system database in sql server
- Ans.
The resource database is a read-only system database that stores system objects and metadata for SQL Server. System databases are essential for the functioning of SQL Server.
The resource database is hidden and cannot be accessed directly by users or administrators.
It contains all the system objects that are included with SQL Server, such as system views and stored procedures.
The resource database is used to upgrade sys...
- Q7. How many types backup is available in sql server.
- Ans.
There are 4 types of backups available in SQL Server: Full, Differential, Transaction Log, and File/Filegroup.
Full backup: It backs up the entire database including all data and objects.
Differential backup: It backs up only the changes made since the last full backup.
Transaction Log backup: It backs up the transaction log, allowing point-in-time recovery.
File/Filegroup backup: It backs up individual files or filegroups
- Q8. What is recovery model in sql server.
- Ans.
Recovery model in SQL Server determines how transactions are logged and how the database can be restored.
There are three recovery models in SQL Server: Simple, Full, and Bulk-Logged.
Simple recovery model automatically truncates the transaction log and only allows restoring to the most recent full or differential backup.
Full recovery model logs all transactions and allows restoring to a specific point in time using tran...
Interview Preparation Tips
Experience: This round was around 10 to 15 minute. I felt very easy and enjoying.
Round: Technical Interview
Experience: Database is a collection of data.This is a entity of any rdbms.table,view stored procedure and trigger are the object of the data base. we can create user in database and merge with login so that any user can connect to data and databse.
sql server is relational database management system, which is used to access and manipulate the data from database.
we have four types of system database master,model,msdb,tempdb and one is resource databse.
we have four types of backup full, differential, transactional log backup,and one is copy only backup.
Round: Test
Duration: 1 hour
Total Questions: 45
Skills evaluated in this interview
Infosys interview questions for designations
What people are saying about Infosys
Interview questions from similar companies
SQL Server Database Administrator Interview Questions & Answers
TCS
PANKAJ KUMAR
posted on 9 May 2023
I applied via Approached by Company and was interviewed in Apr 2023. There were 3 interview rounds.
(1 Question)
- Q1. All about MS SQL SERVER
(1 Question)
- Q1. All about MS SQL SERVER
SQL Server Database Administrator Interview Questions & Answers
Wipro
Anonymous
posted on 24 Aug 2022
I applied via Company Website and was interviewed in Jul 2022. There were 2 interview rounds.
Question in sql and plsql about
Interview Preparation Tips
- SQL Server
- PLSQL
- Dynamic sql
Presentation layer
Business layer
Data layer
SQL Server Database Administrator Interview Questions & Answers
Accenture
Anonymous
posted on 8 May 2022
I applied via Company Website
It was good experience to complete tgat
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Oct 2024. There were 2 interview rounds.
(1 Question)
- Q1. What is pull request
- Ans.
A pull request is a method of submitting contributions to a project on GitHub for review and merging.
Pull requests are commonly used in version control systems like Git to propose changes to a codebase.
They allow developers to collaborate and discuss changes before merging them into the main branch.
Pull requests typically include a description of the changes, related issues, and any necessary tests or documentation.
Rev...
(1 Question)
- Q1. What is sateful set
- Ans.
Stateful set is a Kubernetes controller that manages the deployment and scaling of a set of pods with persistent storage.
Stateful set ensures that each pod in the set has a unique identity and stable network identity.
Stateful set pods are created in order and are not replaced until they are deleted.
Stateful set is commonly used for stateful applications like databases where each pod requires persistent storage.
Example:...
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Jun 2024. There was 1 interview round.
(4 Questions)
- Q1. Start up parameters of sql server
- Ans.
Start up parameters are used to configure the behavior of SQL Server when it starts up.
Start up parameters are specified in the SQL Server Configuration Manager.
Common start up parameters include -d (database files location), -e (error log location), -m (single user mode), -T (trace flags), etc.
Start up parameters can be modified to customize the behavior of SQL Server during startup.
Example: -dC:\Program Files\Microso...
- Q2. Differential backup query
- Q3. Sql server statics
- Q4. Log file architecture
Interview Preparation Tips
Skills evaluated in this interview
(2 Questions)
- Q1. Dataguard architecture
- Q2. Rman backup and restoration
(1 Question)
- Q1. Why you join inm
- Ans.
I joined inm because of the company's reputation for innovation and growth in the tech industry.
Attracted to company's reputation for innovation
Excited about opportunities for growth in tech industry
Impressed by company culture and values
Infosys Interview FAQs
Tell us how to improve this page.
Infosys Interviews By Designations
- Infosys System Engineer Interview Questions
- Infosys Software Engineer Interview Questions
- Infosys Technology Analyst Interview Questions
- Infosys Associate Consultant Interview Questions
- Infosys Senior Systems Engineer Interview Questions
- Infosys Software Developer Interview Questions
- Infosys Business Analyst Interview Questions
- Infosys Senior Associate Consultant Interview Questions
- Show more
Interview Questions for Popular Designations
- SQL Database Administrator Interview Questions
- SQL Server Developer Interview Questions
- MS SQL DBA Interview Questions
- Oracle Database Administrator Interview Questions
- Database Developer Interview Questions
- Senior Database Administrator Interview Questions
- Senior SQL Developer Interview Questions
- Database Engineer Interview Questions
- Show more
Infosys SQL Server Database Administrator Interview Process
based on 3 interviews
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
Infosys SQL Server Database Administrator Reviews and Ratings
based on 6 reviews
Rating in categories
|
Technology Analyst
55.9k
salaries
|  ₹3 L/yr - ₹11 L/yr |
|
Senior Systems Engineer
50.4k
salaries
| ₹2.8 L/yr - ₹8 L/yr |
|
System Engineer
39.5k
salaries
| ₹2.5 L/yr - ₹5.5 L/yr |
|
Technical Lead
30.8k
salaries
| ₹5.2 L/yr - ₹19.5 L/yr |
|
Senior Associate Consultant
27.7k
salaries
| ₹6.2 L/yr - ₹16.8 L/yr |
TCS
Wipro
Cognizant
Accenture
- Home >
- Interviews >
- Infosys Interview Questions >
- Infosys SQL Server Database Administrator Interview Questions
