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 11020

Difference between Cluster and Non-cluster index?

 32 125479

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

 1309

What is the difference between NOROW and LOCKROW?

 1486

explain different types of jions with examples briefly?

 2 6006




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

 2 5091

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

 2 5271

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 8743

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

 2 7363

How do you fine the performance tunning?

 2 5749

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

 6 54334

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 15298

Differences between functions and stored procedures?

 8 9532

event classes in sql server

 2 4923

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

 11 12167

Post New Accenture SQL Server Interview Questions




Accenture SQL Server Interview Questions





Un-Answered Questions

What is the difference between a site definition and a site template?

13

What is the white precipitate produced at the end of point?

17

What is the difference in accessing db between sql server vs sql azure?

18

what is purpose of maintaining common distribution channels and common division??????

29

Can we declare an interface as final?

12




How to write the program on full-duplex communication on bidirectional?

5

What is the difference between a client & customer in a SAP BI Project?? Is it same?

2928

why is not useing in boiler skin thermocople

3371

What is the purpose of void class?

26

What is the unsecured configurations and how can we access from plug-in code?

3

List the forecast models involved.

9

What would you use to view contents of a large file? How to copy/remove file? How to look for help on a Linux?

5

Explain what are the steps for creating basic or vertical forms?

1

What is the use of infocube in the bw system?

13

what is the primary difference between the xml.sendandload method and the xml.load method? : Adobe flash

7