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 13780

Difference between Cluster and Non-cluster index?

 32 134844

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

 1686

What is the difference between NOROW and LOCKROW?

 1966

explain different types of jions with examples briefly?

 2 7249

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

 2 6240

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

 2 6547

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 10251

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

 2 8555

How do you fine the performance tunning?

 2 6954

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

 6 57248

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 19650

Differences between functions and stored procedures?

 8 12074

event classes in sql server

 2 6165

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

 12 15539

Post New Accenture SQL Server Interview Questions


Accenture SQL Server Interview Questions


Un-Answered Questions

Explain about arguments of addeventlistener() method?

3

What are Pull and Push Methods?

1591

Hello, I have attened interview on Selenium and I cleared technical,Hr round in accenture through Sourceone Consultancy on 23,July,2011.I send all my documets and EAF and BG forms.They told me that we will send offer letter next day .but they did n't send offer letter till now ...Can anyone please comment on this

7744

What is instanceof keyword?

534

How do I clear my inbox?

1




Do you enjoy doing independent research?

1420

what are the authentication modes in sql server? How can it be changed? : Sql dba

516

What relational operators if statements in c++?

472

What is the limitation of groovy?

3

Can you instantiate the math class in Java?

444

Explain about struts dispatch action?

402

How many types of organizations we can establish in India?

451

What can be achieved by using correlation research method to find the statistical data?

1

Find MAXIMUM of three distinct integers using a single C statement

473

What is the delimiter syntax is PHP's default delimiter syntax

491