Buy Questpond's video subscriptions on
huge discount
.
Online: 3755
Home
Articles
Interviews
Forums
For Beginners
Popular Questions
ITIL Career Advice
PMP Career Advice
Career Advices
Codes
Videos
ASP.NET
ASP.NET MVC
Android Intel XDK
Sql Server
AngularJS
Bootstrap
Backbone.JS
MongoDB
LESS (CSS)
jQuery
WPF
WWF
SSIS
LightSwitch
Tutorials
News
ASP.NET MVC
|
Be Interview Ready
|
Top Performers
|
DNF MVP
|
Top Posts
|
Winners
|
Subscribe
|
Catalogs
Welcome Guest !
Register
Login
Home
>
Interviews
>
Sql Server
>
Loading ...
One table has historical transactions details. The table only has 10 columns but it's vital that the table performs well. How many primary keys should you create for the table for best performance?
Posted by
Bandi
on 11/12/2013 | Category:
Sql Server Interview questions
| Views: 3849 |
Points: 40
Post
|
Interview FAQs
|
Exclusive Questions
|
Interview Home
Select from following answers:
2
1
10
3
All Above
A table can have only one PRIMARY KEY per table....
So obviously answer is 1 primary key
Show Correct Answer
Asked In:
Many Interviews |
Alert Moderator
Bookmark It
< Previous :
What is missing from the T-SQL statement below for ...
Next > :
Which of the following would be a correct way to c ...
Comments or Responses
Login to post response
More Interview Questions by Bandi
Which of the following would be a correct way to call the stored proce ...
How can you add carriage returns to text when inserting into a table?
Which one of the following objects is a special kind of stored procedu ...
Which of the following conversions is NOT allowed either implicitly or ...
How to inactivate/disable Parameter in SSRS 2008 Report?
How to get the list of processes which are blocked in SQL SERVER?
How to print the following pattern using SQL server: * * * * * * ...
What is CHOOSE() function in SQL Server?
Latest Interview Questions
How does Garbage Collector works?
What is the maximum capacity of a DataTable in ADO.NET?
What is the use of Html.ValidationSummary helper method in ASP.NET MVC ...
How to write dashed attributes of html (5) element using ASP.NET MVC H ...
What is the use of ViewStart in ASP.NET MVC?
What different types of Scaffold templates are there in ASP.NET MVC?
you need to identify Is Always a number Is Always greater than a 65, ...
What is a Linked Server?
More ...