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 are the different schemas objects that can be created using pl/sql?

1042

---

What is varchar example?

1040

---

How many subqueries can be nested in a statement?

999

---

What is orm in sql?

1052

---

How to place comments in pl/sql?

1173

---

What programs use sql?

1018

---

Does view contain data?

1041

---

What is linq to sql?

1144

---

What is secondary key?

954

---

What is clustered index in sql?

1058

---

how to show all tables with 'mysql'? : Sql dba

1128

---

what is a foreign key ? : Sql dba

1089

---

How do I turn a list into a table?

969

---

How can you select unique records from a table?

1090

---

who introduced sql?

1028

---