Upload Button Icon Add office photos

Accenture

Compare button icon Compare button icon Compare

Filter interviews by

Accenture SQL Database Administrator Interview Questions and Answers

Updated 28 Jun 2024

Accenture SQL Database Administrator Interview Experiences

1 interview found

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-

I applied via Campus Placement

Round 1 - Aptitude Test 

It was simple round.

Round 2 - Coding Test 

It fully based on the array concept

Interview Preparation Tips

Interview preparation tips for other job seekers - please find the right job with your knowledge and interest .Thank you

Interview questions from similar companies

I applied via Naukri.com and was interviewed before Sep 2020. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Any performance tuning experience
  • Q2. What is the purpose of minimum memory configuration
  • Ans. 

    Minimum memory configuration is used to allocate the minimum amount of memory required for SQL Server to run.

    • Minimum memory configuration is used to ensure that SQL Server has enough memory to function properly.

    • It is important to set the minimum memory configuration to a value that is appropriate for the workload of the server.

    • If the minimum memory configuration is set too low, SQL Server may experience performance iss...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Have indepth knowledge on indexes, parallelism, memory architecture

Skills evaluated in this interview

I applied via Campus Placement and was interviewed before Oct 2019. There were 3 interview rounds.

Interview Questionnaire 

8 Questions

  • Q1. Which programming language do you prefer and why?
  • Ans. 

    I prefer SQL as it is the language of databases and allows for efficient data management.

    • SQL is specifically designed for managing and querying databases

    • It allows for efficient data retrieval and manipulation

    • Other programming languages can be used in conjunction with SQL for more complex tasks

    • Examples of other languages commonly used with SQL include Python and Java

  • Answered by AI
  • Q2. What you have done in your Internship and Academic project?
  • Q3. Difference between C/C++/JAVA
  • Ans. 

    C/C++ are low-level languages, while JAVA is high-level. C/C++ are compiled, while JAVA is interpreted.

    • C/C++ are used for system programming and embedded systems.

    • JAVA is used for web development and enterprise applications.

    • C/C++ have manual memory management, while JAVA has automatic garbage collection.

    • C/C++ have pointers, while JAVA does not.

    • C/C++ code is platform-dependent, while JAVA code is platform-independent.

    • Exa...

  • Answered by AI
  • Q4. What is Synchronisation in JAVA?
  • Ans. 

    Synchronization in Java is a process of controlling access to shared resources by multiple threads.

    • Synchronization is achieved using synchronized keyword or locks.

    • It prevents race conditions and ensures thread safety.

    • Example: synchronized methods, synchronized blocks, ReentrantLock.

    • Synchronization can cause performance issues if not used properly.

  • Answered by AI
  • Q5. Tell me about yourself?
  • Q6. What is Maps, Hash maps, Skeleton class OOPS concepts?
  • Ans. 

    Maps, Hash maps, and Skeleton class are OOPS concepts used in programming.

    • Maps are data structures that store key-value pairs.

    • Hash maps are a type of map that use a hash function to index the keys.

    • Skeleton class is a class that provides a basic implementation of an interface.

    • OOPS concepts are Object-Oriented Programming concepts that focus on objects and their interactions.

    • Example: HashMap in Java is a commonly used im

  • Answered by AI
  • Q7. What is a database management System and what is concept of primary key and foreign key?
  • Ans. 

    A database management system (DBMS) is a software that manages and organizes databases. Primary key uniquely identifies a record, while foreign key establishes a relationship between tables.

    • A DBMS is a software that allows users to create, manage, and manipulate databases.

    • It provides tools for creating, modifying, and deleting databases, tables, and records.

    • Primary key is a unique identifier for a record in a table.

    • For...

  • Answered by AI
  • Q8. What are joins in SQL?
  • Ans. 

    Joins in SQL are used to combine data from two or more tables based on a related column.

    • Joins are used to retrieve data from multiple tables in a single query.

    • There are different types of joins such as inner join, left join, right join, and full outer join.

    • The join condition is specified using the ON keyword and the related columns.

    • Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;

    • Joins c...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Always be specific to your answer, if you don't know just simply say i don't know. Don't use High technical terms until you're comfortable in them because it can be used against you. Don't give them chance to ask questions from your answers.

All the best 🙂

Skills evaluated in this interview

I applied via Referral and was interviewed in Apr 2022. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • Q1. Logshipping, mirroring, failover clustering and always on

Interview Preparation Tips

Interview preparation tips for other job seekers - Be strong with sql hadr scenarios and concepts. Adding dmvs in the answer make a good impression.

I applied via Naukri.com and was interviewed in Aug 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. General questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Went well with the interviewer
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Job Fair and was interviewed before Aug 2022. There were 3 interview rounds.

Round 1 - Aptitude Test 

Aptitude test was conducted.

Round 2 - Technical 

(1 Question)

  • Q1. Technical questions were asked
Round 3 - HR 

(1 Question)

  • Q1. What's the salary expectation
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. What major issues have you faced in your professional experience?
Round 2 - HR 

(1 Question)

  • Q1. What are your salary expectations for this position?

I applied via Referral and was interviewed in Mar 2022. There were 2 interview rounds.

Round 1 - Aptitude Test 
Round 2 - Technical 

(1 Question)

  • Q1. Basics of SQL and Joins

Interview Preparation Tips

Interview preparation tips for other job seekers - Work new skill of python and clouds

I applied via Company Website and was interviewed before Mar 2021. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • Q1. Interview questions which type of questions regarding databases SQL server

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview questions which question regarding databases SQL
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed in Oct 2023. There was 1 interview round.

Round 1 - HR 

(2 Questions)

  • Q1. Salary discussion
  • Q2. About previous company and quit reason

Accenture Interview FAQs

How many rounds are there in Accenture SQL Database Administrator interview?
Accenture interview process usually has 2 rounds. The most common rounds in the Accenture interview process are Aptitude Test and Coding Test.
How to prepare for Accenture SQL Database Administrator interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Accenture. The most common topics and skills that interviewers at Accenture expect are Configuration management, Consulting, DBMS, PLSQL and 11G.

Tell us how to improve this page.

Accenture SQL Database Administrator Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more
Accenture SQL Database Administrator Salary
based on 246 salaries
₹2.8 L/yr - ₹10.5 L/yr
18% less than the average SQL Database Administrator Salary in India
View more details

Accenture SQL Database Administrator Reviews and Ratings

based on 14 reviews

4.5/5

Rating in categories

4.3

Skill development

4.0

Work-life balance

4.1

Salary

4.2

Job security

4.4

Company culture

4.1

Promotions

3.9

Work satisfaction

Explore 14 Reviews and Ratings
Application Development Analyst
39k salaries
unlock blur

₹3 L/yr - ₹12 L/yr

Application Development - Senior Analyst
27.4k salaries
unlock blur

₹6.9 L/yr - ₹20.2 L/yr

Team Lead
24.7k salaries
unlock blur

₹7.1 L/yr - ₹26 L/yr

Senior Software Engineer
18.2k salaries
unlock blur

₹6 L/yr - ₹20 L/yr

Senior Analyst
17.7k salaries
unlock blur

₹5.5 L/yr - ₹21.3 L/yr

Explore more salaries
Compare Accenture with

TCS

3.7
Compare

Cognizant

3.7
Compare

Capgemini

3.7
Compare

Infosys

3.6
Compare
Did you find this page helpful?
Yes No
write
Share an Interview