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.

Name some usages of database trigger?

1085

---

What is sql prepared statement?

1034

---

Can we create foreign key without primary key?

1038

---

How do I create a sql database?

1055

---

What is difference between ms sql and mysql?

1016

---

How do I remove sql developer from windows 10?

1183

---

Why we use join in sql?

1025

---

Why is stored procedure faster than query?

1021

---

What is nvarchar max in sql?

1073

---

How do I add a primary key to a table?

1083

---

How many types of triggers exist in pl/sql?

1134

---

what is isam? : Sql dba

1066

---

What is normalization? How many normalization forms are there?

1141

---

Is sql a backend language?

1145

---

How you improve the performance of sql*loader? : aql loader

1063

---