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 14680

Difference between Cluster and Non-cluster index?

 32 138284

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

 1844

What is the difference between NOROW and LOCKROW?

 2222

explain different types of jions with examples briefly?

 2 7725

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

 2 6739

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

 2 7017

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 10961

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

 2 9022

How do you fine the performance tunning?

 2 7435

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

 6 58065

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 21464

Differences between functions and stored procedures?

 8 13017

event classes in sql server

 2 6644

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

 12 16793

Post New Accenture SQL Server Interview Questions


Accenture SQL Server Interview Questions


Un-Answered Questions

How do you make a picture into a background image of a web page?

465

How to look up a Service by Port and Protocol?

1116

What are the css properties?

266

Define the term Redux in React

202

How do you check if a variable has been set in php?

505




What is xml feed url?

425

do you have any idea about the financial inclusion?

634

Detail your responsibilities in accounts receivable

598

In analytics reports we can sometimes get a lot of spam data from spam sources/domains, how to deal with this issue?

88

Will there be a windows server 2016 r2?

112

What are plan versions used for?

556

Define population growth rate?

82

how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.

1479

Explain power save mechanism?

508

What is merge sort in daa?

483