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 14677

Difference between Cluster and Non-cluster index?

 32 138271

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

 1842

What is the difference between NOROW and LOCKROW?

 2219

explain different types of jions with examples briefly?

 2 7722

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

 2 6737

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

 2 7014

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 10960

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

 2 9022

How do you fine the performance tunning?

 2 7432

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

 6 58063

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 21449

Differences between functions and stored procedures?

 8 13004

event classes in sql server

 2 6641

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

 12 16781

Post New Accenture SQL Server Interview Questions


Accenture SQL Server Interview Questions


Un-Answered Questions

Describe the test procedure to determine the vector group

1589

What are the advantages of a centrifugal pump over a reciprocating pump?

626

What does the ng stand for in angular?

400

What is the default font used in ms word 2013 document?

329

How many types of sessions in asp.net?

571




What is a sympy?

498

What is the main difference between Asp.net and Vb.net?

559

What is a Transformation?

557

What is impersonation, and when would you use impersonation?

460

What is java panel swing?

506

define string ?

660

What is a news article?

545

How do I fix werfault exe?

514

Explain database engine

7

What is the difference between Repo Rate and Reverse Repo Rate?

669