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 11366

Difference between Cluster and Non-cluster index?

 32 126967

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

 1375

What is the difference between NOROW and LOCKROW?

 1575

explain different types of jions with examples briefly?

 2 6187




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

 2 5227

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

 2 5428

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 8959

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

 2 7545

How do you fine the performance tunning?

 2 5906

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

 6 54961

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 15945

Differences between functions and stored procedures?

 8 9857

event classes in sql server

 2 5142

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

 11 12770

Post New Accenture SQL Server Interview Questions




Accenture SQL Server Interview Questions


Un-Answered Questions

What is ems queue?

40

how can i settle the party ac with cr & dr

1035

What does sharding mean?

57

Why is xaml important for the delivery of e-commerce solutions? : xaml

90

write test case for gmail login page

3914




How do I use a less than or greater than on a message selector in ejb-jar.xml? : BEA Weblogic

73

What are the uses of namespaces?

78

What uses unix operating system?

63

Define tm1 architecture?

1

What do you understand by the term client-server application?

73

what is extern

396

What is skeleton and stub?

87

Give an account of free style 293 cells ?

907

Why doesn't the system allow you to change the tax category in a gl account master? : fi- general ledger accounting

95

Is flexbox part of css3?

9