Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Be Interview Ready
Welcome Guest !
You're designing a new SQL Server 2012 table that will hold millions of records. The table will be used by a finance application to show historical transactions. 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?
on 7/30/2014 | Category:
Sql Server Interview questions
| Views: 515 |
Select from following answers:
A table MUST have ONLY one Primary Key
Show Correct Answer
Many Interviews |
< Previous :
The transaction isolation level controls the locki ...
Next > :
As part of a new HR project you're creating se ...
Comments or Responses
Login to post response
More Interview Questions by Bandi
As part of a new HR project you're creating several stored procedu ...
Which word is missing from the following statement to create a stored ...
You need to write a new query that will return names from the employee ...
You're designing a new query that will return all of the medical r ...
What is wrong with the T-SQL batch statement below: @find varchar(3 ...
SQL Server 2012 uses the standard four-part naming convention when ref ...
You're creating a new query that will select rows from a products ...
You need to delete a stored procedure from the SQL Server 2012 databas ...
Latest Interview Questions
By default,Asp.Net stores SessionIDs in which mechanism?
In order to prevent a browser from caching a page which of the stateme ...
We have defined one page_load event in aspx page and the same is defin ...
How to display a computer code in html
What is the FEATURES or PURPOSE of Raise Error?
Can a Clustered Index ALSO be a Unique Index?
Which statement is used for defining a Cursor?
Which Process is used for Maintaining State Server Session in Asp.Net ...