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 11641

Difference between Cluster and Non-cluster index?

 32 128461

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

 1438

What is the difference between NOROW and LOCKROW?

 1654

explain different types of jions with examples briefly?

 2 6350




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

 2 5396

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

 2 5599

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 9206

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

 2 7750

How do you fine the performance tunning?

 2 6098

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

 6 55476

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 16597

Differences between functions and stored procedures?

 8 10260

event classes in sql server

 2 5303

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

 11 13259

Post New Accenture SQL Server Interview Questions




Accenture SQL Server Interview Questions


Un-Answered Questions

If a round rectangle has straight edges and rounded corners, your roundrect class inherits both from rectangle and from circle, and they in turn both inherit from shape, how many shapes are created when you create a roundrect?

165

Which filter operation can you use to filter items with a numeric value lower than x?

1

What should one use for plugin development — custom post types or custom database tables?

24

How to know/find 32 or 64 bit in windows xp?

136

What is dl/i?

146




how can i pass a "cript"as a parameter in to a function

997

What is a password file in a database and why is it required when a user can be authenticated using data dictionary tables?

1

what is technical system, business system, logical system in sap pi7.0

1697

What is dblink?

107

What is the primary configuration file for a process scheduler server and where is it located?

548

Is it possible to pass the dynamic values to views?

9

Recent trends in Human resource?

1220

What is the difference between inheritance and encapsulation?

143

What is the purpose of the linux?

117

How is clustered index different from non-clustered index?

1