AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Accenture SQL Developer Interview Questions and Answers
14 Interview questions
Transactions in SSIS can be implemented using the TransactionOption property in Control Flow tasks.
Set the TransactionOption property to Required on the Control Flow tasks that need to be included in the transaction.
Use the TransactionOption property to specify the level of transaction support needed for each task.
Transactions can be managed using the Distributed Transaction Coordinator (DTC) service.
SQL is a standard language for managing databases, while MySQL is a specific open-source relational database management system.
SQL is a standard language used to manage databases, while MySQL is a specific implementation of SQL.
SQL is an ANSI (American National Standards Institute) standard, while MySQL is an open-source relational database management system.
SQL can be used with various database management systems...
DBMS stands for Database Management System, which is a software system that allows users to define, create, maintain and control access to databases.
DBMS is a software system that allows users to interact with databases.
It helps in defining, creating, maintaining, and controlling access to databases.
Examples of DBMS include MySQL, Oracle Database, Microsoft SQL Server.
Constraints are rules that are enforced on data columns in a table to ensure data integrity and accuracy.
Constraints can be used to enforce uniqueness, primary keys, foreign keys, and check conditions on data.
Examples include UNIQUE, PRIMARY KEY, FOREIGN KEY, and CHECK constraints.
Constraints help maintain data integrity by preventing invalid data from being inserted into tables.
What people are saying about Accenture
Primary key is a unique identifier for each record in a database table.
Primary key ensures each record in a table is uniquely identified.
It must contain unique values and cannot have NULL values.
Primary key can be a single column or a combination of columns.
Example: 'id' column in a 'users' table can be a primary key.
Primary key uniquely identifies each record in a table, while unique key ensures each value in a column is unique.
Primary key does not allow NULL values, while unique key allows one NULL value.
A table can have only one primary key, but multiple unique keys.
Primary key automatically creates a unique index, while unique key does not.
Primary key is used to establish relationships between tables, while unique key is u...
SQL is a language used to manage and manipulate relational databases.
SQL stands for Structured Query Language
It is used to create, modify, and query databases
Common SQL commands include SELECT, INSERT, UPDATE, and DELETE
SQL is used in many popular database management systems such as MySQL, Oracle, and Microsoft SQL Server
Aggregate function performs a calculation on a set of values and returns a single value.
Used with SELECT statement to perform calculations on multiple rows
Examples: SUM, AVG, COUNT, MAX, MIN
Can be used with GROUP BY clause to group results by a specific column
A Database Management System (DBMS) is a software that manages and organizes data in a structured manner.
DBMS is used to create, retrieve, update, and delete data in a database.
It provides a way to store, manage, and manipulate large amounts of data efficiently.
DBMS ensures data integrity, security, and concurrency control.
Examples of popular DBMS include MySQL, Oracle, SQL Server, and PostgreSQL.
PIVOT and UNPIVOT are used to transform data from rows to columns and vice versa.
PIVOT is used to rotate rows into columns
UNPIVOT is used to rotate columns into rows
PIVOT requires an aggregate function to be specified
UNPIVOT requires the column names to be specified
PIVOT and UNPIVOT are used in T-SQL
Example: PIVOT (SUM(Sales) FOR Product IN ([A], [B], [C]))
Example: UNPIVOT (Sales FOR Product IN ([A], [B], [C]))
Accenture SQL Developer Interview Experiences
6 interviews found
Anonymous
(2 Questions)
- Q1. Explain about SSIS Architecture
- Ans.
SSIS Architecture is a platform for data integration and workflow applications.
SSIS stands for SQL Server Integration Services
It includes a data flow engine, control flow engine, and event handling
SSIS packages can be created using SQL Server Data Tools (SSDT)
SSIS packages can be scheduled and executed using SQL Server Agent
- Q2. How to implement transactions in ssis
- Ans.
Transactions in SSIS can be implemented using the TransactionOption property in Control Flow tasks.
Set the TransactionOption property to Required on the Control Flow tasks that need to be included in the transaction.
Use the TransactionOption property to specify the level of transaction support needed for each task.
Transactions can be managed using the Distributed Transaction Coordinator (DTC) service.
Interview Preparation Tips
Skills evaluated in this interview
Selected
I applied via Company Website and was interviewed in Jul 2023. There were 4 interview rounds.
An exam used to determine an individual's skill or propensity to succeed in a given activity.
(5 Questions)
- Q1. What is difference between SQL and my SQL?
- Ans.
SQL is a standard language for managing databases, while MySQL is a specific open-source relational database management system.
SQL is a standard language used to manage databases, while MySQL is a specific implementation of SQL.
SQL is an ANSI (American National Standards Institute) standard, while MySQL is an open-source relational database management system.
SQL can be used with various database management systems like...
- Q2. What is the primary key?
- Ans.
Primary key is a unique identifier for each record in a database table.
Primary key ensures each record in a table is uniquely identified.
It must contain unique values and cannot have NULL values.
Primary key can be a single column or a combination of columns.
Example: 'id' column in a 'users' table can be a primary key.
- Q3. Different between primary key and unique key?
- Ans.
Primary key uniquely identifies each record in a table, while unique key ensures each value in a column is unique.
Primary key does not allow NULL values, while unique key allows one NULL value.
A table can have only one primary key, but multiple unique keys.
Primary key automatically creates a unique index, while unique key does not.
Primary key is used to establish relationships between tables, while unique key is used t...
- Q4. What do you mean by DBMS?
- Ans.
DBMS stands for Database Management System, which is a software system that allows users to define, create, maintain and control access to databases.
DBMS is a software system that allows users to interact with databases.
It helps in defining, creating, maintaining, and controlling access to databases.
Examples of DBMS include MySQL, Oracle Database, Microsoft SQL Server.
- Q5. What are constraint?
- Ans.
Constraints are rules that are enforced on data columns in a table to ensure data integrity and accuracy.
Constraints can be used to enforce uniqueness, primary keys, foreign keys, and check conditions on data.
Examples include UNIQUE, PRIMARY KEY, FOREIGN KEY, and CHECK constraints.
Constraints help maintain data integrity by preventing invalid data from being inserted into tables.
(3 Questions)
- Q1. What do you decide to apply to this role?
- Q2. Tell me something about yourself?
- Ans.
I am a passionate SQL Developer with a strong background in database management and data analysis, eager to solve complex problems.
Over 5 years of experience in SQL development and database design.
Proficient in writing complex queries and optimizing database performance.
Worked on a project that improved data retrieval speed by 30% through indexing.
Strong understanding of data modeling and ETL processes.
Collaborated wit...
- Q3. What are your salary expectation?
Skills evaluated in this interview
I applied via Company Website and was interviewed in Nov 2023. There were 3 interview rounds.
An exam used to determine an individual's skill or propensity to succeed in a given activity.
A group discussion involves a discussion on a given topic with other candidates, usually with similar experience and educational qualifications.
Interview Preparation Tips
- SQL
- MS Office
Selected
I applied via Campus Placement and was interviewed in Mar 2023. There were 2 interview rounds.
(3 Questions)
- Q1. What are the sequel language
- Ans.
SQL is a language used to manage and manipulate relational databases.
SQL stands for Structured Query Language
It is used to create, modify, and query databases
Common SQL commands include SELECT, INSERT, UPDATE, and DELETE
SQL is used in many popular database management systems such as MySQL, Oracle, and Microsoft SQL Server
- Q2. Different types of commands
- Ans.
Different types of SQL commands include DDL, DML, DCL, and TCL.
DDL (Data Definition Language) commands are used to create, modify, and delete database objects.
DML (Data Manipulation Language) commands are used to insert, update, and delete data in a database.
DCL (Data Control Language) commands are used to control access to data in a database.
TCL (Transaction Control Language) commands are used to manage transactions i...
- Q3. What is aggregate function
- Ans.
Aggregate function performs a calculation on a set of values and returns a single value.
Used with SELECT statement to perform calculations on multiple rows
Examples: SUM, AVG, COUNT, MAX, MIN
Can be used with GROUP BY clause to group results by a specific column
Interview Preparation Tips
- SQL
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Apr 2022. There were 2 interview rounds.
(2 Questions)
- Q1. SQL interview Questions
- Q2. What is Database Management System?
- Ans.
A Database Management System (DBMS) is a software that manages and organizes data in a structured manner.
DBMS is used to create, retrieve, update, and delete data in a database.
It provides a way to store, manage, and manipulate large amounts of data efficiently.
DBMS ensures data integrity, security, and concurrency control.
Examples of popular DBMS include MySQL, Oracle, SQL Server, and PostgreSQL.
(1 Question)
- Q1. What is Delete and Truncate Command
- Ans.
Delete command is used to remove specific rows from a table, while truncate command is used to remove all rows from a table.
Delete command is a DML (Data Manipulation Language) statement.
Delete command can be used with a WHERE clause to specify the rows to be deleted.
Truncate command is a DDL (Data Definition Language) statement.
Truncate command removes all rows from a table, but keeps the table structure intact.
Trunca...
Interview Preparation Tips
- SQL
- Python
Skills evaluated in this interview
I applied via Referral and was interviewed in Jun 2021. There was 1 interview round.
Interview Questionnaire
5 Questions
- Q1. 1. What is Rank and Dense_Rank.
- Ans.
Rank and Dense_Rank are window functions used to assign a rank to each row based on a specific column value.
Rank assigns unique ranks to each row based on the column value.
Dense_Rank assigns ranks to each row based on the column value, but skips the rank if there are ties.
Both functions are used with the OVER() clause and ORDER BY statement.
Example: SELECT name, salary, RANK() OVER(ORDER BY salary DESC) AS rank FROM em...
- Q2. 2. What is SET NOCOUNT ON
- Ans.
SET NOCOUNT ON is a T-SQL statement that stops the message indicating the number of rows affected by a Transact-SQL statement.
SET NOCOUNT ON is used to improve the performance of stored procedures by reducing network traffic.
It is particularly useful when executing large scripts or batch processes.
It is also used to suppress the '(X row(s) affected)' message in SQL Server Management Studio.
To turn it off, use SET NOCOU...
- Q3. 3. What is COALESCE
- Ans.
COALESCE is a function that returns the first non-null value in a list of expressions.
COALESCE is used to simplify complex SQL statements.
It can be used with any data type.
It takes two or more arguments and returns the first non-null value.
If all arguments are null, it returns null.
Example: COALESCE(column1, column2, 'N/A') will return the value of column1 if it's not null, else column2 if it's not null, else 'N/A'.
- Q4. 4. Write the TOP 6th Salary in a table
- Ans.
Query to retrieve the 6th highest salary from a salary table using SQL.
Use the DISTINCT keyword to avoid duplicate salaries: SELECT DISTINCT salary FROM employees.
Utilize the ORDER BY clause to sort salaries in descending order: ORDER BY salary DESC.
Use the LIMIT clause (or equivalent) to fetch the 6th record: LIMIT 1 OFFSET 5.
An alternative approach is using a subquery: SELECT MAX(salary) FROM employees WHERE salary &...
- Q5. 5. What is PIVOT and UNPIVOT
- Ans.
PIVOT and UNPIVOT are used to transform data from rows to columns and vice versa.
PIVOT is used to rotate rows into columns
UNPIVOT is used to rotate columns into rows
PIVOT requires an aggregate function to be specified
UNPIVOT requires the column names to be specified
PIVOT and UNPIVOT are used in T-SQL
Example: PIVOT (SUM(Sales) FOR Product IN ([A], [B], [C]))
Example: UNPIVOT (Sales FOR Product IN ([A], [B], [C]))
Interview Preparation Tips
Skills evaluated in this interview
Interview questions from similar companies
I applied via Campus Placement and was interviewed before Jun 2020. There were 6 interview rounds.
Interview Questionnaire
1 Question
- Q1. General HR questions and some current related topic
Interview Preparation Tips
Raj Sharma
Interview Questionnaire
1 Question
- Q1. Java c c++
ganesh Kothapalli
Interview Questionnaire
1 Question
- Q1. What is document splitting
I applied via Campus Placement and was interviewed before May 2021. There were 4 interview rounds.
VERBAL QUANT DI/LR and Picture based test
(1 Question)
- Q1. Write a fibonaci series in c++ or C?
- Ans.
Fibonacci series can be easily implemented using loops in C++ or C.
Declare variables for first two numbers of the series
Use a loop to calculate and print the next number in the series
Repeat the loop until desired number of terms are printed
(1 Question)
- Q1. Informed about the policies and made us sign a document
Interview Preparation Tips
Skills evaluated in this interview
Accenture Interview FAQs
Tell us how to improve this page.
Accenture Interviews By Designations
- Accenture Associate Software Engineer Interview Questions
- Accenture Application Development Analyst Interview Questions
- Accenture Application Developer Interview Questions
- Accenture Software Developer Interview Questions
- Accenture Software Engineer Interview Questions
- Accenture Analyst Interview Questions
- Accenture Application Development Associate Interview Questions
- Accenture Senior Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
Overall Interview Experience Rating
based on 4 interview experiences
Difficulty level
Duration
SQL Developer Interview Questions from Similar Companies
Accenture SQL Developer Reviews and Ratings
based on 10 reviews
Rating in categories
|
Application Development Analyst
39.3k
salaries
|  ₹4.8 L/yr - ₹11 L/yr |
|
Application Development - Senior Analyst
27.7k
salaries
| ₹8.3 L/yr - ₹16.1 L/yr |
|
Team Lead
26.6k
salaries
| ₹12.6 L/yr - ₹22.5 L/yr |
|
Senior Analyst
19.5k
salaries
| ₹9.1 L/yr - ₹15.7 L/yr |
|
Senior Software Engineer
18.5k
salaries
| ₹10.4 L/yr - ₹18 L/yr |
TCS
Cognizant
Capgemini
Infosys
- Home >
- Interviews >
- Accenture Interview Questions
