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 11151

Difference between Cluster and Non-cluster index?

 32 126004

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

 1328

What is the difference between NOROW and LOCKROW?

 1518

explain different types of jions with examples briefly?

 2 6065




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

 2 5126

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

 2 5315

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 8799

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

 2 7416

How do you fine the performance tunning?

 2 5800

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

 6 54518

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 15496

Differences between functions and stored procedures?

 8 9619

event classes in sql server

 2 4983

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

 11 12335

Post New Accenture SQL Server Interview Questions




Accenture SQL Server Interview Questions





Un-Answered Questions

What is a namespace and how to import them in uipath?

12

What is 51% attack?

1

What is reflexive memory?

16

Define interface in java?

31

When would you use abend command?

26




what does complexity means in an algorithim?? how it is calcutaed?

1362

How to get the query of a table in sql server?

3

What are the different taxes that you pay as a consumer?

65

any body please send me the old question papers of ongc test.

1127

What you know about Product proposal, why we use it? Where we use it?

1682

What is BCNF (Boyce-Codd Normal Form)?

43

What are the benefits of multithreaded programming?

46

What is powercenter on grid?

35

is there is any book that covers all topics of BI 7.0 and the navigation steps for bi 7.0 and pdf of 7

991

Do you know what are the steps required to modify config.xml file of web logic server?

18