Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 12813

Difference between Cluster and Non-cluster index?

32 131460

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

1556

What is the difference between NOROW and LOCKROW?

1800

explain different types of jions with examples briefly?

2 6832





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

2 5841

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

2 6104

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 9724

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

2 8164

How do you fine the performance tunning?

2 6533

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

6 56352

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 18019

Differences between functions and stored procedures?

8 11169

event classes in sql server

2 5750

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

12 14343

Post New Accenture SQL Server Interview Questions




Accenture SQL Server Interview Questions


Un-Answered Questions

What is the main use of rotary phase converter ?

329


List major difference between protractor vs selenium?

258


What is a shell script in windows?

298


What purpose do Work Workers serve and what are some of their benefits?

232


Define condel()?

1






Does node.js provide debugger?

52


Is angularjs difficult to learn?

190


Explain about the box cox transformation in regression models?

49


Can any one provide the inspection procedure of MIMIC for VFD panel? Details: If someone wants to have a mimic in the VFD panel what are inputs considered for the mimic(like on,off,trip) whether we are able to add speed variation in the mimic(if so how can we get) and what are the parameters to be checked in the MIMIC during inspection?

1391


What is the purpose of using additional actions infotype (aai)?

295


What Is Encryption?

290


What is python literal?

211


how many clauses are there in iso? give me the clauses details?

1837


Does zend framework support php 7?

75


what r the main attributes of test automation?

1198