Interested to Buy Any Domain ? << Click Here >> for more details...
1.can we set the more than 1 primary keys for a table?
2.please give me the difference between Cluster Index and
non-Clustered Index
3.can we use query like this "Select * from Table1,Table2;"
- 8 Answers
- 9242 Views
- I also Faced
- E-Mail Answers
Answer Posted / kishore
1.No.In a table only one primary key.we have to use the
behavior of primary key i.e in a colon to set unique key and
not null.
2.Cluster index is the leaf node directly consist a values.
and non cluster index is the leaf node consists address of
value at same task or heap.
3.No
| Is This Answer Correct ? | 2 Yes | 8 No |
Post New Answer View All Answers
Write a query to include a constraint, to check whether the employee salary is greater than 5000?
What is the difference between char, varchar and nvarchar?
As per your opinion what are the five top responsibilities of a dba? : sql server database administration
Explain the cursor lock types?
what is create database syntax? : Sql server database administration
How does the report manager work in SSRS?
Are all views updatable ?
Does partitioning improve performance sql server?
Explain full-text indexing?
Explain boyce and codd normal form(bcnf)?
What are the new features of sql server 2012 reporting service?
What are the steps you will take to improve the performance of a poor performing query?
can an automatic recovery be initiated by a user? : Sql server administration
can you implement data mining in SSRS?
What is ms sql server triggers?
