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 11492

Difference between Cluster and Non-cluster index?

 32 127700

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

 1412

What is the difference between NOROW and LOCKROW?

 1613

explain different types of jions with examples briefly?

 2 6267




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

 2 5296

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

 2 5493

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 9066

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

 2 7636

How do you fine the performance tunning?

 2 5994

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

 6 55220

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 16253

Differences between functions and stored procedures?

 8 10020

event classes in sql server

 2 5213

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

 11 13016

Post New Accenture SQL Server Interview Questions




Accenture SQL Server Interview Questions


Un-Answered Questions

What are the uses of delegates in c#?

117

how many display types available in sas bi dashboard? : Sas-bi

111

How exchange rates are maintained in sap

943

What is a tooltip text?

11

Explain why the feeding frequency to a microprocessor is twice the operating frequency?

95




What is aggregator module?

12

Explain the types of payrolls in oracle hrms.

119

What is fail fast in java?

82

What is object and class in oops?

102

How many tabs are in a sheet?

7

What is an external dos command?

17

What is the difference between the html and css?

17

What is python used for today?

71

How is the indent amount customized?

61

What is bean factory, have you used xmlbean factory?

95