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
- 8695 Views
- I also Faced
- E-Mail Answers
Answer Posted / prasanna
1.We cant see more than one primary key for the table,
however we could create composite index using clustered
index in a table.
2.Clustered index - Order the data in the physical order.
Non clustered index does not order the data
3.We can select both the table using that script which u
mentioned.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What are trace flags and mention a few common trace flags used with sql server?
What is 5nf in normalization form?
What Is Rdbms?
What is serializable?
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
How to get a list of columns in a view using the "sp_columns" stored procedure?
What is truncate table?
What is the purpose of the model database?
what is the different types of backups available in sql server? : Sql server database administration
What does the on update no action do?
What is a bit datatype?
Why Master database is required?
How to sort query output in descending order in ms sql server?
Tell me what is difference between view and materialized view?
What new changes are being made in SQL Server?
