Accenture
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
I applied via Naukri.com and was interviewed in Aug 2024. There was 1 interview round.
Use SQL query with ORDER BY and LIMIT to find 2nd or nth highest salary
Use ORDER BY clause to sort salaries in descending order
Use LIMIT to specify the number of rows to return
For 2nd highest salary: SELECT salary FROM employees ORDER BY salary DESC LIMIT 1, 1
For nth highest salary: SELECT salary FROM employees ORDER BY salary DESC LIMIT n-1, 1
Slowly changing dimensions are dimensions in a data warehouse that change slowly over time.
Slowly changing dimensions are used to track historical changes in data over time.
There are three types of slowly changing dimensions: Type 1, Type 2, and Type 3.
Type 1: Overwrites old data with new data, losing historical information.
Type 2: Creates a new record for each change, preserving historical data.
Type 3: Creates a new f...
I applied via Naukri.com and was interviewed in Oct 2024. There was 1 interview round.
BigQuery is a cloud-based data warehouse that uses SQL-like queries, but with some key differences from traditional SQL databases.
BigQuery is designed for large-scale data processing and analytics in the cloud.
BigQuery uses a columnar storage format for faster query performance.
BigQuery is fully managed and serverless, meaning users don't have to worry about infrastructure management.
BigQuery supports nested and repeat...
Optimizing SQL code involves using indexes, minimizing data retrieval, avoiding unnecessary joins, and optimizing queries.
Use indexes on columns frequently used in WHERE clauses
Minimize data retrieval by selecting only necessary columns
Avoid unnecessary joins by using EXISTS or IN clauses instead
Optimize queries by using appropriate functions and operators
It was a mix of apti and coding questions.
Accenture interview questions for designations
I applied via Company Website and was interviewed in Sep 2024. There was 1 interview round.
Exception handling in Java involves try, catch, finally, and throw keywords.
Use try block to enclose the code that may throw an exception
Use catch block to handle the exception
Use finally block to execute code after try/catch blocks
Use throw keyword to manually throw an exception
To call an overridden method, use the super keyword followed by the method name.
Use 'super' keyword followed by the method name to call the overridden method.
Example: super.methodName();
The final keyword in Java is used to restrict the user from changing the value of a variable, making it constant.
Final variables cannot be reassigned once initialized
Final methods cannot be overridden in subclasses
Final classes cannot be extended
Get interview-ready with Top Accenture Interview Questions
I applied via Referral and was interviewed in Oct 2024. There was 1 interview round.
Interview was good.
Interviewer was patient.
He asked me questions as below:
1. Write a function to accept 5 subject marks and in each subject student must have scored atleast 40 marks in each subject based on it you have to tell whether student passed or fail.
2. Generators in Python
3. If i have to download multiple images from a web and have to process them using multithreading using a Python Script. Which libraries will you use.
They took my interview and after few days emailed me saying they have filled this position and any offers that may have released were withdrawn.
Worst experience.
You should know this before taking candidate's interview.
Wasting candidate's as well as interviewers time.
I applied via Naukri.com and was interviewed in Oct 2024. There were 2 interview rounds.
Doesn't want to share the details
I applied via Naukri.com
SQL is a relational database management system, while NoSQL is a non-relational database management system. Springboot annotations are used for configuration in Spring applications.
SQL is table-based, with a predefined schema, while NoSQL is document, key-value, wide-column, or graph-based, with a dynamic schema.
SQL is best suited for complex queries and transactions, while NoSQL is better for hierarchical data storage...
I was interviewed in Oct 2024.
Parallel cursor method is a technique used in database programming to improve performance by processing multiple rows simultaneously.
Parallel cursor method allows multiple rows to be fetched and processed concurrently, reducing overall processing time.
It is commonly used in scenarios where large datasets need to be processed efficiently.
By leveraging parallel cursor method, developers can optimize database operations a
Yes, I can debug CDS views by using tools like SQL Trace and ABAP Debugger.
Use SQL Trace to analyze the SQL statements executed by the CDS view
Use ABAP Debugger to step through the code and analyze variables
Check for any syntax errors or logical errors in the CDS view definition
I applied via LinkedIn and was interviewed in Jun 2024. There was 1 interview round.
To find the second largest number in an array using JavaScript, sort the array in descending order and return the element at index 1.
Sort the array in descending order using the sort() method.
Access the element at index 1 to get the second largest number.
ES6 is the newer version of JavaScript with added features like arrow functions, classes, and let/const declarations.
ES5 is the fifth version of ECMAScript, released in 2009.
ES6, also known as ECMAScript 2015, introduced new features like arrow functions, classes, let/const declarations, template literals, and spread/rest operators.
ES6 also added features like default parameter values, destructuring assignments, and pr...
React lifecycle consists of three main stages: Mounting, Updating, and Unmounting.
Mounting: Component is created and inserted into the DOM.
Updating: Component is re-rendered due to changes in props or state.
Unmounting: Component is removed from the DOM.
Examples: componentDidMount() is called during Mounting stage, componentDidUpdate() during Updating stage, and componentWillUnmount() during Unmounting stage.
3 Interview rounds
based on 268 reviews
Rating in categories
Application Development Analyst
38.9k
salaries
| ₹3 L/yr - ₹12 L/yr |
Application Development - Senior Analyst
27.6k
salaries
| ₹6.8 L/yr - ₹20.2 L/yr |
Team Lead
24.2k
salaries
| ₹7 L/yr - ₹25.5 L/yr |
Senior Software Engineer
18.4k
salaries
| ₹6 L/yr - ₹19 L/yr |
Software Engineer
17.6k
salaries
| ₹3.6 L/yr - ₹12.7 L/yr |
TCS
Cognizant
Capgemini
Infosys