Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z




Accenture SQL Server Interview Questions
Questions Answers Views Company eMail

What is one of the first things you would do to increase performance of a query? For example, a boss tells you that ?a query that ran yesterday took 30 seconds, but today it takes 6 minutes?

2 10853

Difference between Cluster and Non-cluster index?

32 125027

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

1288

What is the difference between NOROW and LOCKROW?

1468

explain different types of jions with examples briefly?

2 5947





Which databases are part of SQL server default installation? Explain the usage of each?

2 5043

What all db objects can be found in MSDB database of a SQL Server instance?

2 5226

Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table?

3 8696

What is Query Execution Plan? How does it help optimize or tune a database driven application?

2 7326

How do you fine the performance tunning?

2 5671

What are mdf,ndf,ldf files and how to see the data in those files?

6 54168

how to find the particular row in table?(means suppose one table contain 10 rows , in these 10 rows how to find the particular row(example in 10 rows i want 5 row how)?

15 15081

Differences between functions and stored procedures?

8 9451

event classes in sql server

2 4854

1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.

11 11984

Post New Accenture SQL Server Interview Questions




Accenture SQL Server Interview Questions





Un-Answered Questions

how to calculate cost of raw materials of a building for 1000 sqft & also consolidated cost of labour in a 1000 sqft building

1768


What tools are used to develop QVCS?

1139


what is 24vdc live and dry supply

1162


What do you understand by active and passive transformations?

7


How will you get information about a file using node?

3






What is the option that can be used in PostgreSQL to make transactions see rows affected in previous parts of the transaction?

437


lenz law application and define

1472


Can I join my client computer to azure ad as well as on-premises active directory?

1


If a child class instance is created, which class constructor is called first - base class or child class?

5


What are the Data providers in ADO.Net?

15


What is the purpose of text item in item category?, How and why is it being used

819


Difference between containers and temp tables?

1


Is it possible for current p (small-business) plan customers to upgrade to the m (mid-size business) plan?

1


Consider this scenario, I have an activity in ruleset a and I want to call this activity from activity in ruleset b.is this possible? If yes, how?

1


What is the use of foreach operation in Pig scripts?

4