Interview Questions for Accenture

Interview Questions for Accenture | What are SQL Interview Questions for Accenture?

Interview Questions for Accenture:

I have written the popular articles on SQL Questions for Deloitte technologies as well as Infosys Software.I have studied lot of Websites and i myself have experienced the SQL interview for Accenture and come up with the set of Interview Questions for Accenture.Accenture is well known US based organization which will always well known for its work life balance.

Following are some Interview Questions for Accenture which will ask for SQL,PL SQL,ETL developer Interview:

1.What is SQL?(100 % Interview Questions for Accenture )

Answer: SQL Stands for Structured Query Language which is specially designed to communicate with databases.SQL pronounced as Sequel is very widely used language in most of the database management systems like Oracle,Mysql,Postgresql etc.SQL provides us  a simple and efficient way of reading,writing,executing the data from the system.this is one of the SQL Interview Question ever asked in interviews

2.What is the use of NVL function in Oracle?(80% asked Interview Questions for Accenture )

Answer: NVL function is most important function to replace null value with another value.

Example: select NVL(null,’Amit’) from dual; which will give you output as Amit.

3.What is Correlated Subquery?Explain with the steps of execution with example.




Select * from Employee E where Not exist

(Select Department_no From Department D where E.Employee_id=D.Employee_ID);

Execution of query:

Step 1:

Select * from Employee E ;

It will fetch the all employees

Step 2:


(Select Department_no From Department D where E.Employee_id=D.Employee_ID);

Step 3:


4.What is difference Between UNION and UNION All?(90 % asked in Interview Questions for Accenture )

Operators in SQL
Union and Union all


Union Union ALL
1.Union Set operator is used to fetch the records from 2 different tables which eliminates the duplicate records 1.Union all Set operator is used to fetch the records from 2 different tables which does not eliminates the duplicate records

Select col1,col2…from table1;


Select col1,col2…from table2;


Select col1,col2…from table1;


Select col1,col2…from table2;

3.For Performance tuning Union operator is not preferable as it takes time to eliminate duplicate records 3.Union all is preferable operator in Performance tuning.

5.What is raw datatype?


Raw datatype is used to store values in binary data format.

There are 2 types of RAW datatype:


2.Long Raw.

Long raw datatype is used to store graphics,sound documents.


6.What is materialised view and what are its different fields while creating it?

Answer :

Materialized view is also logical structure of one or more table in which data is stored physically in the view.Data has been stored physically in materialized view so data retrieval is faster as compare to simple view.

There are following different options we used to create materialized view or snapshot.

1.Build Immediate:

Means materialized views(mv) created immediately.

2.Build Deferred:

Means materialized views(mv) created after one refresh.

3.Refresh on commit:

This option commited the data in materialized view in SQL immediately after data inserted and committed in table.This option is known as incremental refresh option.View is not fully refreshed with this option

4.Refresh on Demand:


7.Explain the difference between view and materialized view?

Answer :

View Materialized Views(Snapshots)
4.There are 2 types of views:

1.Simple View

2.Complex view

4.There are following types of Materialized views:

1.Refresh on Auto

2.Refresh on demand


8.Explain different Joins in SQL?



Joins in SQL
Joins in SQL

1.Inner join:


2.Outer join:


2.1.Left outer join:


2.2.Left outer join:


2.3.Full Outer Join:


3.Cross join/Cartesian join:


Click Here to get information about SQL joins..

9.What is mean by complete refresh in materialized view?


Without a materialized view log, Oracle Database must re-execute the materialized view query to refresh the materialized view. This process is called a complete refresh. Usually, a fast refresh takes less time than a complete refresh.A materialized view log is located in the master database in the same schema as the master table. A master table can have only one materialized view log defined on it. Oracle Database can use this materialized view log to perform fast refreshes for all fast-refreshable materialized views based on the master table.To fast refresh a materialized join view, you must create a materialized view log for each of the tables referenced by the materialized view.

10.What is the query to fetch number of employees departmentwise?


select count(EMPNO), b.deptno, dname from emp a, dept b where a.deptno(+)=b.deptno group by b.deptno,dname;


11.What is the result of following query?



The null=null is always the Answer of this query is Rahul.

12.What is Index?What is use of index in SQL?


Index is optional structure associated with the table which may or may not improve the performance of Query.In simple words suppose we want to search the topic in to book we go to index page of that book and search the topic which we want.Just like that to search the values from the table when indexing is there you need not use the full table scan.

Indexes are used to improve the performance of the query.

13.What is the query to find the students who get the marks in between 30-50?

Tell different ways.


Select * from Student where marks between 30 and 50;

Select * from Student where marks>=30 and marks<=50;

14.What are advantages of Indexes?(90 % asked in Interview Questions for Accenture )



Following are advantages of Indexes:

1.It allows faster retrieval of data


3.It avoids the table access alltogether

4.Indexes always speeds up the select statement.

5.Indexes used to improve the Execution plan of the database

15.What is parser?



There are 2 functions of parser:

1.Syntax analysis

2.Semantic analysis

16.What are Explicit Indexes?




create index indexname on tablename(columnname);


Create index IND_Employee_ID on Employee(Employee_ID);

17.What is Bit-map index?Explain with Example.(90 % asked in Interview Questions for Accenture )









CREATE BITMAP index  BM_DEPT_NAME on DEPT(Department_name);

18.What is not null constraint?


By default, a table column can hold NULL values. The NOT NULL constraint enforces a column to NOT accept NULL values.

The NOT NULL constraint enforces a field to always contain a value. This means that you cannot insert a new record, or update a record without adding a value to this field.

19.What is first and last function in SQL?


The FIRST and LAST functions can be used to return the first or last value from an ordered sequence. Say we want to display the salary of each Employee, along with the lowest and highest within their department we may use something like.



20.What is visible/invisible property of index?




21.How to Find table name and its owner?


To Find table name and its owner following query is used:

Select table_name,Owner from All_tables order by table_name,owner;


22.What is mean by implicit index.Explain with example.


Whenever we define unique key or primary key constraints on the table  the index will automatically create on the table.These indexes are known as implicit indexes because these are created implicitly whenever the constraint has been applied to the table.These indexes are normal indexes not unique indexes.The indexes are normal because the columns already have defined as unique so uniqueness is already been applied.


Create table Employee

(Employee_ID  varchar2(20) primary key,

Employee name varchar2(50),

salary number(10,0) not null);

If We check description of table:

Desc Employee;

Name                     Null                 Type


Employee_ID        not null      varchar2

Employee_name                      varchar2

Salary                    not null         number

Here you will see index is already created for Employee_ID as it has defined primary key.

Reader Experience – Akansha 

In this section i would like to explain the different questions faced by our reader Akanksha.

Question 1 :what are the issues you faced while development in which you got stuck and how would you able to come out of that and what you have learn?

Answer :

There are so many issues we have faced while doing development and we had stuck at some point.

Scenario 1 :

The first scenario is we need to insert big data with using PL SQL statement.We were using simple insert statement in PL SQL coding. It was taking so much time to insert the data in to table. So we had stuck there but after that we have changed the solution and use Append hint with insert statement.

Scenario 2 :

I would like to explain another scenario where we need to use Email validation.We had written one function for that but we need to use that validation in only one PL SQL object. We had changed the solution and added Email validation using regular expression.

Check here :

Email validation | Email validation in SQL | Email validation Function in SQL

Question 2 : can we have another column in a table other than a primary key column which will act as a primary key?

Answer :

Yes we can have another column in the table other than primary key which acts like primary key.But in database design this is not the recommended.One table can have only one primary key. But if you create other column with unique and not null constraint it acts like primary key.

Question 3 : how will you optimize a function in which we have to pass a value between 1 to 5 repeatedly? 

Answer :

This is pretty simple question for performance tuning . The Function contains parameter which has to pass values between 1 to 5 repeatedly. User needs to use index for that specified column. The values needs to be passed repeatedly as 1 to 5 means there are 5 distinct values. So user needs to use bitmap index for that parameter column.

Second way is user needs to create new table which contains values 1 to 5  and use that table in the function. It also improves the performance of that function.

Question 4 : How the triggers will execute if two or more triggers?

Answer :

The trigger execution will be set according to follows clause in Oracle 11G.Lets say there are 3 trgiggers T1,T2 and T3 triggers.User needs to check follows clause in the trigger.

T2 follows T1

T3 follows T2

The above examples says After T1 T2 trigger will execute and after that T3 trigger will execute.

Question 5 : If a emp table is having duplicate emp_id then can we make it primary key?

Answer :

We cant make it Primary key with duplicate values.

These are some important interview questions for accenture.Hope you like it.If you like it dont forget to share it.