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;"
Answer Posted / anilreddy
1)No,but in single primary key we can select upto 16 columns
2)Clustered index can be only one,Nonclustered indexes can be 249
3)Yes,we can write cross join will be applied
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to find the service pack installed? : sql server database administration
what is database replicaion? : Sql server database administration
What are the types of containers in ssis?
Define indexes?
How to change server name in sql server?
What are various ways to enhance the ssrs report?
How to replace given values with null using nullif()?
Explain how you can configure a running aggregate in SSRS?
Difference between DELETE and TRUNCATE?
Can sql servers linked to other servers?
Why we use the openxml clause?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
Mention the uses of stored procedures.
How to verify the port number of the sql server?
What is the purpose of indexing?