Answer Posted / murali krishna penke

we can create more than one primary key in a table. the
maximum allowed to create primary keys for columns is 16,
but we call it primary key for one column only and the
remaining we call it as composite primary key..

create table TestPrimaryKey(ID int,Name nvarchar(50),Email
nvarchar(50),Phone nvarchar(12),cellphone nvarchar
(10),primary key(ID,Name,Email,Phone,cellphone))

the above table creates primary key for all above mentioned
columns.

How do I quit sql?

963

---

What is full form of rtm?

1008

---

What are tuples in sql?

1136

---

Can unique keys be null?

912

---

How do you determine the current isolation level? : Transact sql

1158

---

What is keys and its types?

1075

---

What is numeric function sql?

1064

---

Is not null in sql?

997

---

What are the types of variable use in pl sql?

1081

---

How to display the records between two range in Oracle SQL Plus?

1147

---

What is the use of sql trace?

952

---

How do you remove duplicates without using distinct in sql?

977

---

What is the difference between the conventional and direct path loader? : aql loader

1153

---

What does select top 1 do in sql?

1098

---

What is recursive stored procedure?

1099

---