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 11267

Difference between Cluster and Non-cluster index?

32 126401

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

1349

What is the difference between NOROW and LOCKROW?

1545

explain different types of jions with examples briefly?

2 6119





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

2 5164

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

2 5358

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 8857

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

2 7471

How do you fine the performance tunning?

2 5845

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

6 54707

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 15675

Differences between functions and stored procedures?

8 9720

event classes in sql server

2 5043

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

11 12506

Post New Accenture SQL Server Interview Questions




Accenture SQL Server Interview Questions





Un-Answered Questions

Explain the difference between drop and truncate commands in sql?

66


What are decorators in angular?

25


I want to put this query to SENIOR & EXPERIENCED ELECTRICAL ENGINEERS. 1)I want to know about the control circuit diagrams for control panels. I found it difficult to understand. Is there ant booklet through which we can learn the circuit diagrams? 2)I want to learn about conduiting, laying cables, preparing cable schedules and various techniques which is the part of building infrastucture(construction field). I don't have any experience in this area. I have experience in control panels only. that's why i am not getting any opening in building infrastucture (construction field).Can I get the job in this field as Trainee Engineer? How to enter this field? I need job in PUNE

952


Are Utility Services Affected?

74


What is meant by pulse triggered devices?

71






Is there possible to Test Transformer for Overfluxing Capability. Or is there any firm who does Overfluxing Test on Transformer?

1922


Mention some of the most commonly used directives in angularjs application?

35


What is the difference between multimeter

763


What is replication factor?

3


What Are The Different Types Of Loans Offered By Commercial Banks?

108


What is the main difference between soap and rest web services?

31


How do you set up a table of contents in word 2013?

9


rents part of its building for a monthly fee of $1,250. The rent for the month just past has not been received.

1067


What do you mean by caching in teradata?

43


How to connect to a sql server using odbc_connect()?

75