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.

What is trigger types of trigger?

1047

---

What is a pdo connection?

1007

---

Can a composite key be null?

959

---

Explian rowid, rownum? What are the psoducolumns we have?

984

---

how to select first 5 records from a table? : Sql dba

962

---

Does sql between include endpoints?

989

---

How do I view a view in sql?

936

---

what are the difference between clustered and a non-clustered index? : Sql dba

1013

---

What are the different types of constraints?

1151

---

What is a data definition language?

1078

---

What is varchar used for?

1068

---

What is sql trigger example?

1029

---

What is the reports view in oracle sql developer?

953

---

How to download oracle sql developer?

1083

---

what is a cursor? : Sql dba

1002

---