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
Anonymous
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
I was interviewed in Nov 2016.
Interview Questionnaire
6 Questions
- Q1. Explain Btech Project
- Ans.
Developed a Btech project on automated attendance system using facial recognition.
Developed a software application to automate the attendance process in educational institutions.
Implemented facial recognition technology to identify and mark attendance of students.
Used machine learning algorithms to train the system for accurate recognition.
Integrated the application with a database to store attendance records.
Provided ...
- Q2. Code Pascal's Traingle
- Ans.
Code Pascal's Triangle
Pascal's Triangle is a triangular array of binomial coefficients
Each number is the sum of the two numbers above it
The first and last numbers in each row are 1
Can be implemented using nested loops or recursion
- Q3. What is abstract function
- Ans.
An abstract function is a function that has no implementation and must be implemented by its subclasses.
An abstract function is declared with the 'abstract' keyword.
It is used to define a template for its subclasses to follow.
It cannot be instantiated and must be implemented by its subclasses.
It can have abstract and non-abstract methods.
Example: abstract class Animal { abstract void makeSound(); }
Example: class Dog ex...
- Q4. Difference between abstract and normal function
- Ans.
Abstract functions cannot be instantiated and must be implemented by child classes, while normal functions can be directly called.
Abstract functions have no implementation in the parent class, while normal functions do.
Abstract functions are declared with the 'abstract' keyword, while normal functions are not.
Normal functions can be called directly, while abstract functions must be implemented by child classes.
An examp...
- Q5. Your 2 weakness
- Ans.
Perfectionism and public speaking anxiety
I tend to be a perfectionist, which can sometimes lead to spending too much time on a task
I struggle with public speaking anxiety, but I have been working on improving my communication skills through practice and training
- Q6. Why Capgemini
- Ans.
Capgemini is a global leader in consulting, technology services, and digital transformation.
Capgemini has a strong reputation in the industry for delivering high-quality software solutions.
The company offers a wide range of opportunities for career growth and development.
Capgemini has a collaborative and inclusive work culture that fosters innovation and teamwork.
The company has a global presence, providing exposure to...
Interview Preparation Tips
Experience: General Aptitude and English
Round: Technical Interview
Experience: 10 minutes approx. Questions were repetitive for candidates. i.e. for 13 candidates interviewed most of those were similar.
Round: HR Interview
Experience: Other normal stuff about family.
Tips: HR might try to get under your skin so prepare for general hr questions.
College Name: IIT Patna
Skills evaluated in this interview
Senior Software Engineer Interview Questions & Answers
Tech Mahindra
ramya sumith
posted on 28 Mar 2018
I applied via Other and was interviewed in Nov 2017. There were 5 interview rounds.
Interview Questionnaire
4 Questions
- Q1. Brief Role on job and tools and technology I worked with day to day activity
- Ans.
As a Senior Software Engineer, I worked with various tools and technologies to develop and maintain software applications.
Developed and maintained software applications using Java, Python, and C++ programming languages
Used Agile methodology for software development and collaborated with cross-functional teams
Worked with various tools such as Git, JIRA, Jenkins, and Docker for version control, issue tracking, continuous...
- Q2. In-depth technical interview which went around 40 min. since i had 8 years of experience
- Q3. Fully technical
- Q4. Salary discussion and Document verification.
Interview Preparation Tips
Experience: Keywords that I put in of the technology, tools , experience.. (I guess )
General Tips: Just stay calm. Do not show fake experience, Speak genuinely, Answer to the point and explain if you have to add on more depending on your experience. Do not be over confident. Speak start to the eyes
Skills: Communication, Problem Solving, Analytical Skills, Leadership, Presentation Skills, Decision Making Skills
Duration: 1-3 Months
Senior Software Engineer Interview Questions & Answers
Capgemini
Ms. Tanushree Sengupta
posted on 3 Aug 2017
I was interviewed before Aug 2016.
Interview Preparation Tips
Experience: It was good
Total Questions: 20
Round: Technical Interview
Experience: It was good
Interview Questionnaire
2 Questions
- Q1. Simple programming and questions related to the subject in B Tech
- Q2. Testing communication
Interview Preparation Tips
Experience: Aptitude , Reasoning
I applied via Recruitment Consultant and was interviewed in Jul 2018. There were 3 interview rounds.
Interview Questionnaire
4 Questions
- Q1. What is the biggest challenge you faced in developing azure solution?
- Ans.
The biggest challenge in developing Azure solution was managing the complexity of the cloud environment.
Managing the complexity of the cloud environment
Ensuring scalability and reliability
Integrating with existing systems
Securing the solution
Optimizing cost
Example: Migrating a legacy application to Azure
- Q2. In azure data factory how would you implement the functionality of tumbling window without actually using that feature already available?
- Ans.
Implementing tumbling window in Azure Data Factory without using the feature
Create a pipeline with a trigger that runs at the desired interval
Use a lookup activity to retrieve the data for the current window
Use a foreach activity to iterate over the retrieved data
Perform the required operations on the data within the foreach activity
Write the output to the desired destination
- Q3. What would be your suggestion for implementation in azure data factory v2?
- Ans.
My suggestion for implementation in Azure Data Factory v2 is to use the Mapping Data Flow feature.
Utilize Mapping Data Flow for complex data transformations
Take advantage of the visual interface to design and debug data flows
Leverage the built-in data integration capabilities with other Azure services
Use data flow parameters and expressions for dynamic transformations
Monitor and optimize data flow performance using dat
- Q4. I was given a project scenario and was requested to choose from below cluster or cluster less , hive or u-sql?
Interview Preparation Tips
Skills: Coding Skills, Datawarehousing, Azure data factory, Problem Solving, Analytical Skills
Duration: <1 week
Skills evaluated in this interview
Interview Questionnaire
5 Questions
- Q1. Basic telephone round probably around 3 times
- Q2. About ourself and past experience
- Q3. And they really see if we are interested or not, nothing technical
- Q4. Telephone technical interview
- Q5. My role is pega developer so questions are on pega
Interview Preparation Tips
Experience: Asked each and every aspect in pega
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.5k
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Senior Systems Engineer
50.7k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
System Engineer
39.6k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Technical Lead
30.8k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Associate Consultant
28.1k
salaries
| ₹0 L/yr - ₹0 L/yr |
TCS
Wipro
Cognizant
Accenture
- Home >
- Interviews >
- Infosys Interview Questions >
- Infosys SQL Server Database Administrator Interview Questions
