Accenture SQL Server Interview Questions Answers, Accenture Placement Papers, Accenture Technical, HR Interview Questions, Accenture Aptitude Test Questions, Accenture Campus Placements Exam Questions

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 15901

Difference between Cluster and Non-cluster index?

32 146238

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

2333

What is the difference between NOROW and LOCKROW?

2789

explain different types of jions with examples briefly?

2 8818

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

2 7709

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

2 8032

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 12300

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

2 10143

How do you fine the performance tunning?

2 8423

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

6 60011

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 25386

Differences between functions and stored procedures?

8 15452

event classes in sql server

2 7695

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

12 20304

Post New Accenture SQL Server Interview Questions

Accenture SQL Server Interview Questions

Accenture SQL Server Interview Questions (27)

Un-Answered Questions

Now days, what makes mongodb best?

What is a storage key?

570

Mention some of the common criticisms on marketing professionals?

1072

what are s0c1, s0c4, s0c5, s0c7 abends?

1250

How do generics work in c#?

871

Describe the wcf architecture?

834

What are the foundational pillars of devops testing?

Explain the advantages of salesforce saas functionality? Close

418

How many methods for depth are available?

807

What are the components in sap application server?

1090

What is calibrated?

900

Does pdo prevent sql injection?

895

What are the different types of data warehousing?

903

Explain how do you access storage outside your cics program?

930

Why is it important to get Life Insurance?

619