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 14700

Difference between Cluster and Non-cluster index?

 32 138359

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

 1846

What is the difference between NOROW and LOCKROW?

 2231

explain different types of jions with examples briefly?

 2 7735

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

 2 6751

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

 2 7027

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 10971

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

 2 9033

How do you fine the performance tunning?

 2 7447

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

 6 58093

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)?

 16 21506

Differences between functions and stored procedures?

 8 13043

event classes in sql server

 2 6660

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

 12 16832

Post New Accenture SQL Server Interview Questions


Accenture SQL Server Interview Questions


Un-Answered Questions

What does the hotspot class in .net do?

563

Tell something about RBI and its key functions?

706

What is Keyman Insurance?

391

WHAT IS THE FUNCTION OF SHORT CIRCUIT MAINTENANCE CT

2020

How do I center text vertically in css?

271




What is thread explain the threads in linux?

407

How can you use dynamic calls in cics?

601

Which type of pneumatic control valve is used mostly Either Air to Open r Air to close the value And guys I need reason for your reason

855

How is it possible to know the number of rows returned in result set?

523

What is the typical log file size per 10k requests in an apache web server?

866

can you declare an override method to be static if the original method is not static?

548

What is mysql good for?

477

send me jto(telecom) exam papers

1497

What is cipher?

504

How do you get the last value in a list or a tuple?

482