Answer Posted / hari

no. a table can have only one primary key.some times table
can use composite primary key

ex create table std
(stdid bigint(10) not null,
e mailid varchar(20) not null);
primary key(stdid,e mailid)

What is duration in sql profiler trace?

1020

---

Can we rollback delete command?

934

---

how can you create an empty table from an existing table? : Sql dba

1076

---

What is normalization in a database?

1105

---

Why is sql*loader direct path so fast?

1053

---

What is Materialized View? In What Scenario we Use Materialized View?

9397

---

What is structural independence and why is it important?

978

---

What is data type in database?

931

---

When do we use triggers?

1026

---

What is the difference between a primary key and a clustered index?

929

---

Define concurrency control. : Transact sql

1103

---

What does trigger mean in slang?

1003

---

Is sql free?

886

---

how to calculate the difference between two dates? : Sql dba

993

---

Does mysql_real_escape_string prevent sql injection?

907

---