Answer / debi

1.no we can't set more than one primary key for a table
3. yes we can write a query like select 8 from table1,table2
this is generally used in case of cartesian product

Answer / koushik roy

1. A table can only have one primary key.
2. Answer #1 is right. To add it, primary key is clustered
index and when we index a column (non-primary key) it is
non-clustered index.
3. Yes this will act almost as OUTER join

Answer / 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

Answer / ramya

1)No We can't have more than 1 primary key. Even if you try
to save it will pop an error message and nothing will be stored.
2)Clustered Index is attached with Unique. A table can have
1 and only 1 Clustered Index and it will be mostly created
on the Primary Key of the Table.
Non Clustered can be up to 254(not sure about the
number)created for a single table.
3)You can definitely select from 2 tables but all the
columns will be merged. Please check how you want the data
from those 2 tables

Answer / madhusudan bowenpalli

1. No.

2.when create primary key on a table clustered index
automatically created.1 clustered index is possible for a
table.
when we create a unique key on table Non clustered index
automatically created. 253 non clustered indexes are
possible for a table.

3. yes (its not recommended)

Answer / manub22

1.There cannot be more than 1 Primary Keys for a given table?

2.Difference between Cluster Index and non-Clustered Index, check this link: http://sqlwithmanoj.com/2011/03/02/clustered-vs-nonclustered-indexes-and-data-sorting/

3.Yes, we use query like this "Select * from Table1, Table2;". This will give a Cross Join (or cartesian-product) results from both the tables.

Answer / 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.

Answer / 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

What is difference between rownum and rowid?

0 Answers  

What is the difference between clustered index and primary key?

0 Answers  

We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

0 Answers   Amdocs, Apps Associates,

What is a periodical index?

0 Answers  

Detail about the hardware which is supported by SQL server?

0 Answers  

Explain sub-query?

0 Answers  

What is filestream?

0 Answers  

Can a function call a stored procedure in sql server?

0 Answers  

what purpose does OPENXML clause have in sql server stored procedure?

1 Answers  

what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

0 Answers  

You want to implement the many-to-many relationship while designing tables. How would you do it?

0 Answers  

you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

0 Answers