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 15054

Difference between Cluster and Non-cluster index?

 32 140174

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

 1934

What is the difference between NOROW and LOCKROW?

 2363

explain different types of jions with examples briefly?

 2 7998

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

 2 6970

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

 2 7249

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 11267

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

 2 9269

How do you fine the performance tunning?

 2 7642

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

 6 58551

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 22593

Differences between functions and stored procedures?

 8 13627

event classes in sql server

 2 6905

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

 12 17638

Post New Accenture SQL Server Interview Questions


Accenture SQL Server Interview Questions


Un-Answered Questions

Can we have more than one package statement in the source file?

737

What is the difference between global variables and local variable

616

What is the purpose of using bindActionsCreators?

207

Where can I see the parameter values in the clipboard ( values ..) I am passing one activity to other?

216

What does ‘hooks’ comprise of in git?

1




What molecule is characteristically prevalent in sour milk and tired muscles?

635

WHAT IS MEANT BY PROJECT MANAGEMENT STRATEGIES IN INSTRUMENTATION?

3124

Can mongodb replace oracle?

1

What is the role of the ozone layer for the living beings?

117

What will happen if someone adds oil to the fuel of four stroke bike engine?

817

Define entrust privacy service?

428

What are the functional areas? User groups? And how does abap/4 query work in relation to these?

693

Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com

1742

What is phase transfer catalyst?

738

What are the methods used to control the corrosion? : Electrochemistry Corrosion

663